incoming Payments posting to bal. sheet adjustment account

[Former Member]

hi Sap consultants,

I have a situation where one company is in china and the other in Europe.

when posting incoming Payments to the european com in a foreign currency the system posts

Debit to Bank account,

credit customer Payment,

Credit exchange rate Realised gain account

when posting in the company in china

system posts

Debit to Bank account,

credit: customer Payment,

credit: exchange rate Realised gain account

credit: Bal. shhet adjustment ac.

Ive checked the Settings in customizing and the reconciliation account for both companies are same

Chart of Accounts 1000

G/L Account 1150000

Currency -

Currency type -

Ex rate diff Real

Loss 7201009

Gain 7200009

Valuation

Val.loss 1 7201000

Val.gain 1 7200000

Bal.sheet adj.1 1150900

The Acounts are all set up the same, the invoices are in foreign currency and I cant find the setting where it post this extra line item in the company in china and not in Europe.

Does someone know why this takes place.

Thanks

Dave

[dominic_holdstock · Accepted solution]

Hi,

The difference is probably that China has carried out a FX Balance sheet valuation for that item while Europe has not(or has but there was no difference).

You can verify this by checking in FBLxN if the value in the fields "Amount in Local cur." and "Valuated amount" are different.

Kind regards

[Former Member · Accepted solution]

Hi dominic,

Thanks this was the problem but the how do I avoid this in the future.

we post Intercompany invoice before the end of the Month and then at month end these open items are valuated. So once ive valuated these items and then apply payments to these invoices I have this problem. Is there a way around this. Or how do u do this in your company.

thanks

Dave

[Former Member · Accepted solution]

HI,

During valuation differnces is posted to FX. This entry is reversed in subsequent month.

These is reversed when you carry out actual clearing. That what where ur entry are standing. This is automatically carried out by the system.

I hope that during valuation (f.05), option for actual posting is selected and as such theseentry is generated.

The solution to this is reverse the valauation run.

Also, please check setting for Valuation and revaluation.I don't have much exposure to it but yes some experts can express their experience,if any

Regards,

Atul

[Former Member · Accepted solution]

hi

Please check setting of folowing

1) Tcode OB29 for EVR.

2) OBA1.

3) Also if possible the output of valuation run that was carried out in the last month and verify the entries generated by system. if possible identify the openitem that you are clearing now and the effect of it during valuation

Regards,

Atul

[Former Member · Accepted solution]

hi atul,

the valuation entry is posted and the Reverse entry carried out in the following month. But when there are valuation differences like dominic mentioned I have this problem where the Payments also get generate this line on the Bal sheet adjustment Ac. The Balance sheet adjustment account should not have a balance generally.

how is this in your system.

dave

[Former Member]

Hi,

Please check in transaction code OBXM (Define accounts for subsequent adjustment) - whether any accounts are maintained for transaction GA4 (Adj. accounts for exchange rate diff accts).

Thanks

Murali.

[Former Member]

hi Murali,

no there are no entries here as well.

thanks

Dave

[Former Member]

Hi,

Please see any adjustment account specified in FBKP under the group GAU(Finan Stmnt adjmnt)

Regards,

Atul

[Former Member]

Hi Atul,

no luck here as well.

thanks

Dave

[Former Member]

Hello Dave,

In transaction OBY6, do you have exactly the same flag on "No ex. rate difference when clearing in local crcy", for the China company and the European one.

Regards

Valerie

[Former Member]

Hi Valerie.

No that was one of the settings i had checked as well before. Unfortunately both companies have the Flag set.

Thanks

Dave

[Former Member]

Dave,

Do you have a hard currency set on the country China (transaction OY01)?

Valérie

[Former Member]

sorry no luck here as well

Thanks

dave

[Former Member]

thanks for all your replies

[Former Member]

waiting on last reply