Fixed asset Journal data entity does not work properly

(0) Share

Report

Posted on by Nataliia Samoilenko

Hi all,

Would you help me with such issue?

I created FA, and now I am loading the balance cost of Fixed Assets.

When i try to load such file with FA transaction of Acquisition and depreciation via the Fixed asset Journal Data entity, it is loaded successfully.

But when i try to post it , i have got error message for the line with Acquisition type.

Error message is "The accounting currency USD and reporting currency USD are the same, however the rates are different. The rates must match."

When i create manually the same lines in other journal and try to post them, everything is posted.

But i can not find any difference in the fields values between these two journals.

When i open this journal( loaded previously via data entity) in excel and update it in excel and publish, I can post it successfully.

When i view ledger journal trans for these lines, i notice that error lines have empty value in ReportingCurrencyExcRate. But there is no such field in data entity.

Can you advice me what i should do?

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Nataliia,

There is also "Fixed asset journal V2 entity" entity and this field should be available there.

Was this reply helpful? Yes No
Nataliia Samoilenko 7 on at

Like (0)

Report

Hi Sergei,

thanks for your answer,

but i have used exactly this data entity Fixed asset journal V2 entity.

but there is not such field there .there are only fields that you can see at excel screenshot.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Can you test whether separating the acquisition posting and the depreciation posting in separate journals helps?

That is, upload and post the acquisition first and then the depreciation.

Would be great if you could quickly test and let us know the outcome.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Nataliia,

Try to re-generate mapping for this entity and re-add it to the data project

To regenerate mapping you need to go to Data management workspace -> Data entities tile -> Find entity -> press "Modifiy target mapping" -> Generate mapping.

After you re-add entity to data project you should be able to export\import this field (screenshot is from PU32)

Was this reply helpful? Yes No
Nataliia Samoilenko 7 on at

Like (0)

Report

Hi Ludwig,

thanks for answer.

i can load and post line with depreciation.

i can load but can not post line with acquisition,

Error appears "Posting results for journal batch number 00770 The accounting currency USD and reporting currency USD are the same, however the rates are different. The rates must match. "

Was this reply helpful? Yes No
Nataliia Samoilenko 7 on at

Like (0)

Report

Hi Sergei

thanks for your answer.

i have 2019 release wave 2 Installed product version : Finance and Operations (10.0.6)Installed platform version : Update30 (7.0.5407.35455)

i have such settings in my project

I tried to re-generate mapping for this entity (Data management workspace -> Data entities tile -> Find entity -> press "Modifiy target mapping" -> Generate mapping.)

I have such mapping after re-generatring.

there is no field ReportingCurrencyExchangeRate there

and i have such mapping in new project.

there is no field ReportingCurrencyExchangeRate there.

Any ideas?

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi,

Looks like fields were added later in PU30. I have a build 7.0.5407.41386 and there are already added. I'm not sure if you can do anything without update to next platform version or additional development.

Also, you can try to use LedgerJournalLineEntity to update existing data.

Was this reply helpful? Yes No
Nataliia Samoilenko 7 on at

Like (0)

Report

Sergei,

Thanks a lot!

i will upgrade my env today and will write you how data entity works.

Was this reply helpful? Yes No