Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Goods Received Not Inv...
Small and medium business | Business Central, N...
Suggested answer

Goods Received Not Invoiced Post

(0) ShareShare
ReportReport
Posted on by Jake2023 49

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

  • Suggested answer
    Manish Prasad Profile Picture
    Manish Prasad 315 on at
    RE: Goods Received Not Invoiced Post

    Try this, It may help you.

    pastedimage1674117456349v1.png

    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 Profile Picture
    Jake2023 49 on at
    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 Profile Picture
    Manthan Thesiya 59 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans