Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jeff Roe]

We have situations where the cost is not showing on a Sales Order Transaction upon entry. The item on the Sales order does have a Current and Standard cost on the item card

Ideas?

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————

[Samantha Higdon]

Hi Jeff,

Are you using periodic or perpetual costing?  I ask since you mention both current and standard costs.

When sales items are listed on the sales order, it looks at the appropriate inventory layer (FIFO, LIFO, etc.) that would be consumed for that transaction.  I would recommend looking at the Item Transaction Inquiry by going to Inventory>>Inquiry>>Item Transaction .  This will let you see each receipt and consumption layer of that item as well as the unit cost.  It’s possible someone received inventory in (via a Receivings Transaction Entry, Inventory Adjustment, etc.) with a unit cost of $0.00.  If that happened, then the transaction that allocates/consumes that layer (in this case a sales order/invoice) would show a cost of $0.00. 

Note that if your window isn’t automatically expanded to show the second row of data per layer (the second row contains unit cost among other things), I have highlighted in red the small circle with downward facing arrows to expand to view that data.

Does that make sense?  It’s not a guarantee to be the cause, but it’s the first thing I would look at.

Thanks,

Samantha

——————————
Samantha Higdon ,CPA,CGMA
Lagom, LLC
Carmel IN
——————————
——————————————-

[Jeff Roe]

What about items that are new, have a current and standard cost in the item master but have not yet been ordered on PO or have a receipt. Shouldn’t they still show an item cost on the sales order?

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————
——————————————-

[Samantha Higdon]

Hi Jeff,

If there’s no history at all for the item, but you have entered a current cost (if perpetual) or standard cost (if periodic), then yes the cost should display on the sales order.

Since there is no history at all, I would second ?? and recommend checking to see if the “Display Item Unit Cost” is checked.  Attached are two screenshots of the exact same sales order which contains a brand new item I just set up with a current cost (I’m using perpetual valuation) but no history.  

The first screenshot shows how the order is viewed when the “Display Item Unit Cost” is checked.  The second shows how the order is viewed when the “Display Item Unit Cost” is unchecked.

Thanks,

Samantha

——————————
Samantha Higdon ,CPA,CGMA
Lagom, LLC
Carmel IN
——————————
——————————————-

[Andrew Kennedy]

Hi Jeff,
Also Check the Sales Order Processing setup.  The first box in the upper left is “Display Item Unit Cost”.  If this is unchecked, the unit cost will always display as zero.

——————————
Andrew Kennedy
Principal Consultant
Velosio
Seven Hills OH
——————————
——————————————-

[Bruce Strom]

For drop shipments the cost is recorded from the vendor invoice

——————————
Bruce Strom
Programmer Analyst
Superior Lighting, Inc.
Sunrise FL
——————————
——————————————-

[Bruce Strom]

This is a behavior question:
What about items that are new, have a current and standard cost in the item master but have not yet been ordered on PO or have a receipt. Shouldn’t they still show an item cost on the sales order?

Go into Fabrikam, create an inventory item, enter differing current and standard costs, and then create a sales order with that item.
Let us know what happens.

——————————
Bruce Strom
Programmer Analyst
Superior Lighting, Inc.
Sunrise FL
——————————
——————————————-

[Jeff Roe]

The issue has been resolved. Apparently even if the company is using Extended Pricing VS Standard Pricing, GP is still expecting an entry in at least the IV00107 and IV00108 tables.

Not only was cast an issue but we were finding that some parts could be placed on an order and allocate, fulfil and invoice even with no quantity on hand.

Once the standard pricing tables were populated, the cost was now visible and those parts with no on hand quantity started prompting to back order.

This all appears to be a result of the conversion from a 3rd party ERP into a new GP company.

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————
——————————————-

[Elaine Ward]

Thank you for the hint with the IV00107 and IV00108 tables.   We had one item in the series which was missing most of the UOFM rows in those tables. It has been an item in our system for several years. We do use extended pricing and Sales Transactions were able to be inputted without an issue.  After order was fulfilled and our accounting department ran a report checking for zero cost, this item was flagged on several orders.  Fields which were zero in SOP10200 table included:  UNITCOST, ORUNTCST, EXTDCOST, OREXTCST, and QTYBSUOM.  After fixing IV00107 and IV00108, new orders for that item are showing correct information in those fields.

——————————
Elaine Ward
Bollin Label Systems
Toledo OH
——————————
——————————————-

[Jo deRuiter]

Hi

I think you are saying that it is not displaying in the SOP Window even though there is clearly an Item Cost in the Inventory Cards Windows.

If this is the case, then it could be a SOP Setup issue.

If you go to Sales>Setup>Sales Order Processing there is an option to display the cost during data entry (caveat, you can see it, but can’t change it in SOP).

Here is what the setup looks like:

?

Here is how it displays in SOP Entry

——————————

——————————
——————————————-

[Jeff Roe]

This was actually related to another issue that when corrected cleared up the cost display issue.

BTW, Sales Order Processing is set to display the cost on the SOP window.

Regards

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————
——————————————-