IC140 – Vendor Reorder Advice
- System
- Inventory Control (IC)
- Type
- Batch program
- Updates
- 178 tables
- References
- 187 tables
IC140 (Vendor Reorder Advice) is a Lawson Inventory Control batch program. It updates ACAMCODE, ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, AMACCOUNT, AMACCTAU, AMACCTGPAU and 170 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 179 more.
About IC140
Run Vendor Reorder Advice (IC140) to print a report of replenishmentquantities for items with an available quantity that is less than the reorder point. **Processing Effect Available quantities are shown on this report as supply minus demand. Available quantity is based on current stock-on-hand quantities minusallocated, picked, and backordered quantities plus on-order and intransit quantities. The item's stock unit of measure is used. If the buy unit of measure isdifferent, this program converts the quantity based on the conversion data defined in the IC11.1 (Item Master) UOM form. This form applies to items which were - defined in the IC12.1 (Item Location) Reorder form with the fixed reorderpolicy (FOP), Reorder Point and - assigned the reorder document code for Purchase Order. If reorder points are not set up, use IC120 (Economic Order Quantity and Reorder Calculation) to calculate reorder points based on annual usage. You can use an IC140 option to update the PO Interface file. You can update the file with reorder quantity records for items set up for automatic purchasing in IC12.1. If updated, you can use the PO Interface file to create purchase orders in PO100 (Purchase Order Interface from Lawson Applications). The Vendor Reorder Advice prints items in primary vendor sequence and lists the following: stock unit of measure, reorder point, reorder quantity, buyer code, stock-on-hand, supply minus demand (available quantity), leadtime, reorder percentage, and the automatic purchase order flag. You can select this report to print for the following: a specific location, report group, inventory class, purchasing class, and primary vendor. You also have the option to process items that are set up as inactive in IC11.1 (Item Master). With the reorder cutoff percentage, if a vendor has an item to be reordered, this option will include any other items that are within this percentage of reorder point. To print the same information by buyer code, run IC225 (Inventory Reorder Advice). The Inventory Reorder Advice program is similar to the Vendor Reorder Advice. However, IC225 does not provide the option to update the PO Interface file. NOTE The available quantity is based on the item's stock unit of measure. If the buy unit of measure is different, this form converts the reorderquantity based on the conversion data defined in the IC11.1 (Item Master) UOM form tab. If the item's buy unit of measure does not evenly divide into the calculated reorder quantity, the order quantity is rounded to the next buy unit ofmeasure. For example, if the reorder quantity is 100, the buy unit of measure is cases and there are 24 items per case, 5 cases are ordered. If the order multiple is greater than one, the next order multiple is ordered.
Updated files (178)
| Table | Description | System |
|---|---|---|
| ACAMCODE | Activity Asset | AC |
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| AMACCOUNT | Asset Management Account | AM |
| AMACCTAU | Asset Account Audit | AM |
| AMACCTGPAU | Asset Account Group Audit | AM |
| AMACCTGRP | Asset Account Group | AM |
| AMASSET | Asset | AM |
| AMASSETADJ | Asset Adjustment | AM |
| AMASSETDSP | Asset Disposal | AM |
| AMASSETGRP | Asset Group | AM |
| AMASSETTRF | Asset Transfer | AM |
| AMASTBKADJ | Asset Book Adjustment | AM |
| AMASTBKDSP | Asset Book Disposal | AM |
| AMASTBKTRF | Asset Book Transfer | AM |
| AMASTBOOK | Asset Book | AM |
| AMASTITADJ | Asset Item Adjustment | AM |
| AMASTITDSP | Asset Item Disposal | AM |
| AMASTITEM | Asset Item | AM |
| AMASTITTRF | Asset Item Transfer | AM |
| AMASTMXVAL | Asset Attributes | AM |
| AMASTRECAP | Asset Depreciation Recapture | AM |
| AMASTRPAIR | Asset Repair | AM |
| AMASTTYPAU | Asset Type Audit | AM |
| AMASTTYPE | Asset Type | AM |
| AMAUGROUP | Asset Accounting Unit Group | AM |
| AMAUGRPAU | AM Accounting Unit Group Audit | AM |
| AMBKHIST | Asset Book History | AM |
| AMBKHISTX | Period Asset Book History | AM |
| AMBKTEMPLT | Book Template | AM |
| AMBKTRANS | Asset Book Transactions | AM |
| AMCALENDAR | Asset Calendar | AM |
| AMCLASSDEP | This file contains the depreciation information for account level depreciation to support Telecommunications Industry… | AM |
| AMCNTRLAU | Asset System Options Audit | AM |
| AMCONTROL | Asset Internal Control | AM |
| AMCTLTRANS | Asset Control Transaction | AM |
| AMDIVISION | Asset Division | AM |
| AMDIVISNAU | AM Division Audit | AM |
| AMINTER | Asset Interface | AM |
| AMINTERAU | Asset Interface Audit | AM |
| AMLOCATION | Asset Location | AM |
| AMLOCAUDIT | AM Location Audit | AM |
| AMMONITOR | No description in the Lawson data dictionary | AM |
| AMPOASTDTL | PO Asset Detail | AM |
| AMPOASTHDR | PO Asset Header | AM |
| AMPODFLTS | PO Defaults | AM |
| AMPUHIS | Personal Use History | AM |
| AMSEGBLOCK | No description in the Lawson data dictionary | AM |
| AMTAXAUTH | Tax Authority | AM |
| AMTEMPLATE | Asset Template | AM |
| AMTRANS | Asset Transaction | AM |
| AMTRANSUMM | Asset Transaction Summary | AM |
| APAPPROVAL | Invoice Approval | AP |
| APAUDIT | Vendor Invoice Audit | AP |
| APCOMMENTS | Comments | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APHLDINV | Hold | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| APVENPAY | No description in the Lawson data dictionary | AP |
| BUYER | PO Buyer Master | PO |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| COCOMP | Demand Line Kit Components | WH |
| COLINE | Customer Order Line | OE |
| COSGBLK | No description in the Lawson data dictionary | OE |
| CUSTDESC | AR Group Customer | AR |
| CXCOMPANY | Case Cart Company | CX |
| CXCPIUAVAL | No description in the Lawson data dictionary | CX |
| CXITEMHIST | Case Cart Item History | CX |
| CXPREFITEM | Preference Items | CX |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| HCHPPAUDIT | No description in the Lawson data dictionary | IC |
| HCPATCHRG | Patient Charge | IC |
| HCPATPROC | No description in the Lawson data dictionary | IC |
| HCPATVISIT | Patient Visit | IC |
| ICCOMPANY | Inventory Company Information | IC |
| ICFACILITY | Ship To Facility | IC |
| ICHISTORY | Transaction History | IC |
| ICICRAUDIT | No description in the Lawson data dictionary | IC |
| ICITEMCODE | Item Code | IC |
| ICLOCATION | Company Location | IC |
| ICLOT | Lots with Expire Date/On Hold | IC |
| ICRECEIPTS | Costing Record | IC |
| ICTRANS | Inventory Transaction | IC |
| ICTRANSDTL | Inventory Transaction Detail | IC |
| INSTDETAIL | Intrastat Detail Transactions | TX |
| INSTHEADER | Intrastat Transaction Header | TX |
| INSTNBR | Intrastat Company Numbers | TX |
| ITEMLOC | Item Location | IC |
| ITSERIAL | Serial Numbers | IC |
| KWDDETAIL | No description in the Lawson data dictionary | IC |
| KWDMASTER | No description in the Lawson data dictionary | IC |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAMAAHIST | No description in the Lawson data dictionary | MA |
| MAMADHIST | No description in the Lawson data dictionary | MA |
| MMDIST | Account Distributions | PO |
| MMUAVAL | No description in the Lawson data dictionary | PO |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POAGMAUDIT | Vendor Agreement Audit | PO |
| POAGMTPRIC | Agreement Pricing | PO |
| POAOCDTL | Add On Cost Detail | PO |
| POAOCMAST | Add On Cost Master | PO |
| POAOCSPRD | Add On Cost Spread | PO |
| POAPPROVE | No description in the Lawson data dictionary | PO |
| POAUDIT | Audit Records | PO |
| POCODE | Purchase Order Codes | PO |
| POCOMPANY | Company System Master | PO |
| POHDROUT | No description in the Lawson data dictionary | PO |
| POHDRPVT | No description in the Lawson data dictionary | PO |
| POINTAOC | Interface Add On Cost | PO |
| POINTAUDIT | No description in the Lawson data dictionary | PO |
| POINTERFAC | Interface File | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POIVACMNT | No description in the Lawson data dictionary | PO |
| POLINE | Line Items | PO |
| POLINEOUT | No description in the Lawson data dictionary | PO |
| POLINEPVT | No description in the Lawson data dictionary | PO |
| POLINESRC | PO Line Source | PO |
| POMATCHOBJ | Cost Change Information | PO |
| POMESSAGE | Buyer Messages | PO |
| POPCRUF | No description in the Lawson data dictionary | PO |
| POPLIUF | No description in the Lawson data dictionary | PO |
| POPOVUF | No description in the Lawson data dictionary | PO |
| PORECEIVE | PO Receivers | PO |
| PORECLINE | PO Line Item Receivings | PO |
| PORETURNHD | PO Return Header | PO |
| PORETURNLN | PO Return Line | PO |
| POREVISION | PO Revision | PO |
| POTRACK | Package Tracking Number | PO |
| POTRANSDTL | PO Transaction Detail | PO |
| POVACOMMIT | Commitments for Vendor Agrmt | PO |
| POVACOMMIX | No description in the Lawson data dictionary | PO |
| POVADIST | Vendor Agreement Distribution | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| POVAGRMTLN | Vendor Agreement Line | PO |
| POVAPARTLN | Contract Participant Line | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| PURCHORDER | Purchase Order Master | PO |
| RECAOCDTL | Receiving AOC Detail | PO |
| REQHEADER | Requisition Header | RQ |
| REQLINE | Requisition Line | RQ |
| ROUTEDOC | Route Document | WH |
| ROUTEHDR | Route Header | WH |
| ROUTESTOP | Route Stop | WH |
| RQAUDIT | Requisition Audit | RQ |
| RQTRANS | Requisition Transactions | RQ |
| SOHDETAIL | Stock-on-Hand Detail | IC |
| SUBCKPOINT | Subledger Check Point | IF |
| SYSTEMCODE | System Code | IF |
| TERMS | Payment Terms Maintenance | TE |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
| WHDEMAND | Demand | WH |
| WHDEMNDHDR | Demand Header | WH |
Referenced files (187)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCONSOL | Activity Consolidation | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACPRDPERF | Activity Period Performance | AC |
| ACTRANS | Activity Transaction | AC |
| AMASSETBOD | No description in the Lawson data dictionary | AM |
| AMASSETDSP | Asset Disposal | AM |
| AMASSETTRF | Asset Transfer | AM |
| AMASTBKDSP | Asset Book Disposal | AM |
| AMASTBKTRF | Asset Book Transfer | AM |
| AMASTITDSP | Asset Item Disposal | AM |
| AMASTITTRF | Asset Item Transfer | AM |
| AMASTMXVAL | Asset Attributes | AM |
| AMASTRPAIR | Asset Repair | AM |
| AMBOOK | Asset Book Name | AM |
| AMCOMPUTE | Compute | AM |
| AMLOCDTL | Location Detail | AM |
| AMMETHOD | Asset Method | AM |
| AMPUCODE | Asset Personal Use Code | AM |
| AMTABLEPCT | Percent Table | AM |
| AMTABLETAX | Asset Management Tax Table | AM |
| AMTRANSBOD | No description in the Lawson data dictionary | AM |
| AMTYPALLOC | The The Asset Management Type Allocation file stores the allocation history for a type (type and subtype). | AM |
| AMTYPALLOX | The Asset Type Allocation Detail file stores the accounting units and percentages for each company, asset type (or… | AM |
| AMUOPPDS | Units of Production Periods | AM |
| APACCRCODE | Invoice Accrual Code | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | AP |
| APCOMMENTS | Comments | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APDISCCODE | Discount Code | AP |
| APDISTHDR | Distribution Code Header | AP |
| APHLDINV | Hold | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income Code | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APPAYMENT | Invoice Payment | AP |
| APPROCGRP | Process Group | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| APUAVAL | No description in the Lawson data dictionary | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVENLOC | Vendor Location | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCOMP | Accounts Receivable Company | AR |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| ARCUSTOMER | AR Company Customer | AR |
| BILLTO | Bill To | AR |
| BUYBOD | No description in the Lawson data dictionary | PO |
| BUYCLASS | PO Buyer Purch Class Auth | PO |
| BUYCMPLOC | No description in the Lawson data dictionary | PO |
| BUYVENPF | Buyer/Vendor Purchase From | PO |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| COMPONENT | User Field | IC |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUSTORDER | Customer Order File | OE |
| CXBURDEN | Case Cart Burden | CX |
| CXCASEPREF | Case Cart Preferences | CX |
| CXPTMPITEM | Template Items | CX |
| EEADVANCE | Employee Advance | AP |
| EEAPPROVAL | Expense Advance Approval Code | AP |
| EEEXPENSE | Employee Expense | AP |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| HCCHRGITEM | Charge Item | IC |
| ICBIN | Bin Numbers | IC |
| ICCATEGORY | GL Account Category | IC |
| ICCOUT | No description in the Lawson data dictionary | WH |
| ICFACILITY | Ship To Facility | IC |
| ICITEMGTIN | Inventory Item for GTIN | IC |
| ICMFGCODE | IC Manufacturing Code | IC |
| ICMFGDIST | IC Manufacturers Distribution | IC |
| ICRPTGRP | Report Group | IC |
| ICVALUOM | Valid Units Of Measure | IC |
| INDOCTPCD | No description in the Lawson data dictionary | TX |
| INLINETYPE | No description in the Lawson data dictionary | TX |
| INSTATPROC | Intrastat Stat Procedure | TX |
| INSTCMDTY | ICN and Unit of Measure Codes | TX |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTNOTC | Intrastat Nature of Trans Code | TX |
| INSTPORTS | No description in the Lawson data dictionary | TX |
| INSTREGN | Intrastat Region Code | TX |
| ITEMGROUP | Item Group | IC |
| ITEMMAST | Item Master | IC |
| ITEMSPECL | No description in the Lawson data dictionary | IC |
| ITEMSRC | Item Source | IC |
| ITEMSUB | Item Substitute | IC |
| KITITEM | Kit Item | IC |
| KWDSETUP | No description in the Lawson data dictionary | IC |
| KWDSYNONYM | Keywords Synonym | IC |
| LMLEASE | Lease Information | LM |
| LMLEASESEG | This file stores the user analysis values for a lease. | LM |
| MACOMPANY | Matching Company | MA |
| MAELMGPREL | Match Element Group Relation | MA |
| MAELMVALUE | Matching Element Value | MA |
| MAINVHAND | Invoice Handling Code | MA |
| MAJORCL | Major Class | IC |
| MAMATCHTBL | Match Table | MA |
| MAMSGTOL | No description in the Lawson data dictionary | MA |
| MAMTCHELEM | Matching Elements | MA |
| MAMTCHRULE | Matching Rules | MA |
| MAPOINV | Multiple PO Invoice | MA |
| MAREASONCD | Matching Reason Code | MA |
| MATCHCLASS | Match Class | MA |
| MFGSHPFAC | Manufacturer Relationship | IC |
| MINORCL | Minor Class | IC |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| NATACCT | Accounts Receivable Natl Acct | AR |
| NATBALANCE | AR National Account Balance | AR |
| OECOMPANY | Order Entry Company | BL |
| OECUST | Customer Order Processing | AR |
| OEFRTCODE | Order Entry Freight Code | BL |
| OEROUTE | Order Entry Route | OE |
| ORDERTYPE | Order Type | OE |
| PDCARD | P-Card | PO |
| PDCCHRGERR | No description in the Lawson data dictionary | PO |
| PJLBOD | No description in the Lawson data dictionary | PO |
| POAGMTPART | Vendor Agreement Participants | PO |
| POAPPCODE | No description in the Lawson data dictionary | PO |
| POAUDRULES | Audit Rules | PO |
| POAUDTYPE | Audit Types | PO |
| PODOCREF | Document Reference | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POMXVAL | Attribute | PO |
| POPCRUF | No description in the Lawson data dictionary | PO |
| POPLIUF | No description in the Lawson data dictionary | PO |
| PORECADJHD | Receiving Adjustments Header | PO |
| PORECADJLN | Receiving Adjustments Line | PO |
| POREVISION | PO Revision | PO |
| PORLNUF | No description in the Lawson data dictionary | RQ |
| PORQHUF | No description in the Lawson data dictionary | RQ |
| POVAGLNERR | No description in the Lawson data dictionary | PO |
| PROCLEV | Matching Process Level | MA |
| PROCTEMPLN | Procurement Template Line | PO |
| PROCUREGRP | Procurement Group | PO |
| PTHBOD | No description in the Lawson data dictionary | PO |
| PVHBOD | No description in the Lawson data dictionary | PO |
| REASON | Reason Code | IC |
| REQUESTER | Requester | RQ |
| RQLOC | Requesting Locations | RQ |
| STATICCUST | AR Ovrd Credit Trans Review | AR |
| STCOMMCODE | PO Standard Comment Codes | PO |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
| WHPROCTYPE | Shipment Process Type | WH |
| WHSHIPLINE | Shipment Line | WH |
| WHSHIPMENT | Shipment | WH |
| WHSHLAUD | Shipment Line Audit | WH |
Program calls
Invoked programs (42)
ACAC, ACSB, ACTA, AMCO, API3, API4, GLCC, ICCP, ICI1, ICI9, IFAC, IFAU, IFCU, IFFC, IFGT, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, POBL, POCP, POI1, POI4, POI6, POI7, POI9, POIA, POIF, POIG, POIH, POII, POIJ, POIL, POIM, POIX, SLFD, SLSB, SLSE, SLSS, SLSU