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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to make Unit Cost ...
Microsoft Dynamics NAV (Archived)

How to make Unit Cost as zero

(0) ShareShare
ReportReport
Posted on by TonyMatt 510

Hi experts,

How to make the unit cost as zero? The costing method is FIFO.

The inventory is zero and we have passed the revaluation journal to make all purchase receipts and relevant entries in the item ledger entries as Zero. Now all ILE entries for Cost Amount (expected) and Cost Amount (Actual) is showing as zero.

Also when you dig down the Unit Cost, all the closing entries are showing zero as well. However the value on the unit cost stay as it is. I did an Item Journal for a +ve adjustment with value 1 and it changed the unit cost to 1. Then I posted the re-valuation journal as zero. The unit cost still stay as 1. Somehow it doesnt like the zero value.

When I try to change the unit cost manually, it say "you cannot change Unit Cost because there are one or more ledger entries for this item".

I tried running Adjust Cost - Item entries as well but with no luck... Any help would be much appreciated. 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Please let me know other company is having same issue as above. I am looking for a solution and I also doubt that why NAV cannot handle the cost in different Sales Order.

    As below, we are using FIFO method

    Purchase Receipt/Invoice

    01/01/2016   Item A   $10    12 Pcs

    04/03/2016   Item A   $11    15 Pcs

    Sales Order

    05/05/2016   Item A  $10     27 Pcs

    NAV only pick up first cost and there is different between expected cost vs actual cost for second Purchase Receipt. It is not right at all in NAV inventory costing design.

    Is there other work around in NAV without entering two lines at Sales Order and apply manually to Value Entry.

    Thanks.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    Do not worry about first cost in sales order.

    You wuold require to run the "Adjust Cost Item Entries Batch" job. This would give update the correct valuation and would give the perfect COGS.

    So in your case, once you run the batch job, system would adjust the cost as (10*12 + 11*15=285 USD) in Value Entries & Financial G/L Entries.

    This batch job needs to be run on daily or weekly basis to have accurate inventory valuation (both in Value Entry & G/l Entry)

    Hope this helps.

  • Community Member Profile Picture
    Community Member on at

    I did try to run batch job process, however, there is none of item are adjusted.

    This can be due to auto adjustment? Our environment is set costing method FIFO, auto costing calculaion and specify 'lot  no'.

    Thanks.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Ideally, this should not happen . When you use Lot No., system would not use FIFO method but it would be more of Lot Specific and should definitely work.

    What is your NAV Version? Is there any customisation done related to Inventory Valuation?

    Have you checked the related Item Ledger Entry & Value Entry properly? Check Applied entries against the sales entries and see if it is correct or not?

  • Community Member Profile Picture
    Community Member on at

    We are using standard inventory module and version is NAV2009R2. The application entries was correct, however, the cost itself did not average out for different lot no even the purchasing cost is different.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Can you attach sample Item Ledger Entries & Value Entries where you are facing such issue? Sales entries should definitely match the inbound purchase entries.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans