Adaco: Stock Requirement for Open Requisitions Report – Fourth & HotSchedules Customer Success Portal

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

Fig.1 - Running the Stock Requirement for Open Requisitions

Report Criteria

Enter report criteria to get desired results, as per Fig.2

Fig.2 - Report Criteria for the Stock Requirement for Open Requisitions

Fields	Description
Report Type	Summary [default]: Displays by product totals. Detailed: Displays products, requisition numbers and Event details [If Applicable].
Outlet	Blank by default. In the Outlet list, select the supplying outlet.
Requisition	Released: [default]: Displays and calculates only released outlet requisitions. Open: Displays and calculates released outlet requisition(s) and unreleased outlet requisition(s).
Date Range Type	By Period: [default] When selected, this opens the Period field, populates to the current period and also allows for choosing the inventory period when inventory is in process. Month To Date: When selected, set the To Date to the current date, and allows selecting a specific From Date. Date Range: allows entering the To Date and From Date.
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.

Report Results

When the Stock Requirement for Open Requisitions report is generated, the result should look similar to Fig.3

Fig.3 - Stock Requirement for Open Requisitions results

Fields	Description
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. Calculation Variance = REQUIRED QTY - ON HAND
Inv Cost	The inventory units item cost.
Variance Value	Monetary value variance Calculation: Variance Value = VARIANCE x INC COST Example report above product 21: 96.00 x 12.50 = 1,200.00
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 Calculation: Total Variance Value = PRODUCT 1 VARIANCE VALUE + PRODUCT 2 VARIANCE VALUE + PRODUCT 3 VARIANCE VALUE etc. Example report 1200.00 + 166.68 + 25.35 etc.

Related articles