Inventory Levels
Last updated
Was this helpful?
Last updated
Was this helpful?
The Xoro system calculates various inventory levels, each serving a distinct function and purpose. These inventory levels provide a comprehensive overview of the inventory within the system, detailing the amount of inventory allocated to sales orders and the incoming inventory via purchase orders. This functionality aids in efficient inventory management and enables strategic planning for sales and purchases. You will find these inventory levels in the "Item Inventory Snapshot" module.
Let's have a look at the different inventory levels available in the XoroERP system.
Not Available: A “Not Available” item is considered to be damaged or not sellable in some way. Therefore it is categorized separately from “Available”. These items are usually stored in a damaged location or separate from regularly stocked goods.
Available: An “Available” item is considered to be regular on-hand inventory that can be sold. Please note that Available + Not Available = On Hand.
On Hand = Available + Not Available. Total goods both undamaged and damaged.
Net Available = Available – Allocated (this can never be a negative quantity). This is essentially the units left after allocation/waving.
ATS = Available – On Released SO - On MO(-). The Available units after being added to a Released Sales Order.
ATS (Inc PO) = Available – On Released SO + On Released PO - On MO(-). The Available units after being added to a Released Sales Order plus what is on a Released Purchase Order.
In Receiving: These are items that are on an Advanced Shipping Notice (ASN), so they are in the process of being put away into their storage locations. Once an ASN is closed they will become “Available” inventory.
On SO (Draft): These items are on open sales orders. Once the SO is released, then these items will go over to “On SO”. Closing an SO will remove the units from “On SO (Draft)”.
On SO: These are items that are on released sales orders, but they haven’t been shipped yet. Once they are shipped, they will no longer be “On SO”. Closing a SO will remove units from “On SO”.
In Picking/Allocated: Items that are in “In Picking” are on Waves and are in the process of being picked. Once the item has been shipped or produced in a manufacturing order, it will no longer be “In Picking” – instead it will be deleted from the system in the case of shipment and added to the system in the case of production.
On PO (Draft): These items are on open purchase orders. Once the PO is released, then these items will go over to “On PO”. Closing a PO will remove the units from “On PO (Draft)”.
On PO: These items are on released purchased orders. Closing a PO will remove units from “On PO”.
For the Manufacturing module in Xoro, we have added different Producible Levels that can help indicate the number of units that can be produced of a Manufacturable Item based on the Raw Material inventory. These levels are defined below:
Producible On Hand: This is the maximum number of units of the finished good that can be produced based on the “On Hand” inventory of raw materials.
Total Producible On Hand = On Hand + Producible On Hand: This is the sum of On Hand units of the item (finished good) and the maximum number of finished goods that can be produced based on the “On Hand” inventory of raw materials.
Producible Available: This is the maximum number of finished goods that can be produced based on the “Available” inventory of raw materials.
Total Producible Available = Available + Producible Available: This is the sum of available units of the item and the maximum number of finished goods that can be produced based on the “Available” inventory of raw materials. Let’s understand these levels with the help of an example: In the below example, Item RC-1600 Item is manufactured using Raw Materials Q800 and Q800-R1, and 1 unit of each raw material is consumed to manufacture the Item (Finished Goods).
The “On Hand” and the “Available” quantities of raw materials, Q800 and Q800-R1 are 10 and 12 units respectively. With this inventory, a maximum of 10 units of the Manufacturable Item RC-1600 can be produced. Hence, the “Producible On Hand” qty is 10 and the “Producible Available” qty is 10.
Producible ATS: This is the maximum number of units of the finished good that can be produced based on the “Available to Sell (ATS)” qty of the Raw materials. For example, if the ATS quantities for Raw Materials are 2 and 3. If one unit of each raw material is consumed to produced the finished good, then the Producible ATS would be “2” as maximum 2 units of finished goods can be produced with the available quantity of raw material.
Total Producible ATS = ATS + Producible ATS Qty: This is the sum of “Available To Sell” units of the Item and the maximum number of finished goods that can be produced based on the “ATS” inventory of raw materials.
Producible ATS Qty (Inc PO): This is the maximum number of units of the finished good that can be produced based on the “ATS (Inc PO)” qty of the Raw materials.
Total Producible ATS Qty (Inc PO) = ATS (Inc PO) + Producible ATS (Inc PO): This is the sum of the “Available” units of the finished good after being added to a Released Sales Order plus what is on a Released Purchase Order and the maximum number of units of the finished good that can be produced based on the “ATS (Inc PO)” qty the Raw materials.
Producible Net Available: This is the maximum number of units of the finished good that can be produced based on the “Net Available” inventory of the raw material.
Total Producible Net Available = Net Available + Producible Net Available: This is the sum of the “Net Available” units of the finished good and the maximum number of units of the finished good that can be produced based on the “Net Available” inventory of the raw material.
Producible ATS Qty (Inc MO): This is the maximum number of units of the finished good that can be produced based on the “ATS (Inc MO)” qty of the Raw materials.
Total Producible ATS Qty (Inc MO) = ATS (Inc MO) + Producible ATS (Inc MO): This is the sum of the maximum number of units of the finished good that can be produced based on the “ATS (Inc MO)” qty the Raw materials and the units of finished good that are Available To Sell, including the units on a Released Manufacture Orders.
Producible ATS Qty (Inc PO & MO): This is the maximum number of units of the finished good that can be produced based on the “ATS (Inc PO and MO)” qty of the Raw materials.
Total Producible ATS Qty (Inc PO & MO) = ATS (Inc PO & MO) + Producible ATS (Inc PO & MO): This is the sum of the maximum number of units of the finished good that can be produced based on the “ATS (Inc PO and MO)” qty the Raw materials and the units of finished good that are Available To Sell, including the units on a Released Manufacture and Purchase Orders.
