IC141 - Location Replenishment Report Run this program to print the Location Replenishment Report for items that are stocked from another location. This program calculates replenishment quantities for items with an available quantity less than the reorder point. Available quantities are based on the current stock-on-hand quantities minus allocated, picked, and backordered quantities plus on-order and intransit quantities. This report applies to items set up in IC12.1 (Item Location) with the following. - A replenishment location set up in the Source form. - The following set up in the Reorder form: reorder point and one of the following reorder document types: issue, transfer, intransit (X), or requisition. You can create unreleased documents based on the reorder document code. Unreleased documents can be reviewed and released in IC21.1 (Issues), IC22.1 (Transfers), RQ10.1 (Requisition). If you create unreleased documents, you can enter the general ledger posting date. Important: To create intransit documents you must enter an estimated delivery date. To create requisition documents you must set up requesters in RQ04.1 (Requesters). Define requesters based on the form name followed by the requesting location. For example, to run this program for the Minneapolis (MPLS) location, set up IC141MPLS as a requester. This program prints by company, location, report group, and/or inventory class. You also can also include items set up as inactive in IC11.1 (Item Master). This report prints by replenishment location in item number sequence the required leadtime, safety stock quantity, reorder point, stock-on-hand, supply minus demand quantity, and reorder quantity. Updated Files ACCOMMIT - This file contains commitments not yet posted to the general ledger. ACCOMMITX - This file contains commitment details not yet posted to the general ledger. CKPOINT - Used in backout or restart circumstances. 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 number, or multiple unit of measure. ICACTIVITY - Created for items with a reorder document code equal to I , T, or X and the program is run in update mode. ICCOMPANY - Used to validate company number. ICLOCATION - Used to validate location entered and display location name. 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 which is used for LIFO and FIFO costing. ICTRANS - Detail file maintained by program. ITEMGROUP - This file enables companies to share Item Master records or to keep them separate by company. ITEMLOC - Contains records with replenishment information, stock-on-hand quantities, and other reorder information by item. ITSERIAL - This file 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 in a Requisitions common routine. PURCHORDER - Used in Requisitions common routine. REQHEADER - Created when the program is run in update mode and the reorder document is equal to R. REQLINE - Created when the program is run in update mode and the reorder document code is equal to R. ROUTEDOC - The Route Document file contains documents that are to be delivered along a route. ROUTEHDR - For all routes created, a header record is added to the Route Header file. ROUTESTOP - The Route Stop file contains records set up to identify the stops along a route. RQAPPROVE - This is the file of open approval records needing to be approved, created for each approval amount level that is less than the requisition total value. RQCOMMENTS - This file contains both the header and line comments for a requisition. SOHDETAIL - Used to extract detail quantities. TXCODEMAST - The Tax Code Master file contains tax codes, descriptions, and the tax types that define how the tax code is to be 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 - Used in an Accounts Payable common routine. WHDEMAND - The Demand file contains all the records that the Warehouse system needs for processing demands. WHDEMNDCMT - The Demand Comment file contains comments on the demand records. WHDEMNDHDR - The Demand Header file contains document header records. Referenced Files ACACCTCAT - Used to validate account categories maintained in the Activity Management system. ACACTGRP - 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 to get the vendor group for vendor number validation. APCPYVND - The Vendor Company Codes file contains default codes assigned a vendor or alternate vendor location at the company level. APHLDINV - The Hold file contains records of vendors, invoices, and payments that are on hold. APVENCLASS - A vendor class is a subgroup of vendors that share common payment or processing characteristics, such as office supply vendors or employees. APVENGROUP - A vendor group represents a group of vendors that can be shared by one or more accounts payable companies. APVENLOC - Used to validate the vendor purchase from locations. APVENMAST - Used to validate the vendor numbers. BUYER - Used to validate the buyer codes. COMPONENT - Contains the component items that make up a kit item. CUACCT - This file contains account numbers that are variance amounts are posted to when a timing difference occurs between the beginning and the completion of a transaction. CUCONV - Used to obtain currency conversion information. CURELAT - Used to validate currency relationship. CUTABLE - This file defines currency tables. GLADDRESS - Used to obtain general ledger address information. GLCHART - Used validate system account. GLCODES - Used in a General Ledger common routine. GLINTCO - This file contains interzone and intercompany relationships. GLSYSTEM - Used in a General Ledger common routine. ICBIN - Used to validate bin numbers. ICCATEGORY - Used to retrieve account information. ICRPTGRP - Used to validate report group. ITEMMAST - Used to print the item description. ITEMSUB - The Item Substitute file stores valid substitutes for an item. KITITEM - This file contains the valid kit or parent items for a kit or assembly. MAJORCL - Used to validate major class. MINORCL - Used to validate major-minor class. OEFRTCODE - This file contains freight codes that can be used in the Warehouse system. OEROUTE - This file contains all user-defined routes that are set up in the Warehouse system. ORDERTYPE - The Order Type file stores order type parameters. POCOMMENTS - This file contains all purchase order comments associated with both actual and standard purchase orders. POCOMPANY - Used to validate company number in the Purchase Order system. POITEMVEN - Used in a Requisitions common routine. POLOCCON - List of valid override contracts for a location. POQUOTES - Used in a Requisitions common routine. POVENDOR - Used to validate the vendor information. REQUESTER - Used to validate a requester name. RQACCTU - This is the list of valid accounting units that this requester can enter on a requisition. RQAPPCODE - Used to validate approval codes. RQLOC - Used to validate requesting location. RQPURCHCLS - This file contains the list of valid purchasing major classes that a requester can enter items for on a requisition. RQTEMPLINE - This file contains the items on a requisition template. STCOMMCODE - This is a file of valid standard comment codes used to add comments to a purchase order. STPOLINE - Used to obtain standard purchase order line item information. STPURCHORD - Used to obtain standard purchase order information. 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. INVOKED Programs ACAC IFCR IFSG IFCU IFAC IFAU SLSE SLSU IFCC IFOB IFRS |