Adaco: Requisition Issue Report

Requisition Issue Report

• To run this report, go to Report Center > Requisition Reports > Requisition Issue Report
• To open the report criteria screen, double-click Requisition Issue Report or select the report and click Run Report, as per Fig.1

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

Fig.2 - Report Criteria for the Requisition Issue Report

 

Fields	Description
Supplying Outlet	Select the Supplying Outlet of the issued requisitions.
Ordering Outlet	Shows "Select All" or allows for just selected outlets.
Date Range Options	Select Start and Ending Dates: shows all the outlet requisitions that fall into the selected date range. Date Range by Period: generates the report with the selected period according to the fiscal calendars defined at Property > Setup > Accounting > Fiscal Calendar.
From Date	When Select Start and End Dates is enabled, this drop down field will allow a calendar date to be selected as the beginning date.
To Date	When Select Start and End Dates is enabled, this drop down field will allow a calendar date to be selected as the ending date.
Selection Button	Click Select to populate the dialogue box with the Outlet Requisitions that meet the criteria entered. Select the Select check box for the corresponding requisitions as needed.

 

Report Results

When the Requisition Issue report is generated, the result should look similar to Fig.3.

Fig.3 - Requisition Issue Report results
 

NOTE: The report page breaks by outlet requisition. 
 

Fields	Description
Requisition	The requisition number.
Supplying Outlet	The Supplying outlets number and name.
Ordering Outlet	The Ordering outlets number and name.
Effective Date	The Posting Date as entered in Process Outlet Requisition menu.
Posted Date	The actual date the requisition was posted [Current date].
Description	Displays the requisition description entered upon creating the requisition [if applicable].
Comments	Displays the requisition comments entered upon creating the requisition [if applicable].
Created By	Displays the Full Name of the user  that created the requisition. Property > User Center > Full Name.
Need By	The Need By date entered on the requisition.
Posted	Displays Yes if the requisition was posted or No if not posted.
Index	The line number of the product.
Product	The Adaco product number.
Product Description [Bin Number]	The name of the product and the Bin number entered under Property > Products [If applicable].
Req.Qty	The line item quantity requested.
Issued	The line item quantity issued.
Variance	Displays the discrepancy of the item quantity. Calculation: VARIANCE = ORDERED QUANTITY - ISSUED QUANTITY
Issue Size	The Requesting Unit as requested on the outlet requisition.
Inv Cost	The inventory cost of the item at the time the requisition was created.
Total	The total cost of the line items. Calculation: TOTAL = REQ QTY x INV COST
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 Cost	Monetary sum of all line items on the requisitions inventory cost. Calculation: TOTAL COST = Line Item 1 INV COST + Line Item 2 INV COST + Line Item 3 INV COST, ETC....

Note: The bottom of the page allows for manual signatures for Issued By, Received By and Posted By.

• The posted by Name  auto populates the posted by users Full Name as entered in Property > User Center menu
• The posted by Position auto populates the posted by users Title as entered in Property > User Center menu