Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Inventory valuation report and inventory g/l report mismatching

(0) ShareShare
ReportReport
Posted on by 3,518

Hello to all, 

I m using Nav 2016, i am facing a problem with inventory cost post to gl . i am using average costing method .

i posted a single entry to general ledger but system posted one more another entry to gl with different cost price for same quantity in same document. i don't know why this happened .

i will wait for your suggestions.

Thanks.

*This post is locked for comments

  • Verified answer
    Paras mehan Profile Picture
    3,518 on at
    RE: Inventory valuation report and inventory g/l report mismatching

    Hi Erik,

    Thanks for your response.

    it was related to system automatically posting the extra entry to GL with different cost while doing any adjustment from item journal.

    Actually this issue is solved but it is related to when user post positive adjustment for any item with different costs and after that user did not run adjust cost batch job and again he post negative adjustment with different cost not with average cost. after all when he run adjust cost batch job then system created that entry with remaining difference of the average cost amount.

    Regards

    Paras mehan

  • Verified answer
    epernst Profile Picture
    1,122 on at
    RE: Inventory valuation report and inventory g/l report mismatching

    Hi Paras,

    That's problem has been around since the MS-DOS days. You cannot say you are a real NAV consultant unless you had this problem! [:)]

    There may be many reasons:

    1: There have been manual adjustments in GL

    2: You have not run the Post Inventory Cost to GL job.

    You're using average cost also makes it harder to debug. I have mostly seen it in connection with returns (especially with lot no.), where the correct items have not been applied.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans