Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
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? 

  • 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 2024 Season 1 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 230,198 Most Valuable Professional 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 230,198 Most Valuable Professional 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 230,198 Most Valuable Professional 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.

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

Product updates

Dynamics 365 release plans