Open Forum

Expand all | Collapse all

Direct unit cost updating by itself

  • 1.  Direct unit cost updating by itself

    Posted Mar 30, 2020 08:34 AM
    We have run into an issue where when we change the quantity on a PO the "Direct Unit Cost" field will update to our Standard Cost without any input from any person. It appears to be a NAV function but one that does not make sense to me. Is there any way to prevent this from happening?

    We manually enter a price into the field to match our quoted cost, and if a supplier over ships or short ships we obviously have to make adjustments but we regularly run into issues with Accounting when we update the quantity but do not notice that the cost changed by itself.



    ------------------------------
    Ian McKenzie
    ONICON Incorporated
    Largo FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Direct unit cost updating by itself

    TOP CONTRIBUTOR
    Posted Mar 31, 2020 10:46 AM
    Our former VAR indicated Nav is set up to link one invoice line to one PO receipt line.
    It forces a recalculation if the quantiry is altered.

    "but when the user edits the Quantity on the purchase invoice line, standard NAV will re-calculate the price/discount on the line (even though one could argue that it shouldn't since it was linked to a PO line).

    This is standard functionality. Usually, a user just copies in the lines to a Purchase Invoice from Get Receipt Lines function and may edit the Unit Price or Discount %, but typically the user is not editing the "Quantity". In this particular case, I'm not sure why they only invoiced you for 5 when your receiving team posted a receipt for all 10 at the same time, but when the user edits the Quantity on the purchase invoice line, standard NAV will re-calculate the price/discount on the line (even though one could argue that it shouldn't since it was linked to a PO line). I am guessing this is not a common occurrence. (In most partial scenarios, if you ordered 10 and they are only invoicing you for 5, you would see two receipts for 5 each and the user would pick from one of those).

    So the recommendation would be to simply delete/remove the Discount % on the Purch. Invoice line to get it to equal what the vendor is charging you.

    We set up our column display to show the following fields next to each other Quantity, Unit of Measure, Direct Unit Cost Excluding Tax, Unit Price $, Line Discount%    also make sure you have visibility to the Indirect Cost Percentage, Unit Cost($),  and the line Discount Amount.   Navision requires certain fields to be opened up for visibility by your VAR some that are dynamically altered by the payable entry functions. We inserted a warning
    message that an Indirect Unit Cost % was being created when it should not.

    You do not want to directly enter a Unit Cost, you want the line to calculate the math.

    We changed our payables entry to force the Payables Header to be restricted to only one PO so we kept visibility of PO receipt lines limited.

    We do a test post of the Invoice to make sure Received Po Lines plus freight equals the invoice total, and no extraneous GL posting are being created. If it does not balance you have to go back through the lines
    and see which line got altered from the issued PO, and fix it before posting.

    ------------------------------
    Michael Heatherly
    controller
    Lesman Instrument Company
    BENSENVILLE IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Direct unit cost updating by itself

    TOP CONTRIBUTOR
    Posted Apr 13, 2020 09:57 AM
    Ian, another thing would be to check if you have any vendor pricing setup. NAV will look to the vendor pricing when location, variant or quantity changes on PO lines.

    ------------------------------
    Kim Dallefeld, Kim@Dallefeld.com, Ft Worth, TX
    Dallefeld Consulting, LLC
    Member of Dynamics Consulting Group

    New View Strategies, - training and consulting.

    NAVUG All-Star
    NAVUG Programming Committee
    ------------------------------

    Academy - Online Interactive Learning from Experts


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