Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQ35


RQ35.1 - Requisition Returns

**Form Purpose
Use Requisition Returns (RQ35.1) to add items back into inventory only if the
items

- have been returned from the requesting location,

- were issued to the requesting location, and

- were not transferred to the requesting location.

Before using RQ35.1 (Requisition Returns), requisition lines must have been
fully processed through the Warehouse application.

**Processing Effect
If the option is selected, a replacement Requisition will be created to
procure the goods that have been returned.

RQ35.1 processes the returned quantity as follows.

- Puts the returned quantity back into inventory at the "from" location.

- Creates an RR inventory transaction which it uses to credit the requesting
location and reduce the usage history.




Updated Files

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

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

    ADDRDATA   -

    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.

    CXCOMPANY  - Used to validate company.

    CXCPIUAVAL -

    CXITEMHIST - Used to update the Case Carts item history.

    CXPREFITEM - Used to update the Case Carts preference item.

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  - Used to update the Patient Charge file.

    HCPATVISIT - Used to update the Patient Visit file.

    ICCOMPANY  - Used to edit the company number.

    ICHISTORY  - The Transaction History file contains the history of an item's
                 inventory transactions summarized by transaction type and
                 period or year.

    ICLOCATION - Used to validate the location name.

    ICLOT      - Updates quantities at the lot level, when an item is returned.

    ICRECEIPTS - Record created on release due to increased stock on-hand.

    ICTRANS    - Inventory historical record created on release.

    ICTRANSDTL - Inv. historical record created on release for lot, bin or
                 serial tracked item.

    ITEMLOC    - Updated with quantities returned.

    ITSERIAL   - Serial number status updated on return.

    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 - Updated with purchase order information.

    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.

    RQLINEDTL  - Detail file maintained by program.

    RQTRANS    - Requisition historical record created on release.

    SOHDETAIL  - Updated with quantities returned at bin and/or lot level.

    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.

    ACCATSUMX  -

    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 -

    APVENGROUP - 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     - Used to maintain rate tables for each defined currency
                 relationship.

    CURELAT    -

    CUSTORDER  -

    CXBURDEN   - Used to validate or display case burden code data.

    CXCASEPREF - Used to validate case preference information.

    CXPTMPITEM - Used to validate case preference template item information.

    GLADDRESS  - Contains the name, address, and communication numbers for the
                 company and needed accounting units.

    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   - Contains company information used primarily by the General
                 Ledger, but the file is also referenced by LAWSON INSIGHT
                 subsystems.

    HCCHRGITEM - Used to validate Patient Charge item information.

    ICBIN      - Used to validate the bin number.

    ICCATEGORY - Used to get accounts for Inventory Transaction transactions.

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICUSRFLDEF -

    ICVALUOM   -

    INSTCTRYCD -

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

    ITEMMAST   - Used to obtain various item information.

    ITEMSRC    -

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

    KWDSETUP   -

    MACOMPANY  -

    MAJORCL    -

    MAMTCHELEM -

    MATCHCLASS -

    MFGSHPFAC  -

    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  - Used to validate the Purchase Order company.

    POITEMVEN  - Contains the vendor's item identifier.

    POLINE     - Contains purchase order line item information.

    POLINESRC  -

    PORECLINE  -

    POUSRFLDEF -

    POVAGRMTLN -

    POVENDLOC  -

    POVENDOR   - Used in a Purchase Order common routine.

    PROCTEMPLN -

    PROCUREGRP -

    PURCHORDER - Contains header information for each purchase order.

    REASON     - Used to validate or display valid reason codes.

    REQUESTER  - This is the file of valid requesters.

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

    RQAPPCODE  - Defines the codes that are assigned to requesters to identify
                 the approval hierarchy for all requisitions entered by that
                 requester.

    RQLOC      - Used to determine the inventory transaction type.

    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.

    WHSHIPLINE -

    WHSHIPMENT -

    WHSHLAUD   -


INVOKED Programs

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