Documentation >
MAC-PAC Technical Library >
Financial >
Inventory Accounting >
Programs >
Warehouse Balance Cost - Purpose >
Warehouse Balance Cost - Calculations
Warehouse Balance Cost - Calculations
IA810E
A. Housekeeping
1. See the Common Processing Routines - Housekeeping section of this manual for a general discussion of this subroutine. Processing specific to this program is described below.
2. A parameter list is set up to receive the fast path parameters.
3. Key lists are defined for each file retrieved by the program.
4. Work fields are defined and program constants are initialized.
5. The system options record is retrieved from Reference File category 133 to determine whether this is a single or multi-currency environment.
6. The Applications Installed record is retrieved from Reference File category 012 to determine if the Expert Configurator module is installed.
7. The System Control file (CT100M) is retrieved to obtain the company name record. If this record is not found, a message is sent to the system operator, a default message is used, and processing continues.
8. The program entry mode is determined.
a. If program entry is through the Inventory Movement Inquiry program (IA820E), the select screen data is passed to the program and validated. If all data is valid, the select screen is bypassed and the detail screen is displayed.
b. If program entry is through a fast path code, the passed Part Number is displayed on the select screen.
c. If program entry is through the Inventory Accounting Application Menu, the select screen is displayed with blank data fields.
B. Select
1. When the Warehouse Balance Select Screen (IA810S01) is displayed, the user has three options. Each option is described below.
a. If the user presses the ENTER key, the part number is validated against the Part Master file (DE100M).
(1) If the part number is valid, the Configuration Code Option (PMCFCO) is checked to determine the part's costing type. If the part is configuration costed (PMCFCO = 3 or 4) the Configuration Code is validated against the Configuration Code file (EC140M). If the configuration code is valid, processing continues with the detail screen.
(2) If the neither the part number nor the configuration code is valid, the fields are highlighted and an error message is displayed.
b. If F2 - Fast Path is pressed, the select screen is displayed with the fast path code and part fields in the upper right-hand corner of the screen. Select screen fields are input inhibited until fast path is canceled (by pressing F2 again). While in fast path, the user has two options:
(1) Pressing F2 cancels fast path and returns to the active select screen.
(2) Entering a fast path code and part and pressing the ENTER key transfers the user to the requested program.
c. If F3 - Exit is pressed, the program is terminated normally.
C. Detail
1. The company, warehouse number and balance quantities of the selected part are retrieved from the Warehouse Balance file (IC140M) if the part is not configuration costed. If the part is configuration costed, balance quantities for all lots associated with the configuration code in the current company/warehouse are retrieved from the Configuration Assignment logical file (EC170ML1). The company number and warehouse number are displayed on the screen.
2. In a multi-currency environment, the base currency for the company/location is retrieved from the entity name record (category 002) on the Reference file.
3. The general ledger location, warehouse type, warehouse description and warehouse description costing option are retrieved from the Warehouse Description file (IC170M) and displayed on the screen.
4. If the part is configuration costed, the costs and inventory value are calculated as follows.
a. The configuration code's costs are retrieved from the Configuration Code file (EC140M).
b. If the costs selection on the Function Select screen is accounting, the Configuration Code Accounting Standard Cost (CCASCT) is multiplied by the Sum of the Balance Type Quantities (CBALQ) to get the Balance (BALANC) which is written on the screen; else, if the cost selection is standard, CCCFT is multiplied by CBALQ to get BALANC.
5. For non configuration costed parts, the cost option is determined.
a. If the part is a nonstandard part or the warehouse description costing option is M, the cost option is moving average.
b. If the warehouse type is manufacturing, company and location are the same as the manufacturing company and location on the System Control file (CT100M), the cost option is manufactured.
c. If the warehouse description costing option equals S, the cost option is standard.
6. For non-configuration costed parts, the warehouse balance type quantities 1 - 4 for each warehouse retrieved from the Warehouse Balance file (IC140M) are totaled and displayed as the balance on the screen.
7. For non-configuration costed parts, the value of the warehouse balance is calculated and displayed on the screen.
a. For a moving average cost option, the warehouse balance moving average unit cost is multiplied by the balance quantity.
b. For a standard cost option, the standard unit cost is multiplied by the balance quantity.
c. For a manufactured cost option, the standard cost retrieved from the Part Master file (DE100M) is multiplied by the balance quantity.
8. The user may review Inventory Movement information for any of the displayed warehouses by entering an X before the desired warehouse and pressing F11 - Inventory Movement. The Inventory Movement program (IA820E) is called, using the same part number and the selected warehouse for inquiry.