Ansicht
Dokumentation
SAPF101 - Balance Sheet Supplement - OI - Analysis per &
General Data in Customer Master CL_GUI_FRONTEND_SERVICES - Frontend ServicesThis documentation is copyright by SAP AG.
Description
This program groups the receivables and payables according to a required list (for example, "EU Guideline 4") and performs transfer postings.
Additional adjustment postings are required in the following cases:
- Vendors with a debit balance and customers with a credit balance
- Changed reconciliation accounts or partners (VBUND)
- Investment reporting
All accounts managed on an open item basis are processed.
Sorted List of Items
The decision regarding whether an account is sorted on the basis of receivables or payables depends
on the balance sheet value of the account. This is the balance of the account for each reconciliation
account and remaining term. If multiple accounts are linked through the same partner company, the common
balance sheet value of the resulting account group determines the type of sorted list. If the balance
is positive, the sort for receivables is used, otherwise the sort for payables. You define the sort methods in Customizing.
Alternatively, you can combine multiple accounts into groups so that the system uses their common balance
for the sorted list. The group used for customers and vendors is the corporate group. For the G/L accounts, there is a separate field in the G/L account master.
In the case of credit memos that refer to an invoice, the due dates are read from that invoice.
Vendors with a debit balance and customers with a credit balance are determined separately for each point in the list because only items with approximately the same remaining term can be added together.
The sum of the document balances appears on the current reconciliation account of the customer or vendor
master. If a change is made, the amounts are transferred from the old reconciliation account to the new reconciliation account.
Investments
In some countries (such as France), investments need to be reported separately. You can select this additional reporting using parameters. The investments are then reported for each reconciliation account as a total and transferred.
Postings
For each generated transfer posting, a cancellation posting is transferred to the session. With reconciliation accounts in the vendor or customer area, an adjustment account is posted.
When a target company code is used, all items are grouped under the target company code and then processed. However, the company codes selected must be managed in the same currency (for example, local currency or group currency).
If a different valuation area is used, account determination for the transfer posting is performed from
within the selected valuation area. Processing uses the currency of the valuation area assigned (for example, US GAAP in group currency USD).
Requirements
If sorting takes into account foreign currency adjustments, you must first perform foreign currency valuation with program SAPF100. The "Bal.Sheet Preparation Valuatn" checkbox must be selected.
To generate a sorted list of open items, you need to use a sort method. Specify a sort method.
For program SAPF101 to be able to make the adjustment postings required, you have to define the adjustment accounts and the accounts for displaying the receivables and payables according to remaining life, as well as the customers with credit balances and the vendors with debit balances in the system.
Where reconciliation accounts have been changed, check the accounts for the transfer posting.
If you want to display and post investments separately, you also have to define appropriate accounts for this.
The posting keys required are already delivered in the standard system.
Output
The main list shows the items that have been read and sorted.
The posting list shows the postings transferred to the batch input session.
The message list shows you the errors and other events.
To accelerate the program, you can save the lists to the database and display them separately. To do this, use the program Display Logs (FAGL_PROT). On the selection screen, enter the program name SAPF101.
BAL_S_LOG - Application Log: Log header data Addresses (Business Address Services)
This documentation is copyright by SAP AG.
Length: 4815 Date: 20240520 Time: 065150 sap01-206 ( 87 ms )
