|
|
IC141 - Location Replenishment Report
**Form Purpose
Run Location Replenishment Report (IC141) to print a report of replenishment
quantities for items with an available quantity less than the reorder point
for items that are stocked from another location.
**Processing Effect
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
ADDRDATA -
CKPOINT - Used in backout or restart circumstances.
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.
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 -
PORQHUF -
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.
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.
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.
APDISTCODE -
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 -
CUCONV - Used to obtain currency conversion information.
CURELAT - Used to validate currency relationship.
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.
ICUSRFLDEF -
ICVALUOM -
INSTCTRYCD -
ITEMGROUP - This file enables companies to share Item Master records or to
keep them separate by company.
ITEMMAST - Used to print the item description.
ITEMSRC -
KWDSETUP -
MACOMPANY -
MAJORCL - Used to validate major class.
MAMTCHELEM -
MATCHCLASS -
MINORCL - Used to validate major-minor class.
POAGMTPART -
POCOMPANY - Used to validate company number in the Purchase Order system.
POITEMVEN - Used in a Requisitions common routine.
POUSRFLDEF -
POVAGRMTHD -
POVAGRMTLN -
POVENDLOC -
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.
SLSEGMENT -
SLSEGVALUE -
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.
INVOKED Programs
ACAC
ACCL
ACTA
API4
IFAC
IFAU
IFCU
IFOB
IFSG
SLSE
SLSU
IFLU
API3
ICI1
ICI8
IFSC
POI6
POI4
POIF
IFRS
POIG
POIH
POIM
POIX
SLUA
SLSR
SLSS
|
