MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Technical Library > Financial > Inventory Accounting > Programs > Inventory Movement Detail Inquiry - Purpose > Inventory Movement Detail Inquiry - Calculations

Inventory Movement Detail Inquiry - Calculations

IA820E

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 time is saved for printing on the report.

6.   The Inventory Control record (ICCTL1) is retrieved to obtain the Lot Control Option (LOTOPT).  If this record is not found, a message is sent to the system operator, and processing is terminated.

7.   The following information is retrieved from the Reference file (REFERP).

a.   The date format record (category 049) is retrieved.  If this record is not found, a message is sent to the system operator, the date format defaults to MMDDYY, and processing continues.

b.   The system options record (category 133) is retrieved to determine whether this is a single or multi-currency environment.

c.   The Applications Installed record (category 012) is retrieved to determine if the Expert Configurator Module is installed.

d.   Order/receipt and inventory balance/movement quantity decimal positions are retrieved from the quantity field sizes record (category 446).  If this record is not found, a message is sent to the system operator and the program terminates.

e.   The adjustment codes record (category 432) is retrieved, and the adjustment codes and corresponding values are loaded into an array.  If this record is not found, a message is sent to the system operator, and processing is terminated.

8.   The program entry mode is determined.

a.   If program entry is through the Warehouse Balance Inquiry program (IA810E), 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 Inventory Movement Select Screen (IA820S01) is displayed, the user has three options.  Each option is described below.

a.   If the user presses the ENTER key, all fields on the screen are validated.  See the Inventory Accounting User Manual for validation rules.

(1)  If all fields are valid, processing continues with the detail screen.

(2)  If one or more fields are invalid, the appropriate error message is displayed and the incorrect field is highlighted.

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.   In a multi-currency environment, the base currency for the company/warehouse location is retrieved from the entity name record (category 002) on the Reference file (REFERP).

2.   The Previous Period End Date is determined and displayed on the screen header.

a.   The current fiscal period number is retrieved from category 023 on the Reference file (REFERP).

b.   The end date of the previous period is retrieved from category 013 of the Reference file (REFERP).

c.   One is subtracted from the current fiscal period number to obtain the previous period number.

d.   If the current fiscal period number is 1, the previous period number is the last period of the previous fiscal year, which will be either period 12 or period 13.

3.   The Unit Cost is determined according to the part's costing type and type of warehouse and displayed on the screen header.

a.   If the part is configuration costed, the Unit Cost and Previous Period Balance are based on the Configuration Code's Costs retrieved from the Configuration Code file (EC140M).

b.   If the warehouse is a manufacturing warehouse, the Unit Cost is the sum of the material, labor and overhead costs on the part master record.

c.   If the warehouse is a standard warehouse, the Standard Unit Cost is retrieved from the Warehouse Balance file (IC140M).

d.   If the warehouse is a moving average warehouse, there is no standard Unit Cost.  No standard Unit Cost is displayed on the detail screen.

4.   If the part is configuration costed, the program reads all records on the Configuration Assignment logical file (EC170ML1) to find all lots associated with the configuration code.  Each lot is loaded into an array to be used later.

5.   The program reads all records on the Inventory Audit Trail file (IA820AL) for the requested company/warehouse/part.  For each record, the appropriate fields are formatted and a subfile record is written.

a.   If the part is configuration costed, the lot number on the audit trail record is validated against the lot array.

b.   The transaction type (purchase order receipt, transfer order receipt, component issue, manufacturing order receipt, adjustment, transfer, customer shipment or transfer order shipment) is determined, and the corresponding description field is formatted.

c.   The data fields appropriate to the transaction type are formatted (Purchase Order Number ("FLOW" for a part defined as Just-In-Time), Manufacturing Order Number, Customer Order Number, Transfer Order Number, or Adjustment Code).

d.   The program determines the effect of the transaction on inventory (an increase or decrease) based on the Reversal Code and the Adjustment Code.  A transaction that decreases inventory is displayed with a negative sign.

e.   The transaction is costed based on the Costing Option of its warehouse, if the part is not configuration costed.

(1)  For a moving average warehouse:

Transaction
Value
Cost


equals

Transaction
Quantity


times

Moving
Average
Cost

 

(2)  For a standard or manufacturing warehouse:

Transaction
Value

equals

Transaction
Quantity

times

Standard
Unit Cost

 

f.    For a configuration costed part:

Transaction
Value

equals

Transaction
Quantity

times

Configuration Code Unit Cost

6.   Totals are accumulated for Transaction Quantity and Transaction Value and displayed on the screen.

      If overflow occurred when calculating total cost, then a warning message is printed on the report.  This will indicate that amounts printed in the report might have been truncated due to overflow.

7.   SCROLL UP is used to display the detail subfile page by page.

8.   The detail screen response is determined by the user's input:

a.   If the user presses the ENTER key, the select screen is redisplayed with blank data fields and another inventory movement inquiry can be processed.

b.   If F11 - Warehouse Balances is pressed, the Warehouse Balance Inquiry program (IA810E) is called and the Warehouse Balance Inquiry Select Screen (IA810S01) is displayed with the same part number.

c.   If F12 - Print Screen is pressed, the information on the detail screen is printed on the Inventory Movement Detail report (IA820A).

d.   If F3 - Exit is pressed, the program is terminated normally.

IA820E Program Menu