Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC135


IC135 - Inventory Turnover by Issues

**Form Purpose
Run Inventory Turnover by Issues (IC135) to print a report of inventory
turnover based on item issues. Run this program if you do not use the Order
Entry application. If you use the Order Entry application, run IC134
(Inventory Turnover) to calculate turnover rates based on item sales.

**Processing Effect
This program calculates inventory turnover rates based on issue quantities,
average stock-on-hand quantities, and, optionally, on transfer and adjustment
quantities. In order to calculate accurate turnover rates, you must run this
program immediately after you close an inventory period in IC190 (Closing).
The closing form (IC190) captures period end balances and calculates average
stock-on-hand quantities.

Calculations used by this form are listed below.

Average Inventory is the sum of period end item stock-on-hand quantities
divided by the number of periods for which balances exist.

Turnover Rate is the sum of inventory issue quantities for the last 12 months
divided by average inventory quantities.

This program requires you to enter the period and year range for which to
calculate turnover rates. For example, enter

1 1993 - 4 1993

to calculate turnover rates for the first four periods in 1993. This form
also provides an update option which lets you update inventory turnover rates
to Item Location records in IC12.1 (Item Location). You can select the items
affected by this program by location, report group, and/or inventory class.

Note You must release all transaction documents for the period and run IC130
(General Ledger Interface) in update mode before you can run IC190 (Closing).
Refer to the Inventory Control User Guide for more information on closing
inventory periods.




Updated Files

    ADDRDATA   -

    CKPOINT    - Used in backout or restart circumstances.

    ITEMLOC    - Program updates the turnover rate, if the update option is Yes.


Referenced Files

    GLADDRESS  - Used in a General Ledger common routine.

    GLCHART    - This file contains chart and system account information in the
                 General Ledger system.

    GLSYSTEM   - Used in a General Ledger common routine.

    ICCOMPANY  - Used to validate the company number.

    ICHISTORY  - Used to extract history data.

    ICLOCATION - Used to validate the location name.

    ICRPTGRP   - Used to validate report group name.

    INSTCTRYCD -

    ITEMMAST   - Used to extract item description.

    MAJORCL    - Used to validate major class.

    MINORCL    - Used to validate minor class.


INVOKED Programs

    IFOB
    IFSG