This batch process report provides a detailed snapshot of inventory. The report can be run in two modes, which are parameter driven.
· Summary – This mode gives a snapshot of counts (Available) for all products by warehouse, purpose of this mode is to provide a quick overview for available product quantity to the end users.
· Detail- This mode gives detail information for every product in a hierarchy starting from Company then to Master product and Product
The report includes warehouse information, average unit cost, reorder quantity, and all counts from INV_PRODUCT_DETAIL.
Parameter |
Description |
Required? |
|---|---|---|
Mode |
· DETAIL – displays orders in register with accounting distribution and summary. · SUMMARY – displays only the summary of the register. |
Yes |
Subtitle |
This field is used to enter in a subtitle that appears underneath the report heading. |
No |
Organization |
The Organization ID for which you want to run the report. |
Read-only |
Organization Unit |
The Organization Unit ID for which you want to run the report. |
Read-only |
Warehouse Code |
The warehouse that is selected in order to check inventory. You can only select one warehouse. |
Yes |
Use Threshold Quantity |
Enter “Y” to use a re-order threshold quantity for this report. Otherwise, enter “N”. |
No |
Re-Order Threshold |
If you entered “Y” in the Use Threshold Quantity field above, enter the quantity. This quantity is added to the Reorder Quantity (defined on the General Product Setup screen) of each product in the warehouse. This is used as a warning to the product manager that the selected products are about to reach their reorder level. |
No |