Zero cost randomly on SOP invoice - why?

(0) Share

Report

Posted on by Community Member

I have a client who gets zero cost placed on certain items on SOP orders and invoices. It's odd, because it's only happened on a few documents, and I haven't been able to find a pattern.

For example, the cost was OK until 8/12 of this year, then 3 invoices were created with a zero cost, followed by 6 with the correct cost, then 2 more with zero, then 6 with the correct cost. I just entered a test invoice and it also came up with zero cost for the item in question.

They're using FIFO Perpetual, the Current Cost is showing as $10.58 on the Item card, and they have On Hand inventory quantities. The IV10200 table has about 6 layers that make up the On Hand quantity, and each layer has a cost - none are zero.

They're on GP 2010 SP3, if that matters.

*This post is locked for comments

I have the same question (0)

All responses (26)

Answers (0)

reuh3030 5 on at

Like (0)

Report

RE: Zero cost randomly on SOP invoice - why?

hello any answer with this? I have the same situation, I ran the script, and returned a record, what do I do now? regards..

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (1)

Report

RE: Zero cost randomly on SOP invoice - why?

Hi,

I've had this sort of thing come up when items were improperly imported so their beginning costs were wrong. Fortunately, you can review these transitions in your FIFO table (IV10200) to see if anything is still wondering around with a zero cost. The cost/basis of the item sold will be whatever was recorded as the current cost. I think an Excel Pivot table will give you what you need. If you are new to pivot tables I recommend you pick up a book written by Belinda Allen and Mark Polino that is on point to what you're doing, It's excellent and an easy read. What's best is that there are simple examples you can follow to get your feet wet before you dive in.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Zero cost randomly on SOP invoice - why?

Ever figure this out? I have a customer with the same issue...

Was this reply helpful? Yes No
Gerbear on at

Like (0)

Report

RE: Zero cost randomly on SOP invoice - why?

We have created custom reports with sales, cost and margin info that users run before they post. This ensures they have adequate inventory available and ensures accurrate gross profit and commission reporting.

Was this reply helpful? Yes No
GMA 1,074 on at

Like (0)

Report

RE: Zero cost randomly on SOP invoice - why?

I am running into a similar situation and was wondering what (if anything) the support request with Microsoft uncovered.

We have items that are showing up with zero cost even though the oldest (FIFO) cost layer has a cost. There are a couple of layers with zero cost, but I can't figure out why GP is pulling zero cost when the Sales Inventory item is set to FIFO Perpetual and the oldest cost layers have costs associated with them (as well as quantity remaining to be sold).

I will review the scripts that Mahmoud provided to see if they help track this down, but I am curious what GP support said, thanks.

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

Like (0)

Report

RE: Zero cost randomly on SOP invoice - why?

You are most welcome

Let me know how it goes.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Zero cost randomly on SOP invoice - why?

I agree...this isn't normal GP behavior! I'll open a service request with Microsoft. Thanks for your help trying to figure this out, Mahmoud!

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

Like (0)

Report

RE: Zero cost randomly on SOP invoice - why?

Let me provide you with my summarized and final reply which; unfortunately, won't satisfy your original concern. I can assure you that this can never be the default behavior of Dynamics GP. We are talking about a sales transactions for items (Sales Inventory type with FIFO valuation method) which have no trace in the inventory module. Since there is no records for this sales transaction in the inventory module, then the only logical explanation for me would be having an item with (non inventory type), which would justify the zero cost symptom. Although, you have confirmed that the item has an inventory type which screws this justification.

I do believe that remote troubleshooting like this would not deliver the satisfactory and logical justification or resolution you are looking for, you might need to get your partner involved on this for in-depth analysis and troubleshooting, especially that you have some sort of customized and third-party products in your Dynamics GP environment.

Sorry for the inconvenience again.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Zero cost randomly on SOP invoice - why?

Nothing is returned.

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

Like (0)

Report

RE: Zero cost randomly on SOP invoice - why?

I hope you haven't lost patience yet !

Run this please for one posted sales invoice with zero cost

SELECT * FROM IV10201 WHERE ORIGINDOCID = '#SalesDocumentNumber'

Was this reply helpful? Yes No