News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Inventory GL Reconcile

Microsoft Dynamics GP (Archived)

Inventory GL Reconcile

(1) Share

Report

Report

Posted on by Rosemary

2

Hello All,

I am looking for some help in the above process of Inventory GL Reconcile. I have ran the Reconcile to GL option for Inventory and the Inventory is more than the GL, I have been looking at this since yesterday and I am not seeing the difference. I have checked transfers, receipts, returns, but I am missing something.

Something from the subledger did not get to the GL and/or something is in the GL which affected the Inventory. Is there something I am missing

Regards,

Rosemary

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Rosemary 2 on at

Like (0)

Report

RE: Inventory GL Reconcile

Thanks Roy,

We don't use Manufacturing but that is the conclusion I have come to, our Finance people keep making adjustments every month.

Inventory use the Inventory Offset accounts, I am looking at if it is being used as it should.

Thanks again
Ken Roy 490 on at

Like (0)

Report

RE: Inventory GL Reconcile

Hi Rosemary,

The reconcile to GL has never worked for me. I was told it's because I use the Manufacturing module.

I've struggled resolving this issue in the past. What I do now is check Stock Status to the GL at the end of each day. I keep a running total spreadsheet. When I find a discrepancy, I only have to look back on one day. I will print out the detail transactions for the GL code in Inventory History then the GL Trial Balance detail.

IF you can't narrow down the date, it can be tough to find the offending transaction.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans