Documentation >
MAC-PAC Technical Library >
Financial >
Inventory Accounting >
Programs >
Manufacturing Order Accounting Detail - Purpose >
Manufacturing Order Accounting Detail - Calculations
Manufacturing Order Accounting Detail - Calculations
IA570E
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. Key lists are defined for each file retrieved by the program.
3. Work fields are defined and program constants are initialized.
4. The system time is saved for printing on reports.
5. The Company Name is retrieved from the System Control file (CT100M). If this record is not found, a message is sent to the system operator, a default message is used, and processing continues.
6. 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. Order/receipt and inventory balance/movement quantity decimal positions are retrieved from the decimal field precision record (category 446). If this record is not found, a message is sent to the system operator and the program terminates.
c. The applications installed record (category 012) is retrieved and the Shop Floor Installed Flag is saved to determine if the Shop Floor Control Application has been installed.
B. Mainline
1. The Report Requests file (IA320AP) is read sequentially for all Manufacturing Order Accounting Detail Report Requests (Transaction Code = R57). Each request is processed as follows.
2. The request is checked to determine whether a manufacturing order exists for the request on the Manufacturing Order file (IC100ML1). If no manufacturing order exists, an error message is printed on the report, and processing for that request is terminated.
3. The Part Master file (DE100M) is read to retrieve Accounting Cost, Part Description, and Configuration Code Option for the parent part. If the Configuration Code Option (PMCFCO) is 3 or 4 the part is configuration costed. In this case, the accounting costs associated with the configuration code are retrieved from the Configuration Code file (EC140M).
4. The accounting cost of receipts is calculated, as follows:
|
Accounting Cost of Receipts Material
|
equals
|
Quantity Received
|
times
|
Accounting Standard Unit
Cost-Material
|
|
|
Accounting Cost of Receipts Burden
|
equals
|
Quantity Received
|
times
|
Accounting Standard Unit
Cost-Burden
|
|
|
Accounting Cost of Receipts-
Labor
|
equals
|
Quantity Received
|
times
|
Accounting Standard Unit
Cost-Labor
|
|
Accounting Cost of Receipts Miscellaneous
|
equals
|
Quantity Received
|
times
|
Acct. Misc. Material Cost
|
plus
|
Acct. Misc. Labor Cost
|
plus
|
Acct. Misc. Burden Cost
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5. All audit trails for the order are read from the Manufacturing Order Receipts/Component Issues Audit Trail file (IA570AL1).
6. The component requirements are processed.
a. The component requirements for the order are retrieved from the Component Requirements file (IC120M).
b. For each component, the part master record is retrieved. If the component is configuration costed (PMCFCO = 3 or 4), the costs are based on the configuration code from the Configuration Code file (EC140M). Otherwise, the component's accounting costs are used.
c. The corresponding audit trail records are retrieved from the Manufacturing Order Receipts/Component Issues Audit Trail file (IA570AL1).
d. Totals for each component are printed on the report.
7. The labor requirements are processed.
a. All labor requirements for the order are retrieved from the Labor Requirements file (IC125M).
b. The corresponding audit trail records are retrieved from the Shop Floor Audit Trail file (IA570AL2).
c. The totals for each new labor requirement are printed on the report.
8. The miscellaneous cost for the order is processed.
a. If the parent part is configuration costed (PMCFCO = 3 or 4), the miscellaneous costs and the average order quantity are retrieved from the Configuration Code file(EC140M).
b. If the part is not configuration costed the costs are retrieved from the Miscellaneous Cost Header file (ME160M1). The average order quantity is retrieved from the Part Master file (DE100M).
c. The miscellaneous cost is calculated based on the number of receipts, as follows:
d. The Labor Requirements file (IC125ML2) is read to determine if there are any quantity complete transactions for the manufacturing order. If any are found, a message is printed on the report and the miscellaneous cost processing is terminated.
e. All audit trails for a given labor requirement are processed for quantity complete miscellaneous cost.
f. After each labor requirement is processed, totals are printed on the report.
9. If overflow occurred when calculating total cost for the component, labor, and miscellaneous 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.