Stock Status

Description of the report

The report“Stock Status”provides a detailed view of the item stocks available in the organization's different stores. It tracks the quantity delivered, transferred, returned and used of items, as well as their estimated monetary value. This report is crucial to ensure effective inventory management and avoid shortages or overstocks.

Detailed explanation of columns

1. Store: Name of the store where the item is stored.
2. Code: Unique reference assigned to each article to identify it.
3. Article: Designation or name of the article.
4. family: Classification of the article according to its nature or use.
5. Category: Subclassification of the article within its family.
6. Qty delivered: Total quantity of item received in stock.
7. Qty transferred to: Quantity of the item transferred to another store.
8. Returned Qty: Quantity returned to stock after use or non-compliance.
9. Qty output: Total quantity of items consumed or used.
10. Qty transferred from: Quantity of item received from another store.
11. Current remaining quantity: Actual quantity of the item still available in stock.
12. Alert threshold: Minimum stock level defined to trigger a replenishment alert.
13. Latest price: Last unit price recorded for this item.
14. PUMP (Weighted Average Unit Price): Weighted average price based on different stock entries.
15. Estimated amount: Total value of the item in stock according to the PUMP.
16. Last price amount: Total value of the item in stock based on the last recorded price.

Added value of the report

• Optimization of inventory management: Allows you to monitor the evolution of stocks in real time and anticipate replenishment needs.
• Cost control: Offers visibility on inventory valuation for better control of budgets.
• Tracking item movements: Allows you to identify the quantities delivered, transferred and used in order to better understand stock rotation.
• Reduction of risks of shortage or overstock: Thanks to indicators of available quantities and alert thresholds, it is possible to ensure optimal stock.