SOP order line item unit cost is zero for an inventory item

(0) Share

Report

Posted on by Linda Brock

Hi,

My item costs and quantities are correct in GP. If I enter a sales order, the unit cost comes in at zero. I've tried with various items and for orders that allocate by line item, or by document/batch.

The items are sales inventory and the valuation is FIFO Periodic

The items do have a current cost populated on the item maintenance window and also have years of inventory transaction and sales history with the correct cost.

The correct cost does post to the GL when I post the invoice.

How can I get the cost to display on a sales order?

Thanks,

Linda

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Ken Roy 490 on at

Like (0)

Report
Copy link

Link copied!

What pricing method and default price list are you using?

You can look in the manual on how to setup price levels. This is from the manual:

The price for an item is determined by price levels. The system will first check the price level selected on the customer card. If a price level hasn’t been assigned to the customer, the price level from the Receivables Management Setup window is used. If there isn’t a price level set up for the customer or for Receivables Management, the default price level for the item is used.

https://turnkeytec.com/wp-content/uploads/2016/07/Microsoft-Dynamics-GP-2013-User-Guide-Sales-Order-Processing.pdf

Was this reply helpful? Yes No
Linda Brock 18 on at

Like (0)

Report
Copy link

Link copied!

Hi Ken,

The Unit COST is actually the issue. The client populates the unit price manually (items have currency amount for the price method)

However, the unit cost pulls in at zero although the item has on hand and available quantities with the correct cost in the system.

The items do use FIFO Periodic, but do have a standard cost populated . . .

Thanks,

Linda

Was this reply helpful? Yes No
Ken Roy 490 on at

Like (0)

Report
Copy link

Link copied!

I'm not familiar with Currency Amount as the method. I use % of List Price. The Unit Price is what populates on the SO line item for me.

When I expand the Line on the SO, the Unit Cost is zero for me also. When I check the line item in SOP10200, there is a Unit Cost.

Upon further investigation, The Unit Cost is not populated on the invoice after transfer of SO. Once the invoice is posted and moved to the history table, the Unit Cost becomes populated.

Was this reply helpful? Yes No
Verified answer

Cheryl Waswick Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Linda,

Make sure to go to Tools |Setup | Sales |Sales Order Processing and mark the option for 'Display Item Unit Cost' at the top of the list.

Hope that helps,
Cheryl W.

Microsoft Dynamics GP Support

Was this reply helpful? Yes No
Linda Brock 18 on at

Like (1)

Report
Copy link

Link copied!

Thank you Cheryl!

I am so embarrassed - I totally forgot about that checkbox. I always check it, so haven't run across a situation where it was unchecked . . .

You're a lifesaver!!

Thanks,

Linda

Was this reply helpful? Yes No