Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

Posted on by 35

HI All, 

i having a problem which is PO( Purchase Order) amount dont have decimal place. in PO should be 60.60 but only this line show 60600.00

currency is using USD. 

pastedimage1615789599433v2.png

and i try checking where is the problem causes this amount appear in PO as below, but i unable to find where to key in this discounted price.

pastedimage1615789500374v1.png

Anyone can help to explain this? 

Categories:
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

    Hi AXuseraqua,

    Have you checked all related settings for this vendor and your item?

    Trade agreements, auto-charges and alike?

    In addition, if you create a new purchase order for the same item, vendor, qty, etc. do you see the same outcome?

    Best regards,

    Ludwig

  • RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

    any price agreement linked to the PO line? 

  • ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

    It seems you have% 99,9 discount (any customization?)

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

    If unit price is 300, the price is calculated per item and you have 202 items, the total price is 202 ×  300 = 60600. That answers your question " why become 60600 not 60.60?".

    If unit price is 1390 and quantity 410, the reason why you get 569.9 instead of 569900 is likely in the fact that the price is configured to apply to 1000 items and not a single item.

  • chiewyin Profile Picture
    chiewyin 35 on at
    RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

    hi,

    yes i agree, and i know this , that the problem i trying to find out why become 60600 did u get what i meaning?

    u can see line 1 410 x 1390= 569900 why system can show 569.9 ?

    line 2 217 x 1850 =401450 why system can show 401.45

    line 3 2010 x 24 =48240 why system can show 48.24

    line 4 1566 x 455=712.53 why  system can show 715.53 ?

    line 5 208 x 517 =107536 why system can show 107.54?

    line 6 202 x 300 =60600 why system can show 60600 not 60.6 ?   i want to find this why become 60600 not 60.60?

    pastedimage1615794560661v1.png and i found this but not sure how to edit this. 

    .line 7 212 x 608=128896 why system can show 128.90?

    i need make sure my PO is showing the correct amount.

  • Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

    Do you agree or not that 202 ×  300 = 60600?

    If you do, why do you expect another number? For example, have you set up a price agreement with Price unit = 1000?

    That you get different results for different lines might mean that you have different price configurations.

  • chiewyin Profile Picture
    chiewyin 35 on at
    RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

    Hi,

    but other item ( as picture i screenshot ) also same auto calculate with decimal place in system, which is should be 0.300 only this item code having a problem,

    i checked TA no problem,

    Purchase Requisition was raised is 60.6. Convert to Po the price become 60600

    below i screenshot total 62588.56 but final is 2049.16 only. 

    569.9 + 401.45 + 48.24 + 712.53 + 107.54 + 60600.00( this should be 60.60 only the total become 2049.16) + 128.90 + 20 ( addon)  =2049.16

    pastedimage1615791237004v1.png

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

    I think that the system is right: 202 ×  300 is 60600, not 60.6. Maybe you're confusing the comma separating thousands with the decimal comma.

    By the way, could you please using all caps in your thread titles? Thank you.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans