Stock Requirement for Open Requisitions
This report gives details of stock, total quantity on order, and variances for all open requisitions.
- 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 Requisition Issue 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