Finance | Project Operations, Human Resources, ...

PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

(0) Share

Report

Posted on by chiewyin

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.

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.

Anyone can help to explain this?

I have the same question (0)

All responses (8)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
jannawangD365 on at

Like (0)

Report

RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

any price agreement linked to the PO line?

Was this reply helpful? Yes No
ergun sahin 8,822 Moderator on at

Like (0)

Report

RE: PURCHASE ORDER NET AMOUNT SHOWING INCORRECT AMOUNT

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

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 236,172 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
chiewyin 35 on at

Like (0)

Report

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?

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.

Was this reply helpful? Yes No
Martin Dráb 236,172 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
chiewyin 35 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 236,172 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No