|
|
RQ230 - Department Usage Report
**Form Purpose
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 the IC21.1 (Issues)
program, those transactions will not show on the report until IC130 (General
Ledger Interface) has run.
**Processing Effect
The following describes RQ230 (Department Usage Report) functions.
The program selects all documents from the Requisition Transactions file
which meet the specified criteria for company, requesting location or report
group, 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, 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, RQ230 (Department
Usage Report) summarizes and reports account totals.
For each company, RQ230 (Department Usage Report) summarizes and reports
requisition location or report group totals.
Updated Files
CKPOINT -
Referenced Files
ICCOMPANY - Used to validate the company number.
ICLOCATION - Used to validate the inventory location.
ICRPTGRP - The Report Group file stores the valid report groups used to
define groups of locations for reporting purposes.
ITEMMAST - The Item Master file stores static information about each item
such as description, classes, units of measure, and weight.
MMDIST - This record holds an account number and possibly an activity
code intended for a general ledger distribution of an inventory
item.
POLINESRC -
REQLINE - Contains the line item information for the requisition.
RQLOC - Contains the valid requesting locations for the company.
RQTRANS - Contains the history of all deliveries for all requisitions.
WFSETUP -
|
