Ansicht
Dokumentation
SAPF101A - Balance Sheet Supplement - OI - Analysis by ........ (Old)
ROGBILLS - Synchronize billing plans ABAP Short ReferenceThis documentation is copyright by SAP AG.
Description
This program displays receivables and payables in the following order in accordance with EU guideline 4.:
- Receivables with a remaining term of
- up to one year
- more than one year
- Payables with a remaining term of
- up to one year
- more than one and less than five years
- more than five years
To display the receivables and payables according to remaining term in the financial statements, the program carries out transfer postings and adjustment postings for clearing the document.
Additional adjustment postings are necessary in the following cases:
- Vendors with debit balances and customers with credit balances
- Changed reconciliation account or partner (affiliate)
- Investment display
All accounts that are managed on an open item basis are processed.
The adjustment postings are carried out per partner indicator, G/L account, business area, and currency. The postings are reversed at the reverse posting date.
Changed reconciliation account or partner
If the reconciliation account, special G/L account, or partner indicator has been changed for a customer
or vendor, the program recognises this and carries out the corresponding transfer posting. The items
from the old reconciliation account are assigned to the new reconciliation account. Since the reconciliation
accounts cannot be posted to directly, the postings required are made to adjustment accounts. If the
reconciliation account was changed during posting, (asset management), the posting is displayed under the new reconciliation account.
If the partner is changed for a G/L account, the items are transferred from the old partner indicator to the new partner indicator.
Note
Correct display of receivables and payables for consolidation is not guaranteed in the following case:
A customer or vendor was purchased. The receivables and/or payables were taken over. In this case, the display in the consolidation is incorrect, since the since the company ID is not contained in the trading partner open items that were posted. Proceed as follows to correct the error:
- Create a new master record for the customer or vendor. Enter the company ID in the master record.
- Post the receivables and payables to the new trading partner using transfer postings. The general ledger is posted to automatically in the consolidation.
If the receivables or payables of the company acquired were not taken over, they remain in the customer or vendor (company in liquidation). In this case, all you have to do is create a new master record for the trading partner.
Sorting of open items
Whether or not an account is sorted according to receivables or payables depends on the financial statement
value of the account. This is the balance of the account per reconciliation account and remaining term.
If there are several accounts for a trading partner, the joint financial statement value of the account
group determines the type of sorting. If the balance is positive, sorting is done according to receivables, otherwise sorting is done according to payables.
Alternatively, several accounts can be grouped and the joint balance used for sorting. The corporate
group term is used as a group term for the customers and vendors, for G/L accounts, there is a separate field in the account master. If the group term is not blank, the balance is calculated according to this term.
The result of the sorting is output in a list, displayed separately by account types - customer, vendor, and G/L accounts. The list shows the adjustment postings required.
- Customer
- The receivables sorted list contains all customers whose financial statement value is positive. The values from the column "Rem. term > 1 year" are transferred to an account for receivables with a remaining term of more than one year.
- The payables sorted list contains all customers whose financial statement value is negative. These values are displayed as payables in the financial statements. The values are therefore transferred to accounts that display payables according to their remaining term.
- Vendor
- The payables sorted list contains all vendors whose financial statement value is negative. The values from the columns "Rem. term <= 5 years" and "Rem. term > 5 years" should be transferred.
- The receivables list contains all vendors whose financial statement value is positive. These values are displayed as receivables. Therefore, all values from the columns "Rem.term <= 1 year" and "Rem. term > 1 year" should be transferred to the corresponding receivables accounts.
- G/L account
- The receivables sorted list contains all G/L accounts whose financial statement value is positive. These values are to be displayed as receivables and therefore the values from the column "Rem.term > 1 year" should be transferred.
- The payables sorted list contains all G/L accounts whose financial statement value is negative. Transfer the values from the columns "Rem.term <= 5 years" and "Rem.term > 5 years".
The balances of the receivables and payables accounts are corrected by transfer postings to adjustment accounts. You display the receivables and payables accounts with the corresponding adjustment accounts in the financial statements.
In some countries (for example, France), investments must be displayed separately. You can do this by selecting a specific parameter. The investments are then displayed in total per reconciliation account. The amounts are also transferred. Adjustment and target accounts are used for this in accordance with Customizing. If however, part of the investment was transferred as a customer with a credit balance or a vendor with a debit balance, this amount is transferred out of these target accounts.
For G/L accounts, the adjustment posting is made directly to the G/L account. You should therefore define the number of the account deemed to be the adjustment account in the system.
For credit memos with invoice reference, the due dates are read from the invoice.
If you use a target company code, all items in the target company code are summarized and then processed. The company codes selected must however, be managed in the same currency (for example, local currency, group currency).
If you use an alternative valuation area, account determination for the transfer posting is carried
out from the valuation area selected. The processing is carried out in the currency of the valuation area assigned (for example, US-GAAP in group currency USD).
Requirements
If sorting should be done taking foreign currency adjustments into account, you have to carry out the
foreign currency valuation with program SAPF100 first. When you run the program, select the field "Valuation for FS preparations".
So that program SAPF101 can carry out the adjustment postings required, you have to define the numbers of the adjustment accounts and the accounts for displaying receivables and payables according to remaining term in the system.
If reconciliation accounts have been changed, check the accounts for the transfer posting.
Check the entries for the transfer posting of vendors with debit balances and customers with credit balances.
If investments should be displayed and posted separately, you should also define the accounts to be used for this.
The posting keys required are already defined in the standard system.
Output
The program lists the sorting carried out for each account. You can select the degree of detail for the list.
The list always shows the following data per business area and currency:
- Total of foreign currency amounts posted
- Total of local currency amounts posted
- Total financial statement value of line items
- Sorting according to due date
If you require a list of line items, they are displayed per account with the following details:
- Business area
- Special G/L indicator
- Currency key
- Due date
- Remaining term in days, if positive
- Posting date
- Document number, line item
- Foreign currency amount posted
- Valuated local currency amount (book value plus valuation difference)
- Book value
- Valuation difference (calculated by SAPF100)
If you require a microfiche line, the following is printed in the variable part:
| Field content | Output length | |
|---|---|---|
| Company code | 4 places | |
| Trading partner | 6 places | |
| Account type | 1 place | |
| G/L account | 10 places | |
| Account number | 10 places | |
| Business area | 4 places |
If the program cannot carry out postings because the information required, for example, account numbers or posting keys, is not defined in the system, it displays them in an error log at the end of the list.
ROGBILLS - Synchronize billing plans Addresses (Business Address Services)
This documentation is copyright by SAP AG.
Length: 11492 Date: 20240520 Time: 091647 sap01-206 ( 167 ms )
