web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Cost Amount (Actual) &...
Microsoft Dynamics NAV (Archived)

Cost Amount (Actual) & Cost Per Unit Updated as Zero

(0) ShareShare
ReportReport
Posted on by Community Member

we are in middle of implementation for NAV 2009 R2 and we are having a weird issue. The Warehouse uses receives the stock against the PO and the Accounts user is just posting the Purchase Invoice for the Received quantity. Both are happening at different time intervals. Now when we look at the Value entry for these Purchase Invoices, the Cost Amount (Actual) and Cost per unit is updated as zero.

The Inventory setup is Automatic cost posting as ON. Automatic cost adjustment as Never, Average cost Calc type -Item, Average cost period - Day. This happened when the Automatic cost adjustment was set as Never. Then we changed to Always and then run the ACIE and Post Cost to GL. Still it is showing as zero. Due to this the COGS for the related sales entries are appearing as zero which is causing a big issue at the client place?

Questions are

1) Why this was updated as zero and how to resolve it?

2) How to put this to an end so that it does not appear again

Thanks in advance

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    Hi there,

    apparently I'm facing a similar issue. We have posted purchases via item journal (really big inventory cleanup operation, different story). For some reason a few of the items have no cost amounts, but the right purchase amount. After searching around for an hour or so (and as I type this here), I realized that these items are set to "Inventory Value Zero" :) Yes, that could explain it. The reason we put them in as zero value is that we have a special setup where we handle some items as inventory (where and how many) and as fixed assets (current value). So... in this case the cost of the purchase is left on the cost account, and will be posted to fixed assets and depreciation by the accountants.

    with best regards

    Jens

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at

    Maybe, it is because if we have posting of purchase invoices, output, or positive adjustment with the net invoiced quantity of the item changes from negative or zero to positive or the unit cost on the item card is zero, NAV will update the item unit cost with the value in the Last Direct Cost field on the item card.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    Hi Aleksandar,

    I think you're referring to UpdateUnitCost in CU5804 ItemCostMgt:

    UpdateUnitCost(VAR Item : Record Item;LocationCode : Code[10];VariantCode : Code[10];LastDirectCost : Decimal;NewStdCost : Decimal;Upda
GetInvtSetup;
WITH Item DO BEGIN
  IF NewStdCost <> 0 THEN
    "Standard Cost" := NewStdCost;

  IF "Costing Method" = "Costing Method"::Standard THEN
    "Unit Cost" := "Standard Cost"
  ELSE BEGIN
    IF CalledFromAdjustment THEN BEGIN
      CostCalcMgt.GetRndgSetup(GLSetup,Currency,RndgSetupRead);
      IF CalculateAverageCost(Item,AverageCost,AverageCostACY) THEN BEGIN
        IF AverageCost <> 0 THEN
          "Unit Cost" := ROUND(AverageCost,GLSetup."Unit-Amount Rounding Precision");
      END ELSE BEGIN
        CalcLastAdjEntryAvgCost(Item,AverageCost,AverageCostACY);
        IF AverageCost <> 0 THEN
          "Unit Cost" := ROUND(AverageCost,GLSetup."Unit-Amount Rounding Precision");
      END;
    END ELSE BEGIN
      IF ("Unit Cost" = 0) OR ((InvoicedQty > 0) AND (LastDirectCost <> 0)) THEN BEGIN
        CALCFIELDS("Net Invoiced Qty.");
        IF ("Net Invoiced Qty." > 0) AND ("Net Invoiced Qty." <= InvoicedQty) THEN
          "Unit Cost" := LastDirectCost;
      END;
    END;
  END;

...

    This code only updates when the (calculated) unit cost is not 0, and if it is 0, last direct cost must not be 0. Or it won't be updated. This can be a major pain when you revalue items down to zero (which we do). But won't explain the original question.

    with best regards

    Jens

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans