Documentation >
MAC-PAC Technical Library >
Financial >
Job Costing >
Programs >
Job Cost Generation - Material - Purpose >
Job Cost Generation - Material - Calcluations
Job Cost Generation - Material - Calcluations
JA120E
A. Housekeeping
1. Parameters, key lists, and fields are set up.
2. Work fields are defined and initialized.
3. Data is retrieved from the Reference file (REFERP).
Note: Housekeeping is performed the first time the program is called: It is not performed on subsequent calls to the program within the same job stream.
B. Mainline
Material Cost Generation is performed for the job passed to JA120E from the Labor Cost Generation program (JA110E).
1. The Component Requirement file (IC120ML2) is read to retrieve component requirements for the job. If no components exist, control is passed back to the calling program (JA110E).
2. For non job-controlled parts, planned, actual, and projected quantities are calculated. See the Job Costing User Manual for details. Note: the total cost is calculated in the Job Cost Report program using the standard unit cost from the Part Master file). If the part is configuration costed actual quantities are stored on the Material Configuration Cost file (JA110M2) by configuration code.
3. For job-controlled parts, planned, actual, and projected quantities and costs are calculated. See the Job Costing User Manual for details.
a. Planned
The Manufacturing Order file (IC100L31) is read to retrieve manufacturing orders for the job/part being processed (purchased and raw material parts are excluded). If the quantity is not satisfied by the manufacturing orders, an uncovered planned quantity is determined.
The Purchase Order file (PO180L21) is read to retrieve purchase orders for the job/part being processed (excludes those canceled or with a received quantity equal to zero). Quantity is accumulated and:
(1) If the planned material costing option (Reference File category D52) is purchase order, the purchasing order unit cost is incremented, a multi-currency conversion routine is performed in a multiple currency environment, and the total cost is calculated.
(2) If the planned material costing option (Reference File category D52) is standard, the unit and total costs are calculated in the Job Cost Report program (using the standard cost from the Part Master file).
b. Actual
(1) If the actual material costing option (category D52) is purchase order or standard, the Purchase Order Receipt Audit Trail file (IC140BL1) is processed. If the part is configuration costed, the lot number must exist on the Configuration Assignment Master file (EC170M). If the option is purchase order, the total cost is calculated. See the Job Costing User Manual for details. If the option is standard, the unit and total costs will be calculated in the Job Cost Report program using the standard cost from the Part Master.
The audit trail record is marked as accounting processed (JAFLG) and commitment control is checked. If the total number of audit trail records processed is greater than the maximum number of records processed before a commit, from Reference File category 017, the Job Material Cost file is updated.
(2) If the actual material costing option is invoice (category D52), the Purchase Order Receipts file (PO212ML8) is read to retrieve receipts for the job/part being processed. If the part is configuration costed, the lot number must exist on the Configuration Assignment Master file (EC170M). The Invoice Receipt Match file (AP140ML1) is then read to retrieve the invoices associated with the purchase order receipt. The actual job purchases quantity and total cost are determined. See the Job Costing User Manual for details.
(3) Transfers are processed.
The Transfer "From" Audit Trail file (IC120BL2) is read for the job/part being processed. If the part is configuration costed, the lot number must exist on the Configuration Assignment Master file (EC170M). The transfer "from" quantity is subtracted from actual net transfers to inventory (MJAQST and MCJQST for configuration costed parts), the job accounting processed flag (JAFLG) is turned on, and commitment control is checked.
The Transfer "To" Audit Trail file (IC120BL1) is read for the job/part being processed. If the part is configuration costed, the lot number must exist on the Configuration Assignment Master file (EC170M). The transfer "to" quantity is added to actual net transfers to job inventory (MJAQST and MCJQST for configuration costed parts), the job accounting processed flag (JAFLG) is turned on and commitment control is checked.
(4) Group Component Issues are processed.
The Manufacturing Order Receipts/Component Issues Audit Trail file (IC310BL1) is read for group issues for the job/part being processed. If the part is configuration costed, the lot number must exist on the Configuration Assignment Master file (EC170M). The issue quantity is added to the actual group component issue quantity (MJAQGP and MCJQST for configuration costed parts), the accounting processed flag (JAFLG) is turned on, and commitment control is checked.
(5) Excess Component Issues are processed.
The Manufacturing Order Receipts/Component Issues Audit Trail file (IC310BL1) is read for all excess component issues for the job/part being processed. If the part is configuration costed, the lot number must exist on the Configuration Assignment Master file (EC170M). The issue quantity is added to the actual excess component issue quantity (MJAQCI and MCJQST for configuration costed parts), the accounting processed flag (JAFLG) is turned on, and commitment control is checked.
(6) Adjustments are processed.
The Inventory Adjustment Audit Trail file (IC120BL3) is read for the job/part being processed. If the part is configuration costed, the lot number must exist on the Configuration Assignment Master file (EC170M). The adjustment codes reference category (432) is then read to determine if the adjustment is an increase or decrease to inventory. The adjustment quantity is then added to the actual adjustment quantity (MJAQCI and MCJQST for configuration costed parts), the accounting processed flag (JAFLG) is turned on, and commitment control is checked.
(7) By-Product Receipts are processed.
The By-Product Receipt Audit Trail file (IC130BL2) is read for the job/part being processed. If the part is configuration costed, the lot number must exist on the Configuration Assignment Master file (EC170M). The by-product quantity is subtracted from the actual by-product quantity (MJAQBP and MCJQBP for configuration costed parts), the accounting processed flag (JAFLG) is turned on, and commitment control is checked.
(8) If the part is configuration costed, update the Material Configuration Cost file (JA110M2) with the actual quantities.
c. Projected
(1) All actual quantities (purchases, stock transfers, group issues, and excess issues) are added to the actual quantity for by-products.
(2) Compare the revised planned quantity and the total actual quantity. Add the greater of these to the projected quantity.
(3) Update the Material Cost file (JA110M) with the projected, actual, and planned quantities.
4. Control is returned to the calling program (JA110E).