Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC152


IC152 - Movement Analysis - GMROI

**Form Purpose
Run Movement Analysis - GMROI (IC152) to print a report of gross margin
return on investment. This report lists items in descending order by gross
margin return on investment (GMROI) percentages and suggests movement classes
based on those percentages.

**Processing Effect
You define what percentage of the GMROI must be met by movement class 1, 2,
and 3.

For example, if you assign 70, 20, and 10 to movement class 1, 2 and 3, this
program assigns class 1 to items that make up 70 percent of the total GMROI,
class 2 to items that make up the next 20 percent of total GMROI, and class 3
to items that make up the last 10 percent of total GMROI. You do not have to
assign a percentage to each movement class. However, the total percentage
assigned must equal 100 percent. Examples include 50/50, 80/15/5, and 60/40.

GMROI Percentage = ((Price - Cost) / Price) * (Turnover / (1 - ((Cost -
Price) / Price)))

This program requires you to enter the period and year range for which to
analyze inventory movement. For example, enter

1 1993 - 4 1993

to analyze inventory movement for the first four periods in 1993. This form
also provides an update option that lets you update suggested movement classes
to Item Location records in IC12.1 (Item Location).

You can select the items affected by this form by location, report group,
and/or sales class. You can also specify a GMROI cutoff and/or include items
set up as inactive in the Item Master file (IC11.1) or Item Location file
(IC12.1). If you specify a GMROI cutoff, this program excludes items that fall
below the GMROI specified.




Updated Files

    CKPOINT    - Used in the backout or restart circumstances.

    ITEMLOC    - Used to update the movement class and rank if the update
                 option is selected.


Referenced Files

    GLADDRESS  - Used in a General Ledger common routine.

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

    GLCODES    - Used in a General Ledger common routine.

    GLSYSTEM   - Used in a General Ledger common routine.

    ICBIN      - Used to validate bin numbers and extract bin information.

    ICCOMPANY  - Used to validate the existence of the company number.

    ICHISTORY  - Used to accumulate the total price of sales for an item
                 location.

    ICLOCATION - Used to print the location description.

    ICRPTGRP   - Used to validate the report group.

    ITEMMAST   - Used to print the item description.

    MAJORCL    - Used to validate the major class.

    MINORCL    - Used to validate the major-minor class.


INVOKED Programs

    IFSG