Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

RQ230


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    -


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    -