Ansicht
Dokumentation

FIUT_180_APAR - Aux. Program "Balance Sheet Adjustment": Reconcile Vendors/Customers

CPI1466 during Backup   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Purpose

The reconciliation vendors/customers is used for error analysis and to correct the calculated breakdown of the balance sheet adjustment for vendor and customer items.

Integration

Prerequisites

You have activated Profit Center Accounting or the business area balance sheet. You have executed report "Calculate Balance Sheet Adjustment" (transaction F.5d) for the company codes you want to analyze.

Features

This report checks whether the breakdown calculated (report "Calculate Balance Sheet Adjustment") matches the original items with regard to amount. This way the system identifies missing entries in the worklist (table RF048), missing calculations (tables BFO*), incorrect calculations, and archived documents.

Selection

You select a company code, fiscal year and posting period which you want to analyze. The vendors/customers selected are those that are open at the end of the posting period.

Open Items at Period End
With this selection you can limit the items to be analyzed to the items posted in the posting period (option "Items posted in period").

Additional Selection
In this area you can further restrict the selection. Bear in mind that you can only evaluate general ledger accounts that have been defined as vendor/customer reconciliation accounts.

Output Control
With the amount limit you can define how great the difference has to be before the incorrect documents are listed in the log. This has no effect on the documents to be corrected.
With the indicator "Propose business area from document" the business area from the line with the highest amount in the incorrect document is proposed.

General Control
If you set the indicator "PCA transfer logic only" then the breakdown is only checked in accordance with the transfer logic receivables and payables into Profit Center Accounting (transaction 1KEK). If you have deactivated the indicator, then the posting information in "Calculate Balance Sheet Adjustment" (Report SAPF180 / transaction F.5e) is evaluated as well.

If you execute the foreign currency valuation (program SAPF100) for balance sheet preparation, you can analyze the breakdown of the valuation using report FIUT_180_APAR. Select the indicator "Check valuation differences". To avoid differences occurring, you must execute the year-end closing programs in the correct order, namely SAPF100 -> SAPF180A -> 1KEK. Items are only evaluated that are currently open. Valuations on cleared items are not broken down in the standard system.

If you select "Test run" you can correct incorrect documents. If you do not set this indicator the incorrect documents are put in the worklist (table RF048) again. When you run report "Calculate Balance Sheet Adjustment" (transaction F.5d, report SAPF180a) these documents are corrected.
Note: If adjustment documents have been posted for the documents to be corrected, then the corresponding adjustments must be reset first (report SAPF180s, transaction F.5g).

Standard Variants

Output

A table of the missing entries is output with the following columns:

Account	Relevant reconciliation account
BA	Proposed business area
Not calculated	Total amount of the items not distributed
Not posted (open)	Total amount of non-posted distributions for open items (SAPF180)
Not posted (cleared)	Total amount of non-posted distributions for cleared items (SAPF180)

The incorrect documents are output. You navigate to the FI document by double-clicking.

Activities

Example

BAL_S_LOG - Application Log: Log header data   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 4417 Date: 20240531 Time: 190541     sap01-206 ( 76 ms )