|
|
RQ230 - Department Usage Report
Run Department Usage Report (RQ230) to print a report of items issued
to the using departments.
NOTE If items were issued to requesting locations with Issues (IC21.1),
those transactions will not show on the report until General Ledger Interface
(IC130) has run.
**Processing Effect
The following describes how Department Usage Report (RQ230) functions.
The program selects all documents from the Requisition Transactions
file which meet the specified criteria for company, requesting location or
report group or requesting location attribute list, last period (period ending
date), and item type.
The program sorts the documents by company, requesting location or report
group, account number, item type, and date.
For each company, requesting location or report group or requesting
location attribute list, and account number, the program:
- Totals and reports the usage quantity for each item.
- Multiplies the usage quantity for each item times the average
unit cost of the item and reports the extended cost.
- Summarizes and reports extended cost totals by account.
For each company and requesting location or report group, the program
summarizes and reports account totals.
For each company, the program summarizes and reports requisition location
or report group totals.
Updated Files
ADDRDATA -
CKPOINT -
Referenced Files
GLADDRESS -
GLCHART -
GLSYSTEM -
ICCOMPANY -
ICLOCATION -
ICRPTGRP -
INSTCTRYCD -
ITEMMAST -
MMDIST -
MXLISTMBR -
POLINESRC -
REQLINE -
RQLOC -
RQTRANS -
WFSETUP -
INVOKED Programs
IFOB
IFSG
RQBL
IFUP
IFLU
|
