cancel
Showing results for 
Search instead for 
Did you mean: 

incoming Payments posting to bal. sheet adjustment account

Former Member
496

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

Accepted Solutions (1)

Accepted Solutions (1)

dominic_holdstock
Active Contributor

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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

Answers (3)

Answers (3)

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
0 Kudos

hi Murali,

no there are no entries here as well.

thanks

Dave

Former Member
0 Kudos

Hi,

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

Regards,

Atul

Former Member
0 Kudos

Hi Atul,

no luck here as well.

thanks

Dave

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

Dave,

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

Valérie

Former Member
0 Kudos

sorry no luck here as well

Thanks

dave

Former Member
0 Kudos

thanks for all your replies

Former Member
0 Kudos

waiting on last reply