• IP TYPE CODE

    Does IP Type Code show up in transaction tab for all items during inventory count or does it only show up in the transaction tab if a count was made towards the item?
  • Negative quantities for Sale Order.

    We have 2 items in our inventory, that show an SO for a negative amount. I cannot find an orders that have negative amounts and no orders that match the quantities. For example, we on hand 110 units of product A with SO of -15 and an available inventory…
  • RETURN AND ALLOCATIONS

    I don't work in shipping but I had a shipping question brought up to me. We have a customer that placed a rather large order. They notified us that they made a mistake and ordered too much of one item. To avoid a ton of work, I did a return of just the…
  • COMMITTED ITEMS NOT ACTUALLY SHOWING ON ORDER

    Hey there I have an issue with an item showing that it is on sales order and its committed but we have no open sales orders with the item nor back orders. I'm also going to mention that we use multi bin and I can see that 7 are set in a warehouse but…
  • 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…
  • Physical Count Situation

    Hey All, I saw this post https://www.sagecity.com/us/sage100_erp/f/sage-100-distribution-manufacturing-and-internet-modules/94349/you-cannot-proceed-with-unposted-data-in-physical-count-entry , but I want to elaborate a bit to see if I can find the…
  • Bad debt and write offs

    My question is what's the correct way to bad debt an inventory item? We have an item that we want to take out of inventory and put to bad debt. I have played different scenarios in my head but not sure which way is the proper way and which GL's it's going…
  • Transferring FG inventory from one warehouse to another

    Hi! We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically. I know there is a transfer option in inventory management, but we are…
  • How to append a Lot # when transferring from 1 Whs to another?

    To start off, we are on Sage 100c Advanced v2018.2 How can we append an original Lot # when transferring qty from 1 whs to another? Create PO for Qty = 100,000. ROG the full Qty 100,000 to an offsite warehouse ("OFF") with Lot # 12345. When when…
  • Purchase order and invoice price discrepancy

    How does one correct an item received at the wrong price and billed at a cheaper price? The item cannot be returned as it has been used from inventory. Example: Item 1234 received at 1.80 ea, but billed at 1.65 ea.
  • What is the best explanation of how OVERDIST (over distribution) tiers that are created using FIFO?

    I understand how negative OVERDIST tiers occur, but a bit fuzzy on how positive OVERDIST tiers occur. Is there a good write up that someone has done that explains this process for both myself and my clients?