F.5D - Calculate Balance Sheet Adjustment

[former_member206364]

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

[iklovski]

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

[Former Member]

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	Accounting ® Financial Accounting ® General Ledger ® Periodic Processing ® Closing ® Regroup ® Balance Sheet Adjustment ® Calculate
Transaction code	F.5D 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	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

[former_member206364]

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