Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQ500


RQ500 - Requisition Interface

**Form Purpose
Run Requisition Interface (RQ500) to import requisitions from a non-Lawson
system into the Requisition system.

**Processing Effect
The loaded requisitions must pass through all the required requisition edits.
If an inventory item is not available in the requested quantity, the system
determines whether a replacement can be made. If the item is not available in
the requested quantity and there is a replacement item for the original item,
the system makes a replacement. In addition, if needed, the system places any
remaining quantities on backorder for the replacement item. No messages
display to indicate replacements, substitutions, or backorders.

The program prints the requester and requisition number for requisitions that
processed successfully. Additional header or line detail is printed for
requisitions with exceptions. Drill around capabilities are provided for you
to view additional requisition detail from the report.

Run this program in report mode or in update mode.  Report mode lets you
review and correct exceptions before updating the database. When you run in
update mode, the input file is deleted when processing is complete.

Any  records with exceptions are written to an error file named
RQ500MTDYHRMNSC. In this file name, MT is the month, DY is the day, HR is the
hour, MN is the  minute, and SC is the second when the program started. You
may correct the exceptions, either in the database or in the input file.  To
run exception records through RQ500 again, you must correct the errors, create
applicable header records, and remove the requisition numbers that are
assigned to line records that are in error.  Be aware that you cannot simply
append to existing requisitions.

You can run RQ500 (Requisition Interface) to process files uploaded by the
handheld terminal and routed to RQ500 by IC588 (Handheld Processing). To
process handheld terminal transactions, you must set up RQ500 jobs and
parameters according to the requirements for handheld processing. For details
on preparing RQ500 for handheld processing, see the Procurement Management
Technical Guide.

**Troubleshooting
For abnormal terminations (jobs needing recovery), such as might occur from a
hard drive head crash, the system creates an error print file. However, jobs
that need recovery are not available in Print Manager. The abnormally
terminated job resides in the normal Lawson print directory,
($LAWDIR/print/user/jobname/jobstep), and can be viewed with the lashow
command. To recover, you rerun the job. The interface program automatically
appends the output from the recovery run to the output  from the original run.
In the  print file, a  page break separates the recovery run from the original
output. Date and time stamps on the page headers also indicate whether the
page is from the  original or recovery run.

**More Information
If you create released requisitions, note the following ProcessFlow services.

If the ProcessFlow Requisition Approval service is enabled, you can send a
requisition approval request when you release the requisition. The ProcessFlow
Requisition Approval service sends the request in the form of an E-mail or
work object.

If the ProcessFlow Rush Item service is enabled, you can send a rush item
request in the form of an E-mail or work object when you release the
requisition.

Updated Files

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

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

    CKPOINT    - Used in the event of a program or system failure to enable a
                 batch update program to continue from where it left off.

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

    GLCOMMIT   -

    GLCOMMITX  -

    ICCOMPANY  - Used to edit the company identifier.

    ICLOCATION - Used to validate the inventory location.

    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.

    MMUAVAL    -

    POCODE     -

    POINTAOC   -

    POINTERFAC -

    PORLNUF    -

    PORQHUF    -

    POVAGRMTHD -

    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.

    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.

    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.

    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 Accounts Payable common routine.

    APDISTCODE -

    APUDISTCD  -

    APVENGROUP - Used in a Accounts Payable common routine.

    APVENMAST  - Used in a Accounts Payable common routine.

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      - Used to validate the buyer codes.

    BUYVENPF   -

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

    CUCONV     - Maintains rate tables for each defined currency relationship.

    CURELAT    -

    CUSTORDER  -

    GLADDRESS  - Used in a 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 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 General Ledger common routine.

    ICBIN      - Used to validate a bin number.

    ICCATEGORY - Used for defaults of general ledger account.

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

    ICUSRFLDEF -

    ICVALUOM   -

    INSTCTRYCD -

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

    ITEMMAST   - Used to edit the item number.

    ITEMSRC    -

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

    KWDSETUP   -

    MACOMPANY  -

    MAJORCL    -

    MAMTCHELEM -

    MATCHCLASS -

    MINORCL    -

    OECOMPANY  -

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

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

    ORDERTYPE  - The Order Type file stores order type parameters.

    POAGMTPART -

    POCOMPANY  - Contains valid Purchase Order companies and corresponding
                 parameters.

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

    POUSRFLDEF -

    POVAGRMTLN -

    POVENDLOC  -

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

    PROCTEMPLN -

    PROCUREGRP -

    PURCHORDER - 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 the approval code.

    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.

    SLSEGMENT  -

    SLSEGVALUE -

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

    SYSTEMCODE -

    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.


INVOKED Programs

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