E1: 31A: R31802A Manufacturing Accounting Uses CTS4 for Actual A1 Amounts in the F3102 (Doc ID 1909675.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

 E1 9.0 / R31802A Manufacturing Accounting

When running the R31802A, Manufacturing Accounting, over an 07 cost work order with mixed mode turned off, the system will use the CTS4 amount for the actual amount column in the F3102. Therefore if component costs have changed after material issue transactions are created (F3111) but before the R31802A is run, the F3102 will have the incorrect actual amounts once manufacturing accounting is run. As a consequence, the R31804 will report an invalid actual variance.

Steps to duplicate:
1. Create a work order (P48013) and attach the parts list and routing (R31410).
2. Inquire on the P31022, Standard and Current amounts.
3. Issue quantities using the P31113.
4. Inquire on the F3111 in databrowser. Note the CTS1 and CTS4 values.
5. Change the P4105 costs on the component items and roll new costs on parent/component items (R30812).
6. Freeze costs on all items (R30835).
7. Run the R31802A in final mode. Note that the IM journal entries are correct based on CTS1 and frozen standard costs of the components.
8. Inquire on the Production Cost Inquiry, P31022 Planned vs. Actual amounts. Notice that the A1 Actual amount is based on the CTS4 value in the F3111 rather than taking the CTS1 unit multiplied by the 07 frozen component costs in the F30026.

Changes

Cause