Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

What is difference between "Adjust cost item entries" and "inventory cost post to GL"

Posted on by Microsoft Employee

Hi all

Can anyone explain What is difference between "Adjust cost item entries" and "inventory cost post to GL"?

Thank you !

*This post is locked for comments

  • Verified answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: What is difference between "Adjust cost item entries" and "inventory cost post to GL"

    when you are running adjust cost batch job then system creates the cost price according to your costing method.

    example: As you are using Average costing method

    first you purchase 10 items @ $10 each = 100

    After this you again purchase 10 items @ $12 each = 120

    So now in your inventory there are 20 items. if you run adjust cost batch job then at the time of selling of an item system will take average cost= as 11@ each.

    if you post Boolean ticked then suppose you post sales adjustment but did not run adjust cost batch before posting the order. when you run adjust cost after the sales order posted then system will post remaining amount's entry to GL.

    For example: If Navision takes the cost @12 each of an item but average cost is @11 each and sales adjustment is posted then when adjust cost batch job will run then system will post @ -1 for that.

    One more point if post boolean is unticked and you run adjust cost after posting the sales order then it will effect only inventory value. it will not effect the GL. For GL effect you have to run post inventory cost to GL.

    Hope it clear your doubts.

    Best Regards,

    Paras Mehan

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What is difference between "Adjust cost item entries" and "inventory cost post to GL"

    Hi Paras,

    have you got an idea of what happens If i leave the Post field unticked during the post cost to gl, and then I close the inventory?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What is difference between "Adjust cost item entries" and "inventory cost post to GL"

    Hi Paras,

    have you got an idea of what happens If i leave the Post field unticked during the post cost to gl?

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: What is difference between "Adjust cost item entries" and "inventory cost post to GL"

    Check this white paper

    www.archerpoint.com/.../ms-dynamics-nav-2013-inventory-costing-wp-ap.pdf

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What is difference between "Adjust cost item entries" and "inventory cost post to GL"

    Aside from the links that Para Mehan sent - I would mention one thing that is not always clear for everyone. The posting date for the cost adjustment is et when the "Adjust Cost Item Entries" is run and NOT when the adjustment is posted. So if the user wants the adjustment to happen in a new accounting period they should close the period BEFORE running the "Adjust Cost..." job.

  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: What is difference between "Adjust cost item entries" and "inventory cost post to GL"

    Hi,

    Please go by mentioned links: msdn.microsoft.com/.../hh169387(v=nav.90).aspx

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

    Hope this will clear your doubts.

    Regards,

    Paras Mehan

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans