News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Discrepancy between In...

Microsoft Dynamics GP (Archived)

Discrepancy between Inventory On Hand Stock Value and GL On Hand Value

(0) Share

Report

Report

Posted on by Toshi

60

Hi,

At the month end, on hand inventory value wasn't matched with the GL on hand value. We are using average perpetual method.

The discrepancy between the sub ledger on hand value and the GL on hand value is about $15,000. We matched the transaction posted in subledger and the posted transaction in GL to find transactions which didn't post in GL, but in subledger. However, all the transactions seemed to correct. We don't know why there are so much discrepancy.

Please advise how we can fix this discrepancy.

CM

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

Re: Discrepancy between Inventory On Hand Stock Value and GL On Hand Value

Hi Toshi,

There is a very good KB article, 923960, that explains in some detail how inventory is costed. "Enhancements made to the calculation of average cost in

Microsoft Dynamics GP"

Also check out KB 932023 regarding finding trx not matching between the modules "How to find transactions that are posted to Inventory but not to General Ledger in Microsoft Dynamics GP".

And look at KB861686 "Information about why the inventory value does not match

the inventory balance in Microsoft Dynamics GP"

I think these can help.

Curiously, what business are you in such that Average Perp was the selected costing method?

Kind regards,

Leslie

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans