Skip to Content

F101 - Sort Order

The report displayed by this Transaction displays Documents from GL, AR and AP. The document display seem to be in no particlar order. May be it showing the AP documents grouped by the Cost Centre? But then what logic for the GL Documents? The dates are definitely not in sequence, nor the document numbers. If anyone has wondered about this or has wondered and found a Solution please do respond

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 18, 2010 at 07:00 AM

    Hello

    Please find the documentation for this Tcode below:

    The sort processes are mentioned in this document. Go through them to establish a relationship.

    Short text

    Balance Sheet Supplement - OI - Analysis per &

    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.

    Output

    The items that have been read and sorted are displayed in the main list.

    The posting list displays the postings that have been entered in the batch input session.

    The notification lists informs you of errors and other incidents.

    Rgds

    Add comment
    10|10000 characters needed characters exceeded