Sage 100

I'm back!!

It is one of those days - has anyone written a script or willing to write a script that does not allow a user to Ship Negative Inventory.

They are using Serialized inventory but have parts that they don't want to ship if they have a negative inventory balance.

Would prefer not have to use Lots.

Thanks in advance for your thoughts and great guidance.

------------------------------
Jacqueline Hoyte
Director of Client Services
Integrated Data Technology, Inc.
------------------------------

Serial valuation should block you from shipping without QoH.

The problem with a script is that to do it properly you have to consider more than just the one transaction vs warehouse QoH.  (Eg. if you have QoH of 5, with three invoices shipping 5 each, you'd end up with -10 after posting...).  Only Lot and Serial valuation items track committed quantities in unposted transactions.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

If the serial valuation doesn't handle every needed item, a script could be written to check the IM_ItemWarehouse field QuantityInShipping for the number of identical items in all invoice entries for comparing to the warehouse's quantity on hand. The QuantityInShipping field is updated immediately when an invoice line is completed and shouldn't cause a race condition.

------------------------------
Dan Burleson
Software Consultant
Connex Software
Corvallis OR
541-224-6642
------------------------------