Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

RQ10

RQ10.1 - Requisition

Use this form to manually create requests for any item type: inventory,
nonstock, special order (X), or service. The form contains four tabs for
creating a requisition (Header, Defaults, Lines, and Template). The Lines tab
contains four detail tabs (Line Detail, Purchasing, Classes, and Misc).

Items can be inventoried items delivered from an inventory location or
noninventory items purchased from a vendor. You can add line items using two
methods.

- Choose the Lines tab to add line items.
- Choose the Template tab to copy line items from a previous requisition,
template, or  standard order.

Select a company and requester (without a requisition number) to select
templates available to any requester in the company.

The Defaults tab on this form can be used to enter default information for
requisition lines. The default information entered on this tab will only be
used to fill empty fields, or fields that are not filled by the requisition
template. The default information from the Defaults tab will not override any
information inserted on a requisition line by a template.

You can add up to five requisition lines per form. You can add any item type
including inventory, nonstock, special order (X), or service on one
requisition. If the item is a nonstock or an inventory item, the item
description displayed in the RQ10.1 (Requisition) Lines tab Line Detail detail
tab defaults from IC11.1 (Item Master).

If the requested item is a special order (X), or Service item, you must enter
the item description.

AUTOMATIC REPLACEMENT OF ENTERED ITEMS:

Replacement of items can occur automatically if you are adding or changing an
inventory item. That is, if an item is not  available in the requested
quantity and there is a replacement for the  original item, the system makes a
replacement and, if needed, places on  backorder any remaining quantities for
the replacement item. A message displays at the bottom of the form when the
add or change is complete. The message indicates either that replacements were
made, that backorders were added, or that backorders were added and substitute
items exist.

MANUAL SUBSTITUTION OF ENTERED ITEMS:

Substitution is a manual process available when the "substitute exists"
message appears with the add or change of a requisition line. To find and
choose a substitute item, in the Item field press F4 (Select On). Then, add
the substitute item on a new line. The original requisition line that is
substituted for can then be manually deleted.

RELEASING REQUISITIONS

Before you can release the requisition, each line must have a unit cost or
the Zero Cost flag must be set to "Y". The Zero Cost flag is set in the RQ10.1
(Requisition) Lines tab Purchasing detail tab. You can use the ZipRelease form
action to bypass the buyer review function in RQ20. You can run RQ125 (PO
Generation) to process zip released requisitions. RQ125 automatically creates
purchase orders.

In addition, see the following discussion of Budget Availability.

BUDGET AVAILABILITY

The Requisition system lets you know whether an added or changed line
distribution to an activity will exceed your budget. If the line distribution
is within budget, the system commits the distribution to your budget. When you
add or change a requisition by assigning or updating a line distribution for a
specific activity, the system checks the Activity system. If  the activity is
assigned to an activity group for which a budget is defined and if the
distribution will result in  going over budget, the error message "Add or
change complete; activity budget will be exceeded" displays. (This message
only displays before release of the requisition.) If no overage  will occur,
later, when you release the requisition, the system creates a  budget
commitment record.

USER FIELDS

Note: The following is true for the PO User Fields on the Lines tab
Miscellaneous detail tab.

- For purchase orders created from the line, the user-defined field
information moves to purchase order line user fields.
- For inventory items going through the picking cycle, the user-defined field
information is not attached.


Note: If you are using the '@k' process type, this program does an
availability edit and creates a requisition line for what you have available.
The process of filling requisition lines and cancelling any remaining
quantities is not available for make-to-order kit items.

Updated Files

    ACCOMMIT   - Contains commitments not yet posted to the general ledger.

    ACCOMMITX  - Contains commitment details not yet posted to the general
                 ledger.

    APHLDINV   - Used to determine what invoices for a vendor are on hold.

    APPAYMENT  - Used to create and maintain an invoice payment record.

    COCOMP     - The Demand Line Kit Components file contains the kit
                 components that make up a line on a document.

    COLINEDTL  - The Order Line Allocated Details file contains line allocation
                 information created when the item is tracked by bin, lot,
                 serial, or multiple unit of measure.

    GLMASTER   - Used to validate the GL account. Used in a Lawson general
                 ledger common routine.

    ICCOMPANY  - Used to edit the company number.

    ICLOCATION - Used to edit the delivering location.

    ICLOT      - The Lots with Expire Date/On Hold file stores the expiration
                 dates and/or the hold flag for lots.

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

    ITEMGROUP  - Enables companies to share Item Master records or to keep them
                 separate by company.

    ITEMLOC    - Updated with item location information.

    ITSERIAL   - Stores the valid serial numbers currently in stock and issued.

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

    MMUAVAL    - This file stores the user analysis values defined for
                 transactions.

    POLINE     - Used by the Purchase Order system to extract the unit cost of
                 an item.

    PURCHORDER - Used in a Lawson Purchase Order common routine.

    REQHEADER  - Primary file maintained by program.

    REQLINE    - Detail file maintained by program.

    ROUTEDOC   - The Route Document file contains documents that are to be
                 delivered along a route.

    ROUTEHDR   - For all routes created, the system added a header record to
                 the Route Header file.

    ROUTESTOP  - The Route Stop file contains records set up to identify the
                 stops along a route.

    RQAPPROVE  - Contains open approval records that need approval because the
                 approval amount level is less than the requisition total value.


    RQCOMMENTS - Updated when comments are added to a requisition.

    SOHDETAIL  - Used to extract stock on hand detail information.

    TXCODEMAST - The Tax Code Master file contains tax codes, descriptions, and
                 the tax types that define how the tax code is 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 - Contains a tax table that defines a series of up to eight tax
                 codes to be applied to a single transaction and determines how
                 each tax code will affect the taxable amount of a transaction.

    WHDEMAND   - The Demand file contains all the records that the Warehouse
                 system needs for processing demands.

    WHDEMNDCMT - Referenced by warehouse API's that validate item type.

    WHDEMNDHDR - Used to create or update a Warehouse system demand header
                 record. The Demand Header file contains document header
                 records.


Referenced Files

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

    ACACTGRP   - Contains the highest reporting level in the Activity
                 Management system.

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

    ACCAL      - Contains calendar information from the Activity Management
                 system.

    ACCALX     - Contains detail calendar information from 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 - An invoice accrual code is used to link a general ledger
                 invoice accrual account to an invoice.

    APCOMPANY  - Used in a Lawson Accounts Payable common routine.

    APCPYVND   - The Vendor Company Codes file contains default codes assigned
                 a vendor or alternate vendor location at the company level.

    APINVOICE  - Used to obtain invoice information.

    APVENCLASS - Used in a Lawson Accounts Payable common routine.

    APVENGROUP - Used in a Lawson Accounts Payable common routine.

    APVENLOC   - Used to validate the vendor purchase from locations.

    APVENMAST  - Used in a Lawson Accounts Payable common routine.

    BUYER      - Used to validate the buyer codes.

    COMPONENT  - Contains the component items that make up a kit item.

    CUACCT     - Used to access General Ledger currency gain/loss accounts.

    CUCODES    - Used to validate the currency code. Used in a Lawson Currency
                 common routine.

    CUCONV     - Maintains rate tables for each defined currency relationship.

    CURELAT    - Used in a Lawson Currency common routine.

    CUTABLE    - Used to validate the currency table.

    GLACCTVLD  - Used to validate a detail account/system code relationship.

    GLADDRESS  - Used in a Lawson General Ledger common routine.

    GLCHART    - Contains chart and system account information in the General
                 Ledger system including retained earnings, undistributed
                 retained earnings, error suspense, and gain/loss account
                 records.

    GLCHARTDTL - Used in a Lawson General Ledger common routine.

    GLCHARTSUM - Used to access summary account information.

    GLCODES    - Used in a Lawson General Ledger common routine.

    GLINTCO    - Contains interzone and intercompany relationships.

    GLNAMES    - Used to verify the existence of the accounting unit. Used in a
                 Lawson general ledger common routine.

    GLSYSTEM   - Used in a Lawson General Ledger common routine.

    ICBIN      - Used to validate a bin number.

    ICCATEGORY - Used for defaults of general ledger account.

    ITEMMAST   - Used to edit the item number.

    ITEMSUB    - The Item Substitute file stores valid substitutes for an item.

    JBKACCT    - Contains account records that are selected to include in a
                 Journal Book transactions group.

    JBOOKHDR   - Contains the Journal Book definition information.

    KITITEM    - Contains the valid kit or parent items for a kit or assembly.

    MAJORCL    - Contains the major class codes which are entered on Item
                 Master records.

    MINORCL    - A detail file for the Major Class file.

    MXLISTMBR  - Stores list member records, including the object type,
                 sequence number, and object ID used to perform inquiries on
                 accounting units, accounts, and matrix attributes.

    OEFRTCODE  - Contains freight codes that can be used in the Lawson Order
                 Entry system.

    OEROUTE    - Contains all user-defined routes that are set up in the Lawson
                 Order Entry system.

    ORDERTYPE  - The Order Type file stores order type parameters.

    POAPPROVE  - Used to obtain purchase order approval information.

    POCOMMENTS - Contains all Purchase Order comments associated with both
                 actual and standard purchase orders.

    POCOMPANY  - Contains valid Purchase Order companies and corresponding
                 parameters.

    POINVOICE  - Used to retrieve purchase order invoice information for
                 display.

    POITEMVEN  - Used in a Purchase Order common routine when defaulting unit
                 cost.

    POLOCCON   - Contains a list of valid override contracts for a location.

    POMESSAGE  - Used to validate and default buyer message information.

    POQUOTES   - Used in a Purchase Order common routine when defaulting unit
                 cost.

    PORECEIVE  - Used to validate and default purchase order receiving
                 information.

    PORECLINE  - Used to obtain receiving line information.

    POVENDOR   - Used in a Purchase Order common routine for vendor location
                 information.

    REQUESTER  - Used to edit the requester and extract the defaults.

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

    RQAPPCODE  - Used to determine the approval levels.

    RQLOC      - Used to edit the requesting location and extract the default
                 accounts.

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

    RQTEMP     - This is the header file for the requisition templates.

    RQTEMPLINE - Contains the items on a requisition template.

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

    STPOLINE   - Used in a Purchase Order common routine.

    STPURCHORD - Used in a Purchase Order  common routine.

    SYSTEMCODE - This file contains system code information used for remote
                 site processing.

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

    WFSETUP    -

    WHPROCTYPE - The Shipment Process Type file contains process type records
                 used for determining the steps an order is to take in the
                 Warehouse system.


RQ10.2 - Account Distribution

Use this form to enter account distribution information for nonstock, special
order, and service items. You can
- Distribute the cost of a nonstock, special order, or service item to
multiple expense accounts. You can distribute by percentage or quantity.
However, the total distributions must equal either 10012r the total item
quantity.
- Assign an asset code to the line.

To display this form, choose the RQ10.1 (Requisition) Lines tab Line Detail
detail tab. Then, choose the Mult button.

Updated Files

    ACCOMMIT   - Contains commitments not yet posted to the general ledger.

    ACCOMMITX  - Contains commitment details not yet posted to the general
                 ledger.

    APHLDINV   - Used to determine what invoices for a vendor are on hold.

    APPAYMENT  - Used to create and maintain an invoice payment record.

    ICCOMPANY  - Used to edit the company number.

    ITEMLOC    - Updated with item location information.

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

    REQLINE    - Detail file maintained by program.


Referenced Files

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

    ACACTGRP   - Contains the highest reporting level in the Activity
                 Management system.

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

    ACCAL      - Contains calendar information from the Activity Management
                 system.

    ACCALX     - Contains detail calendar information from 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.

    APCOMPANY  - Used in a Lawson Accounts Payable common routine.

    APDISTCODE - Contains distribution codes used to automatically create
                 expense distributions or expense distribution "shells" for
                 invoices or to split invoice distributions into multiple
                 distribution lines.

    APINVOICE  - Used to obtain invoice information.

    CUCONV     - Maintains rate tables for each defined currency relationship.

    CURELAT    - Used in a Lawson Currency common routine.

    GLADDRESS  - Used in a Lawson General Ledger common routine.

    GLCHART    - Contains chart and system account information in the General
                 Ledger system including retained earnings, undistributed
                 retained earnings, error suspense, and gain/loss account
                 records.

    GLCODES    - Used in a Lawson General Ledger common routine.

    GLINTCO    - Contains interzone and intercompany relationships.

    GLSYSTEM   - Used in a Lawson General Ledger common routine.

    ICBIN      - Used to validate a bin number.

    ICCATEGORY - Used to default general ledger account information.

    ITEMMAST   - Used to edit the item number.

    POAPPROVE  - Used to obtain purchase order approval information.

    POCOMPANY  - Used to validate a PO company.

    POINVOICE  - Used to retrieve purchase order invoice information for
                 display.

    POLINE     - Used by PO to extract the unit cost of an item.

    POMESSAGE  - Used to validate and default buyer message information.

    PORECEIVE  - Used to validate and default purchase order receiving
                 information.

    PORECLINE  - Used to obtain receiving line information.

    PURCHORDER - Used in a Lawson PO common routine.

    REQHEADER  - Primary file maintained by program.

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

    SYSTEMCODE - This file contains system code information used for remote
                 site processing.

    WFSETUP    -


RQ10.3 - Select and Copy

Use this form to select and copy lines from an existing requisition,
template, or standard order.

To display this form, choose the RQ10.1 (Requisition) Template tab. Select a
requisition, template, or standard order. In the Select All field, select N
(No). Select the Add form action.

Updated Files

    ACCOMMIT   - Contains commitments not yet posted to the general ledger.

    ACCOMMITX  - Contains commitment details not yet posted to the general
                 ledger.

    COCOMP     - The Demand Line Kit Components file contains the kit
                 components that make up a line on a document.

    COLINEDTL  - The Order Line Allocated Details file contains line allocation
                 information created when the item is tracked by bin, lot,
                 serial, or multiple unit of measure.

    ICCOMPANY  - Used to edit the company number.

    ICLOCATION - Used to edit the location codes.

    ICLOT      - The Lots with Expire Date/On Hold file stores the expiration
                 dates and/or the hold flag for lots.

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

    ITEMGROUP  - Enables companies to share Item Master records or to keep them
                 separate by company.

    ITEMLOC    - Allocated, backordered, and on order quantities are updated.

    ITSERIAL   - Stores the valid serial numbers currently in stock and issued.

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

    MMUAVAL    - This file stores the user analysis values defined for
                 transactions.

    POLINE     - Used by the Purchase Order system to validate the unit cost of
                 an item.

    PURCHORDER - Used in a Purchase Order common routine.

    REQHEADER  - Primary file maintained by program.

    REQLINE    - Detail file maintained by program.

    ROUTEDOC   - The Route Document file contains documents that are to be
                 delivered along a route.

    ROUTEHDR   - For all routes created, the system added a header record to
                 the Route Header file.

    ROUTESTOP  - The Route Stop file contains records set up to identify the
                 stops along a route.

    RQAPPROVE  - Contains open approval records that need approval because the
                 approval amount level is less than the requisition total value.


    RQCOMMENTS - Updated when comments are added to a requisition.

    SOHDETAIL  - Used to extract SOH detail information.

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

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

    TXTAXCODE  - Used to validate Tax Code.

    TXTAXTABLE - Contains a tax table that defines a series of up to eight tax
                 codes to be applied to a single transaction and determines how
                 each tax code will affect the taxable amount of a transaction.

    WHDEMAND   - The Demand file contains all the records that the Warehouse
                 system needs for processing demands.

    WHDEMNDCMT - Referenced by warehouse API's that validate item type.

    WHDEMNDHDR - Used to create or update a Warehouse system demand header
                 record. The Demand Header file contains document header
                 records.


Referenced Files

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

    ACACTGRP   - Contains the highest reporting level in the Activity
                 Management system.

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

    ACCAL      - Contains calendar information from the Activity Management
                 system.

    ACCALX     - Contains detail calendar information from 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 - An invoice accrual code is used to link a general ledger
                 invoice accrual account to an invoice.

    APCOMPANY  - Used in a Lawson Accounts Payable common routine.

    APCPYVND   - The Vendor Company Codes file contains default codes assigned
                 a vendor or alternate vendor location at the company level.

    APHLDINV   - Used to determine what invoices for a vendor are on hold.

    APVENCLASS - Used in a Lawson Accounts Payable common routine.

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

    APVENLOC   - Used in a Lawson Accounts Payable common routine.

    APVENMAST  - Used in a Lawson Accounts Payable common routine.

    BUYER      - Used to validate the buyer codes.

    COMPONENT  - Contains the component items that make up a kit item.

    CUACCT     - Used to access General Ledger currency gain/loss accounts.

    CUCONV     - Maintains rate tables for each defined currency relationship.

    CURELAT    - Used in a Lawson Currency common routine.

    CUTABLE    - Used to validate the currency table.

    GLADDRESS  - Used in a Lawson General Ledger common routine.

    GLCHART    - Contains chart and system account information in the General
                 Ledger system including retained earnings, undistributed
                 retained earnings, error suspense, and gain/loss account
                 records.

    GLCODES    - Used in a Lawson General Ledger common routine.

    GLINTCO    - Used in a Lawson General Ledger common routine.

    GLSYSTEM   - Used in a Lawson General Ledger common routine.

    ICBIN      - Used to validate a bin number.

    ICCATEGORY - Used for default of general ledger account information.

    ITEMMAST   - Used to edit the item number.

    ITEMSUB    - The Item Substitute file stores valid substitutes for an item.

    KITITEM    - Contains the valid kit or parent items for a kit or assembly.

    OEFRTCODE  - Contains freight codes that can be used in the Lawson Order
                 Entry system.

    OEROUTE    - Contains all user-defined routes that are set up in the Lawson
                 Order Entry system.

    ORDERTYPE  - The Order Type file stores order type parameters.

    POCOMMENTS - Contains all Purchase Order comments associated with both
                 actual and standard purchase orders.

    POCOMPANY  - Contains valid Purchase Order companies and corresponding
                 parameters.

    POITEMVEN  - Used in a Lawson Purchase Order common routine in defaulting
                 unit cost information.

    POLOCCON   - Contains a list of valid override contracts for a location.

    POQUOTES   - Used in a Lawson Purchase Order common routine in defaulting
                 unit cost information.

    POVENDOR   - Used in a Purchase Order common routine.

    REQUESTER  - Used to edit the requester and extract the defaults.

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

    RQAPPCODE  - Used to edit approval code.

    RQLOC      - Used to edit the requesting location and extract the defaults.

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

    RQTEMPLINE - Contains the items on a requisition template.

    STCOMMCODE - Used to validate standard comment codes.

    STPOLINE   - Used in a Lawson Purchase Order common routine.

    STPURCHORD - Used in a Lawson Purchase Order common routine.

    SYSTEMCODE - This file contains system code information used for remote
                 site processing.

    TXTAXRATE  - Used to obtain tax rate information.

    WFSETUP    -

    WHPROCTYPE - The Shipment Process Type file contains process type records
                 used for determining the steps an order is to take in the
                 Warehouse system.


RQ10.4 - Requisition Header Comments

Use this form to enter standard header comments and/or ad hoc comments for
the requisition.

If a purchase order is created for the requisition, the system passes the
header comments to the purchase order. The comments print on the pick ticket
if the item is an inventory item. You can assign up to two standard comment
codes. You can change standard comment code comments here for the particular
requisition without affecting the standard comment code comments. Use PO12.1
(Comment Codes) to define standard comment codes.

Updated Files

    REQHEADER  - Used to edit the requisition number.

    RQCOMMENTS - Line comment file maintained by program.

    WHDEMNDCMT - Referenced by warehouse API's that validate item type.


Referenced Files

    STCOMMCODE - Used to edit standard comment codes.

    STCOMMENTS - Used to extract standard comment lines.

    WHDEMNDHDR - Used to create or update a Warehouse system demand header
                 record. The Demand Header file contains document header
                 records.


RQ10.5 - Requisition Line Comments

Use this form to enter standard line comments and/or ad hoc comments for the
requisition using standard comment codes. To display header comments, choose
the RQ10.1 (Requisition) Header tab and choose the Comments button.

The system passes the line comments to the purchase order if a purchase order
is created for the line. The comments print on the pick ticket if the item is
an inventory item. You can assign up to two standard comment codes. You can
change standard comment code comments here for the particular requisition
without affecting the standard comment code comments. Use PO12.1 (Comment
Codes) to define standard comment codes.

Updated Files

    REQLINE    - Contains the line item information for the requisition.

    RQCOMMENTS - Contains both the header and line comments for a requisition.

    WHDEMNDCMT - Referenced by warehouse API's that validate item type.


Referenced Files

    REQHEADER  - Used to validate requisition and update the PO user fields.

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

    STCOMMENTS - Used to get standard purchase order comments.

    WHDEMNDHDR - Used to create or update a Warehouse system demand header
                 record. The Demand Header file contains document header
                 records.


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS
    SLSS