Extended Cost on Purchase Order Calculating Incorrectly

(0) Share

Report

Posted on by Community Member

Hello,

I have a client who is entering a purchase order and manually typing in the inventory item. This item is NOT set up in inventory, but they are typing the item name as "MISC EXPENSE", and putting further information down in the description field. They manually enter the quantity and unit cost, but GP is not calculating the extended cost correctly.

Example: U of M is "each", Quantity Orders = 136, Unit Cost = 12.00. The extended cost on this line item should reflect 1632.00, but it is calculating 1631.93. Where is GP getting this total from??

And it seems to be random .... on this same PO, another line item was entered with 199 Quantity at 2.33 unit cost, with an extended cost of 277.27, which is CORRECT. But then the next line item is entered showing 34 quantity at 3.42 unit cost, with an extended cost of 116.18. This is incorrect and should show 116.28.

What is even more strange is if you then print the PO out, the extended cost is showing CORRECTLY on the printout, but the GP window has the incorrect extended cost.

Please advise - any help to determine what is causing this would be appreciated!

Thank you,

Linda DiGiacomo

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

MG-16101311-0 26,225 on at

Like (0)

Report

It can only mean you have other MISC EXPENSE items in inventory, even if they are non-inventoried items. Can you run a SELECT * FROM IV00102 WHERE ITEMNMBR = 'MISC EXPENSE';

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Mariano. I ran the script, and nothing was returned. There are no other items in inventory as MISC EXPENSE. This appears to be a random thing. Some PO's entered this way calculate out fine. As do some line items on an affected PO. There is no reason to it and we cannot figure out why the extended cost would not be calculating correctly: 100pcs at .50 cents does not come to 49.95?? Why would GP calculate it this way? Item is NOT in inventory.

Was this reply helpful? Yes No
KirkLivermont 5,985 on at

Like (0)

Report

I'm very surprised we are only seeing two decimal places on the unit cost. Both of these could be due to rounding.

Kirk

Was this reply helpful? Yes No
StefanieC 434 on at

Like (0)

Report

Did you ever figure this out? I came across this looking for why the PO prints a different amount than on the PO. I see that your issue included this as well.

Thank you

Was this reply helpful? Yes No