Material Ledger - How to reconcile COGS in FI vs Actual COGS in COPA (calculated from KE27)

[chengshiong_kwan]

Dear all experts,

Client is asking how the material related costs posted in FI tally back with Actual COGS posted from KE27 in COPA. Is it even possible to tally FI vs COPA specifically the entire COS (COGS + all sort of variances)?

Thank you.

Sincerely,

Sebastian

[malay_vakil]

Hi Sebastian,

It is very much possible but it requires below things are taken care

Transaction related:

- PGI and billing completed in

- ML closure is competed with CO revaluation

Config Related:

-Movement type group is defined as " Revaluation of G/L Account and CO Account Assignment"

- Assign movement type group to all PGI related movements

- COPA config for actual costing

Regards,
Malay

[Hemanthkumar]

Dear Sebastian,

Client is asking how the material related costs posted in FI tally back with Actual COGS posted from KE27 in COPA

KE27 posts delta values to value fields provided if the standard cost estimate values already got posted to COPA earlier, while the values posted to FI are not delta values rather actual COGS.

Let me exemplify for KE27

Lets assume standard cost was 10 usd during billing. After KE27, cost was revaluated to 90 usd then system posts the delta value ie., 80 usd to the value field.

To me, reconciliation of actual cogs in FI and delta values in copa (After KE27) seems illogical.

Is it even possible to tally FI vs COPA specifically the entire COS (COGS + all sort of variances)?

Could you please illustrate more on this query? If you are speaking about variances in FI and COPA, variances gets updated to a g/l account in FI where split of variances is not possible rather possible each variance category wise in COPA.

Best Regards,

Hemanthkumar