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 |