Suresh
Transaction code F101.(program SAPF101)
Please read below the information for the transaction code and the process...
Description
This report groups the receivables and payables according to a required list, for example, the "EU Guideline No. 4", and carries out transfer postings.
Additional adjustment postings are necessary in the following cases:
Customers with credit balances and vendors with debit balances
Changed reconciliation accounts or partner (affiliated company)
Display of investments
All accounts that are managed on an open item basis are taken into account.
Sorting of items
The decision as to whether an account is sorted according to receivables or payables depends on the financial statement value of an account. This is the balance of the account per reconciliation account and remaining life. If several accounts are connected by the same trading partner, the joint financial statement value of the account group created determines the type of sorting. If the balance is positive, the account is sorted according to receivables, if the balance is negative, the account is sorted according to payables. You define the sort methods required in Customizing.
Alternatively, several accounts can be summarized in a group whose joint balance is used for sorting. The definition for the corporate group is used as group definition for customers and vendors. For G/L accounts, there is a separate field in the G/L account master record.
For credit memos with an invoice reference, the due dates are taken from the invoice.
Vendors with debit balances and customers with credit balances are determined separately for each point in the sorted list, since only items with virtually the same remaining life may be balanced with each other.
The documents are totaled under the current reconciliation account of the customer or vendor master record. If the reconciliation account is changed, the amounts are transferred from the old reconciliation account to the new reconciliation account.
Investments
In some countries (for example, France), investments must be displayed separately. You use parameters to select this additional display. The investments are then displayed as a total per reconciliation account and transferred.
Postings
For every transfer posting created, a reverse posting is also entered in the session. For reconciliation accounts in the customer or vendor area, postings are also made to an adjustment account.
If you use a target company code, all items are summarized under the target company code and then processed. The company codes selected must be managed in the same currency however (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. Processing is carried out in the currency of the valuation area assigned (for example, US GAAP in group currency USD).
Requirements
If sorting is to be carried out taking into account foreign currency adjustments, you must first carry out the foreign currency valuation with program SAPF100. The field "Valuation for financial statement preparation" must be selected.
You require a sort method to sort open items. Maintain a method.
In order for program SAPF101 to carry out 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 the investments are to be displayed and posted separately, you also have to define the appropriate accounts.
The posting keys required are already contained in the standard system.
Hope it was useful.
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.