[Decision Expert Column] Chapter 12: Material Ledger Accounting Processing Logic (3)
Time: 2023-11-10
Views: 337

 

[Foreword]


The reason why Decision is highly praised by enterprises during the implementation of digital transformation projects is because experts are escorting Decision during the project process to help enterprises gain new knowledge, grow new capabilities, and improve management during the implementation of digital transformation projects. To improve our vision and reduce project misunderstandings, we have specially set up a "Decision Expert Column" to share with you a series of articles on the implementation of digital transformation projects, so stay tuned.

This article is based on Mr. Yang Yongqing, Decision’s chief financial expert, who has 24 years of rich experience in the field of SAP ERP, and combines the common misunderstandings he found in the implementation of ERP projects to publish corresponding research insights and suggestions to protect your SAP financial implementation and delivery.
 

 

[Problem Description]


When posting the material ledger CKMLCP, the system prompts M8147 that the account cannot be determined. Then I check the OBYC configuration and find that a bunch of difference codes need to be configured. How to use these difference codes and how to configure them?
 


[Posting Transaction Analysis]

OBYC transactions
PRV multi-layer material cost differences
PRY single layer material cost difference
KDV multi-tier exchange rate differences
KDM Single Level Exchange Rate Difference
Material cost variance to be borne by WPM WIP
Job cost variance to be borne by WPA WIP
PRM WIP discrepancy after completion
Account modification (sub-transaction) (general modification)
PNL: Transfer next level differences are carried forward to another level of material
PPL: Take from lower level The difference is carried forward from the lower level material
PSL: the revaluation of the single-level consumptions revaluation of single-level consumption differences
PWP: Offset posting for WIP reduction WIP difference is transferred out to product (same as PNL, differentiates WIP) transfer account
 

[For example]


①PRD/PRV/KDV/KDM common configuration logic
example:a raw material R1 is used to manufacture a semifinished product S1.For the procurement of the raw material, price differences of 100 are accrued.For the production of S1, single-level price differences (for example, from the production order settlement ) of 80 are accrued.Half of the produced S1 is in stock at the month-end closing, the other half is used for the production of F1.F1 is in stock at the period-end closing.

Example 1:
A raw material R1 is entirely used to produce semi-finished product S1 in the current period. A cost difference of RMB 100 occurs during the procurement of raw materials and needs to be carried forward to semi-finished products S1. For semi-finished product S1, the current production single-layer difference of RMB 80 will be transferred to semi-finished product S1 through production order settlement. There is only half the semi-finished product inventory at the end of the period, and the other half is used to produce product F1. After F1 is produced and put into storage, it is all in inventory at the end of the period.

Example 2:
The difference in the purchasing exchange rate of raw material R1 is 10 yuan. The input-output relationship of raw materials and semi-finished products is the same as above, and no other differences occur.

②PRD/PRV/KDV/KDM sub-transaction supplementary logic
2.1 PRD/PRV/KDM/KDM In the OBYC transaction code configuration, you can enable the sub-transaction supplementary configuration or not enable the account modification (sub-transaction) (general modification)

The following is to enable sub-transactions (general modification)
 



The following is to disable sub-transactions (general modification)
 



2.2 Account modification (sub-transaction) (general modification) PSL/PWP posting logic is the same as PNL


③WPM/PRM common configuration logic in products
Configure: PRM transaction, generally configured as: work in progress or work in progress cost difference.
Example: In January 2015, 1.2 tons of semi-finished products 20101102 were invested to produce finished products 107021010000. At the end of the month, the finished product order was not completed. Semi-finished products 20101102 shipped 1.2 tons from the warehouse. The single-layer difference to be borne: 520.76 yuan, the multi-layer difference: -40.10 yuan, the total difference amount : 480.66 yuan. In February 2015, the finished product 107021010000 was completed, and the following settlement posting was made to the material account WIP.
System WIP posting in January 2015:
Borrow: Cost difference of work in progress (20101102 input) Transaction WPM 480.66 yuan
Credit: Cost difference of semi-finished products (material 20101102) Transaction PRY 520.76 yuan
Borrow: Semi-finished product cost difference (material 20101102) Transaction PRV 40.10 yuan
System WIP posting in February 2015:

(1) Transfer of products in progress
Borrow: Product in process cost difference transfer (material 20101102) transaction PRM 480.66 yuan
Credit: Cost difference of work in progress (20101102 input) Transaction WPM 480.66 yuan

(2) The difference is transferred to the finished product
Borrow: Product cost difference (material 107021010000) Transaction PRV 480.66 yuan
Credit: Product in process cost difference transfer (material 20101102) transaction PRM 520.76 yuan
Borrow: Product in process cost difference transfer (material 20101102) transaction PRM 40.10 yuan
As can be seen from the above: PRM is just a transitional account, with a monthly balance of 0.
 

[Reference documents]

Refer to SAP NOTES:
483493 - Posting logic of the material ledger closing
732561 - Differentd acct detrmntn for reval of single-level consumptn
1507005 - Differentiated account determination for WIP postings
2558888 - S/4HANA: Post Closing logic in Material Ledger / New Actual Costing


【Service Guide】
For more information on SAP courses, project consultation and operation and maintenance, please call Decision's official consultation hotline: 400-600-8756


【About Decision】
Global professional consulting, technology and training service provider, SAP gold partner, SAP software partner, SAP implementation partner, SAP official authorized training center. Seventeen years of quality, trustworthy!

Online
Wechat
Phone
400-600-8756