When I open an Invoice (or Quote, Job or Purchase Order) what does Available Quantity mean and where do the figures come from?
The Available Qty that shows on the Invoice screen (bottom left box) indicates the Total Available Quantity (all Locations) and Total Available Quantity for the location that is selected on the Invoice.
The Total Available Quantity (all Locations) represents Instock + On Order + Back Orders – Allocated Quantity
The Total Available Quantity (for one Location) represents Instock – Allocated Quantity
The example below shows the product Double Bed having an On Hand Quantity of 28 and an Allocated Quantity of 1
This screen below shows the Location split of how the product quantity is made up.
When a Quote is opened (using the above examples) and the Location on the Quote is Auckland
the Available Qty is showing 27.00/8.00
This figure is represented by:
27.00 = Total On Hand Less Allocated Quantity (for all Locations)
8.00 = Total On Hand Quantity for the Location Auckland Less Allocated Quantity for Auckland
When the Location on the Quote is changed the Available Qty figure for the Location will change.
Example Below of Christchurch and Wellington as the Location on the Quote.