Open Forum

Expand all | Collapse all

Cost not on sales order

  • 1.  Cost not on sales order

    TOP CONTRIBUTOR
    Posted Dec 10, 2019 06:43 PM
    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
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Cost not on sales order

    TOP CONTRIBUTOR
    Posted Dec 10, 2019 07:23 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Cost not on sales order

    TOP CONTRIBUTOR
    Posted Dec 17, 2019 05:54 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Cost not on sales order

    TOP CONTRIBUTOR
    Posted Dec 18, 2019 06:51 AM
    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 @Andrew Kennedy​​ 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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Cost not on sales order

    GOLD CONTRIBUTOR
    Posted Dec 11, 2019 07:44 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Cost not on sales order

    TOP CONTRIBUTOR
    Posted Dec 12, 2019 10:01 AM
    For drop shipments the cost is recorded from the vendor invoice

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

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Cost not on sales order

    TOP CONTRIBUTOR
    Posted Dec 18, 2019 01:04 PM

    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Cost not on sales order

    TOP CONTRIBUTOR
    Posted Dec 18, 2019 06:35 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 9.  RE: Cost not on sales order

    Posted 18 days ago
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 10.  RE: Cost not on sales order

    GPUG ALL STAR
    Posted Dec 19, 2019 08:41 AM
    Hi @Jeff Roe

    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





    ------------------------------

    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 11.  RE: Cost not on sales order

    TOP CONTRIBUTOR
    Posted Dec 20, 2019 05:53 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role