Sage 100 Warehouse Inventory prevent from going negative

SOLVED

Hello,

Is there any way to disallow negative balances for items in warehouses in Sage 100?

We currently use FIFO valuation, just looking for a way to prevent transactions that send an item in a warehouse into negative balance.

SAGE 2020 Warehouse Negative Inventory - Distribution, Manufacturing, and Internet Modules - Sage 100 - Sage City Community

I saw this thread, but we use neither Average nor Standard valuation and the role permission referenced is already unchecked for applicable roles.

EDIT:

Specifically on a transfer from warehouse to warehouse there is no warning or error message, and it allows you to transfer things as far into the negatives as you want. On an issue it provides a soft error message, but you can click right through the warning, and it will let you do it.

Is there any way to block this kind of thing from happening?

Thanks!

  • 0

    Scripted logic could help a bit, but I don't believe there is anything in regular Sage 100 to truly block OVERDIST transactions for FIFO.

  • 0 in reply to Kevin M

    Any thoughts on how you would do this with scripted logic?

  • +1 in reply to Jacob04
    verified answer

    Script a lookup to IM_ItemWarehouse to check the QoH during line entry in the various business objects.  The big problem with that is accounting for unposted transaction quantities (e.g. two invoices for 10, when you only have 10 on hand...).  Sage has fields for committed quantities, but you also have to consider, if editing a transaction, that transaction's quantity may be in the committed number.  You really have to know scripting (and the way Sage business objects work) to do it properly.

  • 0
    SUGGESTED

    You can use the Lot Costing method. Every time you receive in inventory, give it a lot code. Users will need to distribute from lots when they ship. They can't go negative with this method. It's more work but will ensure you don't get negatives.

  • 0 in reply to Sage100User

    For clients who frequently go negative in inventory (due to BAU data entry practices... delays in getting receipts entered, or production posted...) we often recommend Standard valuation.  However, for unit costs that fluctuate, Standard isn't always a great fit. 

    Lot and Serial valuations work in those scenarios, but with the extra data entry step.

    For FIFO, we suggest emailed alerts (using 3rd party reporting software) of negative (OVERDIST) inventory, but that is only possible after posting.  Prevention is... impractical.

    (Speaking of OVERDIST tiers, please vote: Idea).