Posting error - Penny rounding threshold

(0) Share

Report

Posted on by Lakshmi Karambakkam

1,307

Hi,

I am migrating open AR using Opening balance entity (DMFLedgerJournalEntity). The debit/credit amounts in data file are of 2 decimals.

but when the staging data is viewed

Also posting is throwing an error.

Which currency setting is causing penny round threshold?

Thanks,

Lakshmi

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (2)

Verified answer

Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

I have overwritten the value. we import excel data into sql table and migrate data through ODBC. In the process of importing excel data into sql table, credit and debit amount data types are changed from float to money. So now these values have only 2 decimals and it worked. Thanks for the helping in figuring out the problem Ludwig.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

Overwrite the number in the excel file with 899.70 and try the import again.

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

could you please explain me what is meant by "hard"? what needs to be done?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

Hello Lakshmi,

Can you overwrite the number and enter 899.70 'hard'

Then try to upload the file again.

Best regards,

Ludwig

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

Hi Ludwig,

Here is the snapshot of excel data

Let me know if need any other info.

Thanks,

Lakshmi

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

HOpenAR_2D00_PostAndTransfer.png"/api/data/v9.1/msdyn_richtextfiles(0F967A9B-C75D-4B4D-8427-ADB5A0DC4B8B)/msdyn_imageblob/$value?size=full">/api/data/v9.1/msdyn_richtextfiles(0F967A9B-C75D-4B4D-8427-ADB5A0DC4B8B)/msdyn_imageblob/$value?size=full

When doing that, can display the data with let's say 20 decimal places in Excel?

Best regards,

Ludwig

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

Hi Ludwig,

these numbers are extracted from legacy system and as I said before they are only of 2 decimals in the data sheet. The problem is with the rounding of the transaction currency amount.

Rounding values are

I tried "Post and Transfer" option but the same error occurred and the error lines did not get transferred.

One more interesting thing which I found out was that if I key-in the same credit/debit value in the General Journal\Lines form, journal is getting posted and the rounding error is not occurring.

lakshmi

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

Hello Lakshmi,

How does the file look like that you use for uploading the data?

All the error messages indicate that the 13th decimal place contains a number other than 0.

Are the number extracted from a different legacy system or somehow calculated?

What you can test is whether overwriting those figures and ensuring that not more than 2 decimal places exist fixes the issue.

Alternatively, have a look at the currency in which those amounts are uploaded and change the rounding precision for this currency.

Best regards,

Ludwig

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

Hi Ludwig,

The GL parameters are properly set. I tried post and transfer option. its throwing the same error and is also not transferring the error lines to a new journal.

Are there any pre-requisites to set before running Post and Transfer option or is there any solution to fix this?

Thanks,

Lakshmi

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Posting error - Penny rounding threshold

Hello Lakshmi,

In the GL parameters we have the rounding variance setup that allows you specifying penny differences.

Before doing that can you try to post your journal with the "post and transfer option".

There should only be 2 transactions left and the newly created journal lines should automatically get rounded by Dynamics once created, which means that you should be able to post also the second journal without error.

Best regards,

Ludwig

Was this reply helpful? Yes No