1. Customer / vendor reconciliation accounts are NOT maintained in 3KEH

2. Before and after you run F.5d, go to display of an FI document (with a customer / vendor line item) and choose the option `Balance sheet adjustment' in the menu Environment to see the effect. You would also see the effect of this in the reports S_ALR_87013343 & S_ALR_87013344. Check the table BFOD_Aand BFOK_A - before and after running F.5D

Hope this helps. Please share your feedback in this forum

KM

Thanks, KM.

Anonymous wrote:1. Customer / vendor reconciliation accounts are NOT maintained in 3KEH

What do you mean with this? Should they be excluded?

Anonymous wrote:2. Before and after you run F.5d, go to display of an FI document (with a customer / vendor line item) and choose the option `Balance sheet adjustment' in the menu Environment to see the effect. You would also see the effect of this in the reports S_ALR_87013343 & S_ALR_87013344. Check the table BFOD_Aand BFOK_A - before and after running F.5D

Currently we have all BS accounts in 3keh with one Profit Centre assigned.

This has the following effect when posting FI documents:

Document is created with all items having Profit Centre attached. The Profit Centre document displays this also.

Before executing F.5d there is no entry in tables BFOD_A / BFOK_A. The report does not show the values.

After executing F.5d the entry is in the table, with the PC defined in 3keh. Also BS adjustments are now available, made to the pre-defined PC.
The report has now the values for the Reconciliation account.

Starting 1kek does not change things.


With this result the only real effect is values showing in report.

Any thoughts on this, KM?

Thanks,
Norm

Yes, the customer and vendor reconciliation accounts should not be entered in 3KEH table with a default profit center. There should not be any mention of the reconciliation accounts in the 3KEH/3KEI tables

The logic is that, the profit center for the customer / vendor line item is being derived, on pro-rata basis, from the offsetting GL line items. This determination of profit center is achieved by NOT maintaining the reconciliation account in 3KEH AND by running F.5D

For example, if you have an FI entry as follows

Labour charges a/c Dr 100 - Profit center 1000
Miscellaneous a/c Dr 300 - Profit center 2000
Vendor a/c Cr 400 - Profit center is NOT determined yet.

The profit center field will appear as blank.

When you run F.5D, the profit center for the vendor line item is determined from the offsetting line items (in this case line item 1 & 2). hence the vendor line item amount of 400 is proportionately split up into

Vendor a/c Cr 100 - Profit center 1000
Vendor a/c Cr 300 - Profit center 2000

The above illustrated result is possible if you do not maintain the reconciliation account in the 3KEH table.

Please note that if you had mentioned the reconciliation account of the vendor in the 3KEH table with the default profit center as say 2000, then during the FI entry itself the profit center for the vendor line item would have been determined as 2000.

Hope this clarifies

KM