Browse By Tags

  • Scanco Warehouse and Barcoding

    Good Afternoon Does anyone have feedback on Scanco Warehouse as a solution to automate receiving inventory transfers and shipping? If you have experience with this product would you recommend it? We are struggling with the decision as the receiving…
  • I have used Sage for 30 years and need to utilize purchase order and inventory modules.

    Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.
  • Bill of Materials and Transfers

    I just want to bounce some thoughts around. We're a manufacturing and distribution company. We are trying to take into account how many boxes we use for packing our finished goods. These finished goods are sold to our intercompany via p.o and receipt…
  • Can an Inventory Depletion be Linked to the Receipt???

    First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…
  • PO's posting to Cost of Goods account?

    I have some PO's in history where some of the Inventory GL amount was split into the Cost account. This is going by the sales department Sales/Cost/Inventory accounts, where the inventory items are all using the same sales department, but as far as I…
  • DATABASE QUERY: Find qty of a particular sku that has been purchased/received since date.

    As per the subject, could someone help me with the query to find the Quantity Received since a particular date for a particular SKU ? If an order is placed for 10 of SKU(ABC) we receive 1 on date X, I'm assuming TODATEQTY would be 1. we receive…
  • Intracompany transactions

    Hello, I am very familiar on how to post intercompany transactions but not with intracompany. I am hoping someone can assist me. My business for privacy is called ABC. ABC has 3 locations, WV, KY, TN. We utilize the WO module to purchasing, including…
  • Ability to set minimum order quantities (MOQ) by vendor for items.

    Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…
  • Auto Generate A Purchase Order

    I am having a problem with some of the products in my inventory NOT populating in the Auto Generate a Purchase Order Function. These same products ARE showing up in my Re-Order by Vendor report. The Vendor IS set up. The O/H inventory IS below the…
  • Moving Inventory from 000 to 8000 Warehouse - Do i need to change every open PO for Receiving

    Hello - I am moving current inventory out of 000 to another warehouse number . My question is do I need to go into every open PO and change the warehouse number or change I make a preference change?
  • RECEIVED PO / MISSING INVOICE #

    Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…
  • Open PO Qty vs On PO qty discrepancy

    Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…
  • Additional Column for Item Part Number

    Add a column to include Item Part Number for Purchase Orders box. Other columns can be added by the user, but not this particular column. Also, allow in the pop-up box to search part number. Currently, this doesn't work for part number.
  • Can X3 handle purchases where cost is negative?

    We run Sage X3 Update 9 Patch 9. The cost of a product we buy is going negative. This occurs from time to time because the product is a by-product- sometimes the supplier can sell the by-product, but other times they have to pay us to take it. …
  • Managing Status Purchase Orders with Credit Card Terms where CC charged before Shipment

    FormerMember
    FormerMember
    I am new to Sage, so please forgive me if I am missing something. How does Sage handle managing Purchase Order status when an item is not yet received, but the credit card was already charged? For instance, if a an east coast vendor charges a credit card…
  • Quantity Avaiable field

    Hello all, I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here: Lets say I have 300pcs of an item On Hand.…
  • Inventory Goods Receipt and Payable Invoice Receipt

    New to Sage 100 Contractor with the Inventory Module. I'm having an issue with posting Goods Receipt and the Invoice Receipt. Goods Receipt was fine. Went to 12-4 and posted 500 units received. Immediately used qty 8 for Inventory Allocation 12-2…
  • INVENTORY ITEM ON SALES ORDER

    Can I automatically reference a purchase order when a inventory item is entered? I basically want to know what purchase order number an item came from when ordered. Our customer likes to know the original purchase order number for each item.. Also…
  • Auto-generate purchase order's.

    Hey guy's, So we finally added inventory to our system and we were hoping that by setting stock minimums we would be able to auto generate purchase order's. I was chatting with the tech support and they told me its not possible with the Canadian…
  • Why inventory receipt price posted by BV different than PO received price by user?

    when I received inventory of part# 5402830 with unit price of $0.14210 in PO, why it posted as $0.15122 with receipt# 20922? now its cost in inventory detail tab also shows as incorrect $0.15122? even though in inventory PO tab the price shows correctly…
  • Cannot receive inventory

    I'm using Sage 50 in the US.. and all of a sudden I just can't receive inventory for my open purchase orders.. I've been using Sage for years and now all of a sudden I can't receive inventory.. Very frustrating.. Anyone have any idea? Tha…
  • Reorganize inventory

    I have just completed a reorganization of certain inventory items to allow for a price increase of 7%. It has all worked properly but when I enter one of the changed items on a purchase order, the old and thus incorrect price comes up. I believe this…
  • Unable to delete a PO

    Hello everybody, need your help here. First, I'm using Sage 50 Quantum 2013. So here's the problem ; I'm trying to flush 2 PO out of our system but they don't want to go. Here's the error I get : "Sage 50 can not find the stock part of this transaction…