Small and medium business | Business Central, N...

Goods Received Not Invoiced Post

(0) Share

Report

Posted on by Jake2023

Hi,

We have a multicurrency set up purchasing stock in USD and our base currency being GBP.

On the Purchase Order list page the Amounts Received not Invoiced (LCY) value does not equal the Goods Received Not Invoiced GNRI GL Account. We have checked and experimented with General Ledger Setup Amount Decimal places (LCY) settings and Currencies Amount Decimal places but have not been able to resolve the issue. It would appear the calculation on the GL/Value Entries compared to the Purchase Order Outstanding Amount (LCY) is inconsistent:

Rounding issue? Values entries uses 2 decimal places. PO Calculates Outstanding Amount (LCY) using more than 2 decimal places USD Unit cost / Exch Rate * Qty - $10.75 / 1.2 = 8.958333 despite our system being set to 2:2

Amount Rounding Precision (LCY = 0.01

Amount Decimal Places (LCY) = 2:2

Unit-Amount Rounding Precision (LCY) = 0.01

Unit-Amount Decimal Places (LCY) = 2:2

All responses (3)

Answers (0)

Suggested answer

Manish Prasad 315 on at

Like (0)

Report

RE: Goods Received Not Invoiced Post

Try this, It may help you.

If my answer helped you, maybe it can help others. Please verify it, so other users know it worked or helped you.
Thank you.
Jake2023 49 on at

Like (0)

Report

RE: Goods Received Not Invoiced Post

Does this need to be set only on the General Ledger Setup: Unit-Amount Rounding Precision (LCY) or also on Currencies Unit-Amount Rounding Precision?
Manthan Thesiya 59 on at

Like (0)

Report

RE: Goods Received Not Invoiced Post

Hello Jack,

Enter Exchange Rate value which 6 digit after point which is maximum decimal value you can set in exchange rate and also it will give you accurate Rate In LCY .

>> For Example try = $ 10.75/1.234025 = 8.71

Don't forget to help the community by verifying the answer if your question has been answered.
It will let others know that the topic has verified answer.