Selling into the Negative
Acctivate allows users to sell items into negative quantities based on user permissions. When a user has the ability to Override Scheduled Qty on a sales order, they have the ability to schedule an item into negative availability, as well as invoice an item causing negative on hand quantities. Instead of only considering On Hand quantity, Acctivate will calculate an "Available" quantity, which consists of:
Net Available Quantity = On Hand Quantity – Reserved – Sales Orders – Assemblies + Vendor POs
Selling into the negative can occur when you have less quantity available than there is on hand or overriding the scheduled quantity on a sales order. The example below illustrates this concept further:
When this product is placed on a Purchase Order, the On PO quantity will increase, bringing the Available quantity closer to zero. If a receipt is posted against the PO, the On Hand quantity will increase and the On PO quantity will decrease by the amount of product received. The On Hand quantity can go into the negative when a user overrides the Scheduled quantity on a Sales Order and releases the invoice. If the overridden quantity is greater than the current On Hand quantity, the product will show negative on hand. In the example above, the user would need to invoice at least 101 of this product for the On Hand quantity to be negative. There are many different scenarios in which users would see negative quantities in the Available and On Hand columns. Although these simple example do not take into consideration any assembly transactions or purchase orders, the calculation will always follow the above formula.