RQ230 - Department Usage Report

Run this program to lists 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.

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    - This file is used in the event of a program or system failure
                 to enable a batch update program to continue from where it left
                 off.


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.

    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    -