Stock Requirement for Open Requisitions
This report gives details of required quantities of stock greater than the on hand values in a particular supplying outlet based on open or released requisitions.
Please note: If the on hand values are sufficient to fulfil the requisitions, the products will be omitted from the report results.
- To run the Stock Requirement for Open Requisitions Report, go to Report Center > Requisition Reports > Stock Requirement for Open Requisitions report
- Double-click Stock Requirement for Open Requisitions report, or select the report and click Run Report, to open the report criteria screen, as per Fig.1
Enter report criteria to get desired results, as per Fig.2
|Outlet||Blank by default. In the Outlet list, select the supplying outlet.|
|Date Range Type||
|Period||Displays the current period per the Date Range Type criteria chosen.
Note: Will also display Inventory period option when the inventory process.
|From and To Dates||If Date Range Type = By Period the To and From dates auto populate with the current period per the Property > Setup > Accounting > Fiscal Calendar.
If Date Range Type = Date Range the To and From dates auto open to allow entering dates of choice.
When the Stock Requirement for Open Requisitions report is generated, the result should look similar to Fig.3
|Outlet||The Outlet number and name.|
|Product||The Adaco product number.|
|Description||The name/description of the product entered under Property > Products.|
|Unit||The Inventory unit|
|Required Qty||If Requisition setting = Released it displays item quantity on released but unposted outlet requisitions for the outlet.
If Requisition setting = Open it displays item quantity on released and unreleased outlet requisitions for the outlet.
|On Hand||Displays the inventory on hand for the outlet if there are requisitions required for the same date range.|
|Variance||The inventory unit quantity variance.
|Inv Cost||The inventory units item cost.|
|Variance Value||Monetary value variance
|Retail Attributes||Displays additional characteristics defined for retail Retail Attributes for retail product under Property > Products > Retail button [If applicable].|
|Purchase Information||Displays the purchase Information form the Property > Products > Purchase Info field.|
|Total Variance Value||Monetary variance of all line items