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) / Average costing method
Microsoft Dynamics NAV (Archived)

Average costing method

(0) ShareShare
ReportReport
Posted on by tyhj 625

I'm new to NAV 2013 R2, I am studying the functionality of NAV in accounting.

I am using average costing method in the calculation, my scenario as follow :

I have a Purchase for 5 qty of Item A at unit price 10, and continue with confirmation and receipt.

After that I sold 2 qty of Item A at the same unit price, and invoiced.

Then when I received the purchase invoice, the unit price is 12.

My question is : 

How can I account the price difference of 2 ? 

What happen to my remaining quantity ?

Appreciate help, thanks.

*This post is locked for comments

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

    You need to run "Adjust Cost Item Entries" batch job.

    This will pass the difference amount to sales entries (COGS) and would give the correct financials.

  • tyhj Profile Picture
    tyhj 625 on at

    Can you elaborate more on the steps to take ?

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    NAV should understand when you have made a certain purchase and certain sale. Since you can do this transactions in a different sequence (not in chronological order), the actual transactions that NAV is doing might not be correct in the end. To fix this, there is a special job called Adjust Cost - Items Entries. You can find it in ***/Departments/Financial Management/Inventory/Adjust Cost - Items Entries. Run this job and system will run through the item transactions and make corresponding corrections to adjust the written cost to correct values.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    As mentioned by Alexander, You can find the option under /Departments/Financial Management/Inventory/Adjust Cost - Items Entries.

    Please note that, this batch job is absolutely mandatory to have accurate Inventory & COGS financial impact. You need to run this batch job on periodic basis (preferred daily).

    Refer below link for more details.

    msdn.microsoft.com/.../hh169387(v=nav.90).aspx

  • tyhj Profile Picture
    tyhj 625 on at

    How can I verify the final value ?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    You can navigate the Posted Sales Invoice and see the additional Value Entries and G/L Entries created by the system.

    Alternatively you can also drill down item ledger entries and navigate the same to see the impact.

    Item Register and G/L register would also show all the entries created by system.

  • tyhj Profile Picture
    tyhj 625 on at

    I noticed that before I run Adjust Cost - Item Entries, my Unit Cost has auto changed from 10 to 12 after my purchase posted, after I run Adjust Cost - Item Entries, the Unit Cost changed back to 10, which is my original value.

    So at this point when I have other sales entries, it will take Cost amount as 10, right ?

    But I thought it supposed to take 12 since I pay to vendor at this cost ? 

    Correct me if I was wrong. Thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Don't worry about the Unit Cost.

    System will take the actual Average Cost as on date, when you post the Sales.. This batch job will adjust the accurate costing for the outbound sales entries.

    You can check by posting the entries in test environment.

  • tyhj Profile Picture
    tyhj 625 on at

    Yes I try to post purchase invoice and then sales invoice, the sales invoice will take the old cost 10 instead of 12

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    But, running the Adjust Cost - Items Entries it will correct it to a needed one?

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)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans