RQ230 – Department Usage Report
- System
- Requisitions (RQ)
- Type
- Batch program
- Updates
- 2 tables
- References
- 15 tables
RQ230 (Department Usage Report) is a Lawson Requisitions batch program. It updates ADDRDATA and CKPOINT and references GLADDRESS, GLCHART, GLSYSTEM, ICCOMPANY, ICLOCATION, ICRPTGRP, INSTCTRYCD, ITEMMAST and 7 more.
About RQ230
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 (2)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
Referenced files (15)
| Table | Description | System |
|---|---|---|
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLSYSTEM | General Ledger Company | IF |
| ICCOMPANY | Inventory Company Information | IC |
| ICLOCATION | Company Location | IC |
| ICRPTGRP | Report Group | IC |
| INSTCTRYCD | Intrastat Country Codes | TX |
| ITEMMAST | Item Master | IC |
| MMDIST | Account Distributions | PO |
| MXLISTMBR | Attribute List | IF |
| POLINESRC | PO Line Source | PO |
| REQLINE | Requisition Line | RQ |
| RQLOC | Requesting Locations | RQ |
| RQTRANS | Requisition Transactions | RQ |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (5)
IFLU, IFOB, IFSG, IFUP, RQBL