Financial Management Blogs by SAP
Get financial management insights from blog posts by SAP experts. Find and share tips on how to increase efficiency, reduce risk, and optimize working capital.
cancel
Showing results for 
Search instead for 
Did you mean: 
ChristopheC
Product and Topic Expert
Product and Topic Expert
0 Kudos
760

Introduction


Please read first:

In this last blog about interest calculation and installment plans, we focus on the following business use cases:

  • As a collection agent, I can reclassify installments and related interests that are due in the next year to another G/L account.

  • As an accountant, I can update the general ledger and the budget accounting accordingly.


Reclassification


In order to demonstrate the reclassification process, we first need an installment plan with some installments that have a due date in the next year. These installments need to be displayed separately on the balance sheet.

Let’s create two overdue open items on a contract account of a business partner and check the account balance in the Business Partner Overview (transaction FMCACOV).

Note the fact that the due dates of the original items have been set so that the installment plan is created with five installments from October 2023 to February 2024.


Business Partner Overview – Two open items are overdue


In the F5720 – Manage Installment Plans Fiori App, we can now create our installment plan, with the same characteristics as the installment plan created in the first blog of the series, but this time with a start date of October 1st, leading to the creation of two installments in the next year.


Installment Plan Creation – Managing the installments


 

In the Excel extract below you can check that the interest was calculated properly.


Interest Calculation in Excel


 

Using an installment plan analysis for a key date, let's create a snapshot of the installment plan due dates on this key date, as well as of the assignment of these due dates to the original items.

First, let's define the receivables, the adjustment, and the target accounts.

  • In the customizing activity Define Receivables and Payables Accounts in IMG >  Contract Accounts Receivable and Payable > Closing Operations > Reclassifications



IMG Customizing Activity - Define Receivables and Payables Accounts




  • In the customizing activity Define Adjustment Accounts for Reclassification by Due Date in IMG >  Contract Accounts Receivable and Payable > Closing Operations > Reclassifications



IMG Customizing Activity - Define Adjustment Accounts for Reclassification by Due Date


Note: in our chart of accounts, the following G/L accounts are defined

  • 140020 Receivables due after 1 year

  • 140099 Receivables (Adjustment acct)


Then, using an installment plan analysis for a key date, we can create a snapshot of the installment plan due dates on a key date, as well as of the assignment of these due dates to the original items.

In the SAP Easy Access screen, go to Record Status of Installment Plans for Key Date in Periodic Processing > Closing Preparation > Receivables Valuation (transaction code FPIPKEY), and enter the parameters for the job. 


Record Status of Installment Plans for Key Date - Job Parameters and Job Log


The list of installment plan reports for a key date clearly identifies the two installments with a due date in the next year.


List of installment plan reports for a key date


Then, we can trigger the Key Date-Based Open Item List (transaction FPO1). The mass activity report Open Items at Key Date (transaction FPO1P) can be found in the SAP Easy Access screen, go to Record Status of Installment Plans for Key Date in Periodic Processing > Closing Preparation.

In this transaction, we set

  • the key date to 31.12

  • our company code

  • the "Consider Installment Due Dates" as determined by the Installment Plan Analysis for a key date report

  • the "Inst.Plan Due Dates Separate" to have the reclassification from installment plans on a separate reporting line in the execution log.



Open Items at Key Date - Selection parameters


 


Open Items at Key Date - Extract of the Execution Log


 

Finally, we can post the reclassifications by due date using Post Reclassifications by Due Date (transaction FPRECL_DUEGRID) in the SAP Easy Access screen, go to Record Status of Installment Plans for Key Date in Periodic Processing > Closing Preparation.

For the sake of clarity, we have changed the proposed reconciliation key to a new empty one and set the document type to SA for General Debit Document.


Post Reclassifications by Due Date


When hitting the Save button, the reclassification process is triggered, and two CA documents are created, one with a posting date of 31.12.02023 and one with a posting date of 01.01.2024.


CA documents created by the Reclassification Process


 

Updating the General Ledger


We have been using two reconciliation keys so far: one for the original items, charges, and interests, and one for the reclassification postings.

Let's first close the first reconciliation key using Fiori App F4531 - Manage Reconciliation Key.


Manage Reconciliation Key - Closing the first key


Note that the amounts have been aggregated according to the account assignments and the posting date.

We can now transfer the reconciliation key to General Ledger (transaction FPG1) in the SAP Easy Access screen, Accounting >  Financial Accounting >Contract Accounts Receivable and Payable > Periodic Processing > Forward Postings > Execution


Transfer to General Ledger - Setting the parameters


 

We have to set the Test Run / Update Run parameter to "2" to trigger the Update Run.


Transfer to General Ledger - Creating the FI and the FM documents


Two documents have been generated, one for the update of the general ledger in FI, and one for the update of the budget accounting in Funds Management.

 


Transfer to General Ledger - Displaying the FI/FM documents


 

The Fiori app F-3364 - Display Journal Entries in T-Account View gives a good overview of the postings made in the general ledger


F3664 - Display Journal Entries in T-Account View


We can now reproduce the same steps with our second reconciliation key, for the reclassification. After closing it, we can trigger the transfer to the general ledger, and two documents are created: one in 2023 and one in 2024.


Transfer to General Ledger - Transferring the reclassification


 

Now let's have a look again at the Journal Entries in T-Account View in 2023 and 2024.


Journal Entries in T-Account View in 2023


 


Journal Entries in T-Account View in 2024


 

Finally, if you need to carry forward summarized documents that were transferred from PSCD to Funds Management for an FM area and a fiscal year to the next fiscal year, please refer to the program documentation of report RFKKFMCK_NEW.

And this concludes the series of blog posts. All comments/corrections are welcome.