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
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.
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.
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.
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 -
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.
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.
WHDEMNDHDR - The Demand Header file contains document header records.
Referenced Files
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.
APVENGROUP - A vendor group represents a group of vendors that can be
shared by one or more accounts payable companies.
BUYCLASS -
BUYCMPLOC -
BUYER - Used to validate the buyer codes.
BUYVENPF -
COMPONENT - Contains the component items that make up a kit item.
CUCONV - Used to obtain currency conversion information.
CURELAT - Used to validate currency relationship.
CUSTORDER -
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.
ICRECEIPTS - The cost history file which is used for LIFO and FIFO costing.
ICRPTGRP - Used to validate report group.
ICVALUOM -
INSTCTRYCD -
ITEMMAST - Used to print the item description.
ITEMSRC -
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.
MACOMPANY -
MAJORCL - Used to validate major class.
MAMTCHELEM -
MATCHCLASS -
MINORCL - Used to validate major-minor class.
OECOMPANY -
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.
POCOMPANY - Used to validate company number in the Purchase Order system.
POITEMVEN - Used in a Requisitions common routine.
POVAGRMTHD -
POVENDOR - Used to validate the vendor information.
PROCTEMPLN -
PROCUREGRP -
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.
STCOMMCODE - This is a file of valid standard comment codes used to add
comments to a purchase order.
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
IFCU
IFSG
API3
IFAC
IFAU
SLSE
SLSU
API4
ICI1
ICI8
POIF
IFOB
IFRS
POIG
POIH
RQCP
|
