Paradigm Support Desk

Inventory Quantity Buckets

Within Paradigm there are many quantity fields that represents amounts from different processes to different forms of availability. Hereby is an explanation of what each Qty Bucket represents. 

Qty On Hand

This bucket represents the total physical quantity owned of an item. This quantity may never go below zero and Paradigm will always do a validation check on this bucket to prevent that from happening. Whenever stock is received, produced, sold or returned the Qty On Hand is adjusted accordingly. This bucket is the basis of stock control.

Qty Available

These useful buckets will tell you the quantity that is realistically available to you for use on new transactions. This is a calculated field that takes into account the Qty On Hand as well as the quantities involved in unprocessed transactions where stock is booked in/out of your system. (This excludes transactions set to 'Draft' or 'Cancelled')

 Qty Available  =  Qty On Hand  +  Qty On PO / GRN  +  Qty On Credit Note  +  Qty On WIP Out  -  Qty On SO / Invoice  -  Qty On RTS  -  Qty On WIP In - Qty On Warehouse Transfer Out + Qty On Warehouse Transfer In.


 Qty Immediately Available  =  Qty On Hand  -  Qty On Delivery Shipment  +  Qty On Credit Note  -  Qty On RTS  -  Qty On Adjust Out  +  Qty On Adjust In  +  Qty On Goods Received Note  -  Qty On Invoice - Qty On IBT Out + Qty On IBT In - Qty On Warehouse Transfer Out + Qty On Warehouse Transfer In.


 Qty In Buffer  =  Qty On Hand  -  Qty On Delivery Shipment  +  Qty On Credit Note  -  Qty On RTS  -  Qty On Adjust Out  +  Qty On Adjust In  +  Qty On Goods Received Note  -  Qty On Invoice  +  Qty On Purchase Order  +  Qty On WIP Out.

Please keep in mind that this calculation may differ depending on your system setup and Paradigm customizations.

Quantities Within Processes

Each document type has a quantity bucket of its own that represents the total quantity of an item involved in the respective process.

Qty On Purchase Order - Total quantity of stock being purchased in.

Qty On Goods Received Note - Total quantity of stock being received in.

Qty On Credit Note - Total quantity of stock being returned back into the system.

Qty On WIPOut - Total quantity of stock being produced (Work In Progress Output) 

Qty On WIPIn - Total quantity of stock being consumed in production (Work In Progress Input)

Qty On Sales Order - Total quantity of stock ordered to be sold.

Qty On Invoice - Total quantity of stock sold.

Qty On RTS - Total quantity of stock being returned to the supplier.

Qty On Delivery Shipment - Total quantity of stock to be delivered.

Qty On Adjust In - Total quantity of stock being adjusted into a warehouse (Qty Adjustment).

Qty On Adjust Out - Total quantity of stock being adjusted out of a warehouse (Qty Adjustment).

Qty On IBT In - Total quantity of stock on Inter Branch Transfers being transferred into a warehouse.

Qty On IBT Out - Total quantity of stock on Inter Branch Transfers being transferred out of a warehouse.

Qty On Warehouse Transfer In - Total quantity of stock on Warehouse Transfers being transferred into a warehouse.

Qty On Warehouse Transfer Out - Total quantity of stock on Warehouse Transfers being transferred out of a warehouse.

Quantities by Inventory Item

'Navigation' > 'Inventory' > 'Processing' > 'Inventory Items'

Quantities by Warehouse

'Navigation' > 'Inventory' > 'Processing' > 'Warehouse Inventory'



P
Paradigm is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.