UNIT COST not showing on Purchase Orders

(0) Share

Report

Posted on by baxter05

We recently upgraded to GP 2013 and were hoping this issue would have resolved itself but it didn't and we don't know how to fix it.

When we were on GP v10 the UNIT COST of an item would automatically be generated on a new PO pulling in from Vendor Last Originating Invoice Cost. When we upgraded to GP2010 we noticed that the Unit Cost would not be listed and we would have to manually list it (we did confirm that POP setup had not changed.)

Now that we are on GP2013 I've been asked to fix this issue and I have not found a solution. If anyone has any thoughts on this, it would be greatly appreciated.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (1)

Mahmoud Saadi 32,738 on at

Like (0)

Report

It seems to me as an issue that has been there with you for a long time. I have never encountered such in issue in pulling out the most recent unit cost. Just a simple yet old-fashioned question, have you check the cost selection on Purchasing Setup as shown below;

In case that has already been tried out, what about the "Item Current Cost" option ? Have you encountered any issues with that ?

As you know, the item current cost is updated with every increase transaction made in your inventory control, supposing you have an item with perpetual valuation method.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
baxter05 on at

Like (0)

Report

Mahmoud,

Yes, we checked the cost selection on Purchasing setup immediately and it was marked for VENDOR LAST ORIGINATING INVOICE COST.

Changing it to ITEM CURRENT COST did not display any cost either.

However, I do notice that when we enter the item number into the PO, the unit cost will flash quickly and then "disappear" and only show $0.00.

pam

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

I am not quite optimistic about this case as I don't believe at all that this is a normal system behavior. Unfortunately, I don't believe as well that a quick fix could be applied to solve this out without digging deep enough in your data to discover the hidden patterns causing the unit cost not to be populated according to the system setup.

I would start with SQL profiler on the purchase order entry window to find out what's happening and why a zero unit cost is returned.

Have you been able to find out any related issue to this case, would it for the sa and DYNSA users as well.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
baxter05 on at

Like (0)

Report

Mahmoud,

Thank you for your feedback. This issue happens whether the user is logged in as SA or DYNSA user....

I will have to see what I can come up with via SQL profiler - I'm not that into SQL but will try my best.

Was this reply helpful? Yes No
Verified answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Pam, do you have any 3rd party apps or customizations in your system that may be overriding standard behavior?

Was this reply helpful? Yes No
baxter05 on at

Like (0)

Report

Frank,

no 3rd party apps unless you consider Collections Main and SmartList Builder 3rd party apps now. Also, no customizations that I am aware of.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Okay, try this - check to see if POP Cost Defaulter is enabled in Professional Services Tools Library. If it is, disable it by unchecking the second check box. I just remembered seeing this happen at a client earlier this year, with the same results you're seeing.

Was this reply helpful? Yes No
baxter05 on at

Like (0)

Report

Frank,

You are correct - the POP Cost Defaulter is enabled. I will need to be logged in as SA to make the change and allow the system to rebuild the GL table referenced. It will be tonight before I can log in as SA and make this happen. I will keep you posted. Thank you for the suggestion. From what I've read about this POP Cost Defaulter, I think you may be right.

Was this reply helpful? Yes No
baxter05 on at

Like (0)

Report

Frank

thank you for pointing me in the right direction. Unchecking the POP Cost Defaulter was the solution. The unit cost now shows on the PO entry.

Happy New Year!

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Yay!!

Was this reply helpful? Yes No