Sorting by Remaining Term
Sorting by Remaining Term
Use
Report program SAPF101 sorts the receivables and payables according to remaining term. The remaining terms are defined in a sort method.
You can define your own sort methods.
The standard SAP system provides the remaining terms of the fourth EU directive in sort method EG93. This directive defines the following method of sorting:
Sorted list of receivables and payables according to EG93
Receivables/Payables |
Remaining Life |
Receivables |
Less than 1 year |
More than 1 year | |
Payables |
Less than 1 year |
1 – 5 years | |
More than 5 years |
Prerequisites
You must make the following Customizing settings so that the system can regroup, or sort, your receivables and payables according to their remaining term.
You have to define the account numbers in the system, since the program makes the postings automatically. The required posting keys are already defined in the system.
For the sort method EG93 that is provided in the standard system, you need an adjustment account for each receivables account, and an account for displaying receivables with a remaining term of more than one year. You also need an adjustment account for each payables account, together with separate accounts for payables with a remaining term of between one and five years, and for payables with a remaining term of more than five years.
You make the settings in Customizing under Financial Accounting → Accounts Receivable and Accounts Payable → Business Transactions → Closing → Regroup.
Features
The system sorts the open items according to account type. For each account type, the system displays the payables and receivables for the individual accounts according to the amounts in the respective reconciliation accounts.
Transfer postings
You have to make some transfer postings to be able to display the payables and receivables correctly by remaining term in the financial statements. The receivables and payables with the smallest remaining term are left in the previous reconciliation account, and the receivables and payables with a longer remaining term are transferred to separate G/L accounts.
When a transfer posting is made to a separate G/L account, the offsetting entry is made to an adjustment account for the previous receivables/payables account. The receivables/payables account is shown in the financial statements together with the adjustment account.
The receivables account contains receivables with a remaining term of more than one year in the amount of $1000. This amount is transferred to the appropriate G/L account, which displays the receivables with a remaining term of more than a year. The offsetting entry is made to an adjustment account. The adjustment account and the receivables account are displayed together under a single financial statement item. The following figure illustrates this example:
