[Foreword]
In order to better help customers implement digital projects, the "Decision Expert Column" is completely free and open source, paying tribute to Musk's open source spirit! Through 17+ years of professional digital service capabilities, a senior expert consulting team, and rich industry solutions, we continue to add value to the digital transformation of enterprises!
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]
The user asked that SAP uses table closing to carry forward the profit and loss account occurrences by default, and it does the data table carryover on an annual basis. Can it carry forward the profit and loss account occurrences according to the traditional accounting method and the monthly accounting method?
[Problem analysis]
?
SAP's IDCN China localization function can handle it.
[Solution]
?
①Activate configuration, transaction code SM30 view IDCN_V_ZJFCOCD
② Transaction code OB53 specifies the profit and loss to be carried forward to the account: profit for this year
③ Check the report for September 2022. The amount of the company's profit and loss account of 1000 yuan is 20,519,988.97 yuan (credit balance, profit)
④ The amount of profit and loss carried forward by the accounting method (test)
Front-end operation path: Accounting -> Financial Accounting -> General Ledger -> Period Processing -> Closing -> Open/Close Entries -> China -> Profit and Loss Carryforward
Transaction code IDCNPLFWD, accounting method, carries forward the profit and loss amount to "profit for the year". You can see that the profit and loss account amount summarized by the program is 20,519,988.97 yuan (credit balance, profit)
⑤ The amount of profit and loss carried forward by the accounting method (official operation), transaction code IDCNPLFWD
⑥ Transaction code SM35
⑦ Transaction code FB03 View carryover voucher
It turns out that the so-called profit and loss account carryover is a program that simulates manual vouchers and uses the BDC data batch generation method to make FI vouchers, as follows:
⑧ Transaction code FAGLB03, you can see that the monthly balance of the account is 0 (the amount issued by the borrower has been carried forward from the other party)
[Summary]
(1) The program can only be carried forward to "current year's profit". At the end of the year, it still needs to be manually carried forward from "current year's profit" to "profit distribution-undistributed profit";
(2) Voucher type of profit and loss account carry-forward. It is recommended to set a voucher type for a single document;
(3) After the profit and loss account is carried forward, FAGLB03 needs to exclude the carry-forward voucher when checking the amount;
(4) Profit and loss account carry-forward, without distinguishing the amount of profit center;
(5) Carry-forward of profit and loss account, without considering multiple assessments: the amount of profit and loss (statutory assessment/group assessment/profit center assessment);
(6) If auxiliary accounting requirements such as automatic bookkeeping, distribution, customers and materials are set for the profit and loss account, the batch posting of SM35 is wrong and needs to be handled manually;
(7) After the amount of the profit and loss account is carried forward, the financial voucher of the posting settlement month needs to be supplemented again: IDCNPLFWD.
【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!