web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Little variance occurs...
Microsoft Dynamics AX (Archived)

Little variance occurs after posting PO Invoice

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

After posting invoice, find a little variance in journal.

The  amount calculated are different by posting type (Purchase expenditure for product and Vendor balance).

e.g.

We have 2 item in po line.

1.  ItemA ( Qty = 1, Net amount = 29355(JPY) )

2.  ItemB ( Qty = 1, Net amount = 45030(JPY) )

Rate (Strat from JPY to HKD) : 0.070302

In case of Posting type: Purchase expenditure for product, caluculated by Item net amount.

Step 1 ( ItemA )  : Round( ( 29355(JPY) * Rate : 0.070302), 2 ) = 2063.72

Step 2 ( ItemB )  : Round( ( 45030(JPY) * Rate : 0.070302 ), 2 ) = 3165.7

Step 3 (Amount) : SUM( Step1: Step2 )

But, In case of Posting type: Vendor balance, caluculated with exchang rate after summering ItemA & Item B amount.

Step 1 : SUM(  29355(JPY) +45030(JPY)  ) = 74385

Step 2 : Step 1 * Rate : 0.070302 = 5229.4143

Step 3 : Roud( Step2, ) = 5229.41

Like that, the amount result is different by posting type, does anyone know that is needed Hotfix to solve that? OR That is AX specification?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I forgot to mention Step 3 (Amount) : SUM( Step1: Step2 ) result, the result is ' 5229.42'

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Rina_Y,

    Can you let us know how you setup the rounding rules in GL for JPY?

    In addition, how did you setup the item Prices for your item A and item B (per single PCs./per 100s/per 1000s/etc.)?

    Dou you have any unit conversions involved in your process e.g. conversion from kg to liters?

    Finally, can you check how the rounding decimal precision for the units of your items are setup in the units setup form in the organization admin module?

    Probably a difference in the setup of those elements causes your problem.

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

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi, Ludwig

    Thank you for your reply.


    1.Can you let us know how you setup the rounding rules in GL for JPY?

    ->

    Setting is as below.

    General rounding rule : 0.01

    Sales rounding rule : 1.00                                     Rounding method : Normal

    Purchase rounding rule : 0.00                               Rounding method : Normal

    Prices rounding rule : 0.0100                                Rounding method : Normal

    Fixed asset depreciation rounding rule : 0.01       Rounding method : Normal

    2. In addition, how did you setup the item Prices for your item A and item B (per single PCs./per 100s/per 1000s/etc.)?

    ->

    Use Trade agreements for setting prices,  and item price per single.

    3. Dou you have any unit conversions involved in your process e.g. conversion from kg to liters?

    ->

    The items don't have conversion setting.


    4. Finally, can you check how the rounding decimal precision for the units of your items are setup in the units setup form in the organization admin module?

    ->

    Unit: PC

    Rounding precision : 0

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Rina_Y,

    If you set the purchase rounding rule (No. 1) from 0.00 to 0.01

    It might fix you issue.

    Can you test that in a demo environment?

    If this does not help, can you then - in addition - set the rounding precision (No 4) from 0 to 2 and also check whether this helps.

    Would be great if you could provide us some feedback on that.

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi, Ludwig

    Thank you for your help.

    I changed the purchase rounding rule to 0.01 and post in a test envrionment, but it doesn't work.

    I also changed the rounding precision to 2, but it doesn't work neither.

    Do you have more idea?

    Regards,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Rina_Y,

    Puh, this might be tricky. Can you try resetting all rounding rules back to 0. So,

    General rounding rule : 0.00

    Prices rounding rule : 0.0000      

    I believe by playing around & testing with those settings you should be able to get the same amounts. However, I cannot tell you exactly how to setup those rules - that's something you need to test.

    Would be great if you could keep us updated.

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi, Ludwig

    I reset rounding rule back to 0, but it doesn't work...

    I'll try various setting.

    If you have advice, please kindly share with me, it would be really helpful for me.

    Regards,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Rina_Y,

    I double checked the Hotfixes on LCS and believe that this might be because of a System bug. Can you check the following ID on LCS?

    Solution 3691779Rounding issue on purchase product receipt

    fix.lcs.dynamics.com/.../Solution;qc=c5c697a78563ba5e1e60ad688f61145bd1118e5962bb73f575b8db11c9ddde3a

    There is an additional still open incident that you might be interested in

    Issue 3760904Accruals account does not balance becuase of rounding issue

    fix.lcs.dynamics.com/.../NotFixed;qc=c5c697a78563ba5e1e60ad688f61145bd1118e5962bb73f575b8db11c9ddde3a

    If those fixes do not help than you might need the help of a developer who takes a look into the rounding issue.

    Hope this helps,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi, Ludwig

    Thank you for your informaion.

    I read both of pages.

    First URL, this is the case of the penny difference between Vendor transaction and inventory transactions.  Is that  the same as mine? Sorry for my elementary question.

    If so, it is caused by ax bug and cannot avoid this situation?

    Regards,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Rina_Y,

    The best thing to do in my opinion is to get into contact with a developer who can analyze best if the hotfix fixes the problem that you describe here. There are many things that need to be considered there (your System Version, modifications made, etc.) and I believe a developer who knows your Company's System is the best and first Person to contact.

    Hope this helps,

    Ludwig

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans