Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DR100


DR100 - Distribution Requirements Report

**Form Purpose
Run Distribution Requirements Report (DR100) to print a report of
distribution requirements. This report applies to items set up with the
time-phased ordering method (TPO) in IC12.1 (Item Location). The TPO
reordering method tracks item order requirements and available stock over
time. With this method, it is possible to anticipate future situations rather
than react to the current situation, and to offer better customer service with
a lower inventory investment.

**Processing Effect
TPO is a way of expressing future demand, supply, and inventory by time
period, and calculating when a replenishment order should be placed to satisfy
the demand. The program calculates new planned orders based on the current
order demand, remaining forecast, scheduled purchase orders, intransit
inventory, requisitions, and current stock on hand.

The kind of document created by this program is based on the document code
set up for items using the Reorder form tab of IC12.1 (Item Location).

The program follows the dates defined for the Company. If the report is run
for a 53 week company and the report spans more than 1 year, the ending period
and the starting period will be 1 day apart. This situation must be taken into
account when entering forecasts.

Note To create requisitions, you must set up requesters in RQ04.1
(Requesters). Requesters for this program are defined as DR100 followed by the
Location. For example, for Company 36 and Location EAST, a requester of
DR100EAST must be defined.

After printing DR100, use DR25.1 (Planned Orders) to view and adjust planned
orders generated by this program.




Updated Files

    ACCOMMIT   - This file contains commitments not yet posted to the general
                 ledger.

    ACCOMMITX  - This file contains commitment details not yet posted to the
                 general ledger.

    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.

    GLCOMMIT   -

    GLCOMMITX  -

    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 the Inventory Control company.

    ICLOCATION - Used to validate inventory locations and display location
                 names.

    ICPLANORD  - Used for the display of planned data and updating
                 modifications effected by the user.

    ICTRANS    - Used to edit the deletion of an item.

    ITEMLOC    - Used to validate the existence of an item at a location.

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

    MMUAVAL    -

    POCODE     -

    POINTAOC   -

    POINTERFAC - Interfaces input from the Inventory Control and Order Entry
                 systems and outside systems into the Purchase Order system.

    PORQHUF    -

    POVAGRMTHD -

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

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

    TXCODEMAST - Contains tax codes, descriptions, and the tax types that
                 define how the tax code is to be used.

    TXCOMPANY  - Contains Tax system company information, as well as which tax
                 system the company uses.

    TXTAXCODE  - Contains tax code information used to calculate tax
                 transactions.

    TXTAXTABLE - Used in an Accounts Payable common routine.

    WODMNDFCST -


Referenced Files

    ACACCTCAT  - Used to validate account categories maintained in the Activity
                 Management system.

    ACACTGRP   - Highest reporting level in the Activity Management system.

    ACACTIVITY - Used to validate the activities maintained in the Activity
                 Management system.

    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 - 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 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 a currency relationship.

    GLADDRESS  - Used in a General Ledger common routine.

    GLCHART    - Contains chart and system account information in the General
                 Ledger system.

    GLCODES    - Used in a General Ledger common routine.

    GLINTCO    - Contains interzone and intercompany relationships.

    GLNAMES    - Used in a General Ledger common routine.

    GLSYSTEM   - Used in a General Ledger common routine.

    ICBIN      - Used to validate bin numbers.

    ICCATEGORY - Used to retrieve account information.

    ICFORECAST - Contains the forecast records by year.

    ICRECEIPTS - Used to edit the deletion of an item.

    ICRPTGRP   - Used to validate report groups.

    ICUSRFLDEF -

    ICVALUOM   -

    ITEMGROUP  - Used to validate the item group.

    ITEMMAST   - Used to print the item description.

    ITEMSRC    -

    KWDSETUP   -

    MACOMPANY  -

    MAJORCL    - Used to validate major classes.

    MAMTCHELEM -

    MATCHCLASS -

    MINORCL    -

    POAGMTPART -

    POCOMPANY  - Used to retrieve Purchase Order historical transactions.

    POITEMVEN  - Used to validate the vendor item number.

    POUSRFLDEF -

    POVAGRMTLN -

    POVENDLOC  -

    POVENDOR   - Used in a Purchase Order common routine.

    PROCTEMPLN -

    PROCUREGRP -

    PURCHORDER - Contains header information for each purchase order.

    REQUESTER  - Used to validate a requester name.

    RQACCTU    - List of valid accounting units that this requester can enter
                 on a requisition.

    RQAPPCODE  - Used to obtain valid approval codes.

    RQLOC      - Used to retrieve requesting location names.

    RQPURCHCLS - Contains a list of valid purchasing major classes that a
                 requester can enter items for on a requisition.

    SLSEGMENT  -

    SLSEGVALUE -

    STCOMMCODE - Contains a list of valid standard comment codes used to add
                 comments to a purchase order.

    SYSTEMCODE -

    TXTAXRATE  - Used in an Accounts Payable common routine.

    WHDEMAND   - Contains all the records that the Warehouse system needs for
                 processing demands.


INVOKED Programs

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