Skip to Content
avatar image
Former Member

F.5D - Calculate Balance Sheet Adjustment

Hi Experts,

I have the following questions on 'Calculate Balance Sheet Adjustment' (tcode F.5D) procedure - which documents are included in this calculation?

Help on this transaction is saying the following:

When posting a document, the system analyzes it to determine whether a balance sheet readjustment is necessary. If a readjustment is required, the system marks the document for readjustment. Readjustments are calculated for the marked documents and stored in special tables.

How exactly are these posted documents marked? Is there any parameter? Or any configuration should be performed to include particular documents in adjustment?

Thanks in advance,

Denis

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 18, 2012 at 06:40 PM

    Hi Denis,

    Purpose:

    This document illustrates a brief example for transferring receivables and payables in Profit Center Accounting.

    Prerequisites:

    • The system is used for production (you post in SAP FI, for example), and receivables and/or payables have been posted in FI in prior periods.
    • The master data for Profit Center Accounting (profit centers, account groups, and so on) has been created.

    Note:

    Instead of executing every single step of the BPP manually, you can use the CATTs and eCATTs provided with the SAP Best Practices Baseline Package to run through the BPP. The development master list of building block J08 (section Test/Evaluation/Training) specifies which object is to be used for which step. All CATTs are to be executed using transaction SCAT. A special parameter transaction has been created to facilitate the execution of eCATTs.

    Running through the BPP using these automated objects not only saves a lot of work, but also gives rise to a closed logical data environment. It is therefore the recommended processing method.

    Transferring Balance Sheet Items

    Use:

    You can transfer balance sheet items periodically in Profit Center Accounting. This includes material stocks, work in progress, asset portfolios, and receivables and payables. While the online transfer – defining the involved accounts and a default profit center as “Additional Balance Sheet & P/L Accounts”  in Customizing – is recommended for material stocks, work in progress and asset portfolios, you have to use a specific transfer report to transfer receivables and payables.

    You have to calculate the adjustment before you carry out the actual transfer. You use transaction F.5D to do so. You can then transfer the receivables and payables to Profit Center Accounting.

    Prerequisites:

    Vendor and customer postings have been made in Financial Accounting. This is, for example, the case if you have processed one or more of the scenarios 49 to 63.

    If you have not processed or installed these scenarios, you can create such postings by processing SAP transactions FB01 and FB70. Building Block J08 provides CATTs /SMB16/FB01_C117_J08 and /SMB16/FB70_C118_J08 to automate the creation of the postings, CATT files SMB16_FB01_C117_J08.TXT and SMB16_FB70_C118_J08.TXT can serve you as templates to create your own posting data. Bear in mind, however, that it will be necessary to create at least one vendor and one customer, since these are provided neither by J08 nor by one of its prerequisites Building Blocks.


    If you choose to perform this activity using a CATT, it is recommended to execute the CATT in foreground

    Procedure:

    1. Access the Calculate Balance Sheet Adjustment transaction choosing one of the following navigation options:

    SAP R/3 menu

    1. Accounting ® Financial Accounting ® General Ledger ® Periodic Processing ® Closing ® Regroup ® Balance Sheet Adjustment ® Calculate

    Transaction code

    1. F.5D
    2. On the Calculate Balance Sheet Adjustment screen, make the following entries:

    Field name

    Description

    R/O/C

    User action and values

    Comment

    Company code from

    R

    BP01

    Company code to

    O

    R

    Execute

    1. Access the Transfer Receivables/Payables transaction choosing one of the following navigation options:

    SAP R/3 menu

    1. Accounting ® Controlling ® Profit Center Accounting ® Actual Postings ® Period-End Closing ® Transferring Payables/Receivables

    Transaction code

    1KEK

    1. On the Profit Center Accounting: Transfer Payables/Receivables screen, enter the necessary data.

    Field name

    R/O/C

    User actions and values

    Remarks

    Period

    R

    Current period

    Period to transfer

    Fiscal year

    R

    Current fiscal year

    Company codes

    R

    Select the row for CoCd BP01

    SAP Best Practices

    Test run

    O

    Not checked

    Update run

    Background processing

    O

    Not checked

    Only in the foreground for this demonstration; in the background later if necessary (data volume, runtime)

    Line items

    O

    Checked

    Line items only for this demonstration; unchecked later if necessary (data volume)

    Log type

    O

    Choose “Detail log”

    Detail log only for this demonstration; you can choose “Subtotals only” or “No log” later as necessary

    R

    Execute

    Result:

    The data transfer log appears, containing the transferred data.

    Kind regards,

    Fernando Almeida

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Fernando,

      Thanks for your reply.

      This BPP doesn't answer my question - how to determine which documents and for what reason are included in balance sheet adjustment calculation?

      Please advise

      Thank you,

      Denis

  • Oct 19, 2012 at 09:34 AM

    Hi,

    There is no customization on this. The generated documents will be stored in BFOK_A (vendors) and BFOD_A (customers) tables. Upon these entries a transfer to PCA is performed afterwards in separate trnsaction. The program regards all vendor/customer postings.

    Regards,


    Eli

    Add comment
    10|10000 characters needed characters exceeded