Programme SAP FAGL_CL_REGROUP - Balance Sheet Supplement - OI - Analysis

Description
This report structures the payables and receivables into a sorted list(such as the 4th EU Directive) and executes 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 are processed that are carried with open item management.
    Sorted List of Items
    The decision on whether to sort an account based on receivables orpayables depends on the balance sheet value of the account. This is thebalance on the account for each reconciliation account and remainingterm. If multiple accounts are linked through the same partner company,the common balance sheet value of the account group determines the typeof sorted list. If the balance is positive, the sort for receivables isused, otherwise the sort for payables. You define the sort methods inCustomizing. You can also create groups of accounts whose common balanceis used for the sorted list. The group used for customers and vendors isthe corporate group. For the G/L accounts, there is a separate field inthe G/L account master.
    With credit memos that refer to an invoice, the due dates are read fromthat invoice.
    Vendors with a debit balance and customer with a credit balance aredetermined separately for each point in the list because only items withapproximately the same remaining term can be added together.
    The documents are summed under the current reconciliation account of thecustomer or vendor master. If a change is made, the amounts aretransferred from the old reconciliation account to the newreconciliation account.
    Investments
    In some countries (such as France), the investments must be reportedseparately. You can select this addtional reporting by means ofparameters. The investments are then reported for each reconciliationaccount as a total and transferred.
    Postings
    For each generated transfer posting, a cancelation posting istransferred to the session. With reconciliation accounts in the vendoror customer area, an adjustment account is posted.
    When a target company code is used, all items are grouped under thetarget company code and then processed. The selected company codes,however, must have the same currency (such as local currency or groupcurrency).
    If a different valuation area is used, account determination for thetransfer posting is run from within the selected valuation area.Processing is in the currency of the assigned valuation area (such as USGAAP in group currency USD).

    Precondition
    If you want to generate the sorted list taking foreign currencyadjustments into account, you must first execute foreign currencyvaluation with report FAGL_FC_VALUATION.
    To generate a sorted list of open items, you need a sort method. Edit amethod:
    IF &DEVICE& = 'SCREEN'
    Execute function
    ENDIF
    For the report FAGL_CL_REGROUP to make the desired adjustment postings,you must specify the adjustment accounts and the accounts for reportingthe receivables and payables by remaining term and the customers with acredit balance or vendors with a debit balance:
    IF &DEVICE& = 'SCREEN'
    Execute function
    ENDIF
    Check the accounts for the transfer posting with changed reconciliationaccounts:
    IF &DEVICE& = 'SCREEN'
    Execute function
    ENDIF
    If investments are reported and posted separately, you must alsodetermine the accounts for that:
    IF &DEVICE& = 'SCREEN'
    Execute function
    ENDIF
    The necessary posting keys are provided in the standard system.

    Output
    The main list shows the items read and sorted.
    The posting list shows the postings transferred to the batch inputsession.
    The message list shows you the errors and other events.

740109FAGLF101: Ledger grp missing/Posting with document splitting