Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 10, 2017 at 08:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 11, 2017 at 06:27 AM

    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

    Add comment
    10|10000 characters needed characters exceeded