Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC141


IC141 - Location Replenishment Report

**Form Purpose
Run Location Replenishment Report (IC141) to print a report of replenishment
quantities for items with an available quantity less than the reorder point
for items that are stocked from another location.

**Processing Effect
Available quantities are based on the current stock-on-hand quantities minus
allocated, picked, and backordered quantities plus on-order and intransit
quantities.

This report applies to items set up in IC12.1 (Item Location) with the
following.

- A replenishment location set up in the Source form.

- The following set up in the Reorder form: reorder point and one of the
following reorder document types: issue, transfer, intransit (X), or
requisition.

You can create unreleased documents based on the reorder document code.
Unreleased documents can be reviewed and released in IC21.1 (Issues), IC22.1
(Transfers), RQ10.1 (Requisition). If you create unreleased documents, you can
enter the general ledger posting date.

Important To create intransit documents you must enter an estimated delivery
date. To create requisition documents you must set up requesters in RQ04.1
(Requesters). Define requesters based on the form name followed by the
requesting location. For example, to run this program for the Minneapolis
(MPLS) location, set up IC141MPLS as a requester.

This program prints by company, location, report group, and/or inventory
class. You also can also include items set up as inactive in IC11.1 (Item
Master). This report prints by replenishment location in item number sequence
the required leadtime, safety stock quantity, reorder point, stock-on-hand,
supply minus demand quantity, and reorder quantity.




Updated Files

    CKPOINT    - Used in backout or restart circumstances.

    ICACTIVITY - Created for items with a reorder document code equal to I , T,
                 or X and the program is run in update mode.

    ICCOMPANY  - Used to validate company number.

    ICLOCATION - Used to validate location entered and display location name.

    ICTRANS    - Detail file maintained by program.

    ITEMLOC    - Contains records with replenishment information, stock-on-hand
                 quantities, and other reorder information by item.

    MMDIST     - This record holds an account number and possibly an activity
                 code intended for a general ledger distribution of an inventory
                 item.

    MMUAVAL    -

    POCODE     -

    PORQHUF    -

    REQHEADER  - Created when the program is run in update mode and the reorder
                 document is equal to R.

    REQLINE    - Created when the program is run in update mode and the reorder
                 document code is equal to R.

    TXCODEMAST - The Tax Code Master file contains tax codes, descriptions, and
                 the tax types that define how the tax code is to be used.

    TXCOMPANY  - The Tax Company file contains company information, as well as
                 which tax system the company uses.

    TXTAXCODE  - The Tax Code file contains all tax code information used to
                 calculate tax transactions.

    TXTAXTABLE - Used in an Accounts Payable common routine.


Referenced Files

    AMASSET    - Used to validate the asset numbers maintained in the Asset
                 Management system.

    AMTEMPLATE - Used to validate the asset template numbers maintained in the
                 Asset Management system.

    APACCRCODE - An invoice accrual code is used to link a general ledger
                 invoice accrual account to an invoice.

    APCOMPANY  - Used to get the vendor group for vendor number validation.

    APDISTCODE -

    APUDISTCD  -

    APVENGROUP - A vendor group represents a group of vendors that can be
                 shared by one or more accounts payable companies.

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      - Used to validate the buyer codes.

    BUYVENPF   -

    CUCONV     - Used to obtain currency conversion information.

    CURELAT    - Used to validate currency relationship.

    GLADDRESS  - Used to obtain general ledger address information.

    GLCHART    - Used validate system account.

    GLCODES    - Used in a General Ledger common routine.

    GLINTCO    - This file contains interzone and intercompany relationships.

    GLSYSTEM   - Used in a General Ledger common routine.

    ICBIN      - Used to validate bin numbers.

    ICCATEGORY - Used to retrieve account information.

    ICRECEIPTS - The cost history file which is used for LIFO and FIFO costing.

    ICRPTGRP   - Used to validate report group.

    ICUSRFLDEF -

    ICVALUOM   -

    ITEMGROUP  - This file enables companies to share Item Master records or to
                 keep them separate by company.

    ITEMMAST   - Used to print the item description.

    ITEMSRC    -

    KWDSETUP   -

    MACOMPANY  -

    MAJORCL    - Used to validate major class.

    MAMTCHELEM -

    MATCHCLASS -

    MINORCL    - Used to validate major-minor class.

    POAGMTPART -

    POCOMPANY  - Used to validate company number in the Purchase Order system.

    POITEMVEN  - Used in a Requisitions common routine.

    POUSRFLDEF -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDLOC  -

    POVENDOR   - Used to validate the vendor information.

    PROCTEMPLN -

    PROCUREGRP -

    REQUESTER  - Used to validate a requester name.

    RQACCTU    - This is the list of valid accounting units that this requester
                 can enter on a requisition.

    RQAPPCODE  - Used to validate approval codes.

    RQLOC      - Used to validate requesting location.

    RQPURCHCLS - This file contains the list of valid purchasing major classes
                 that a requester can enter items for on a requisition.

    SLSEGMENT  -

    SLSEGVALUE -

    STCOMMCODE - This is a file of valid standard comment codes used to add
                 comments to a purchase order.

    SYSTEMCODE -

    TXTAXRATE  - The Tax Rate file stores tax rates in effect for a specific
                 tax code.


INVOKED Programs

    ACAC
    ACCL
    API4
    IFAC
    IFCU
    IFSG
    SLSE
    SLSU
    API3
    ICI1
    ICI8
    IFAU
    POI6
    POI4
    POIF
    IFOB
    IFRS
    POIG
    POIH
    POIM
    POIX
    SLUA
    SLSR
    SLSS