Hi there, Can anyone inform me "how to manually reconcile Inventory subledger to the GL ? "
we are using the version Microsoft Dynamics GP 2010 & this is the first time i would like to reconcile the above.
Thanks
*This post is locked for comments
Hi babu..thanks for your support.
Hi leslie, you are right i don't have that part in my version. I will try to check through the historical report as you suggested.
Any other solutions please let me know.
Thanks
Hi,
I don't think the Inventory and Bank Reconciliation parts of that routine where introduced until GP 2013. Reconciling Inventory to the GL can be a daunting task indeed. I'd almost rather update to 2013 and use the built-in tool than try to do it manually. Rabia, you said it's the first time you have ever wanted to do it, can you find a time in history when it was in fact in balance? Depending on how long you have been on the system, you might have an accurate Historical IV Trial Balance report that can help you identify differences. The best way I have found to do it is to approach it from the SQL side. At least that way I could try to match up the entries going through to the general ledger from the entries in the sub-ledger.
Kind regards,
Leslie
Rabia,
Have you tried the following under financial Routines.
Financial >> Routines >> Financial >> Reconcile to GL
Use the Reconcile to GL window to generate a Microsoft Excel spreadsheet that can help you match transactions in General Ledger with the original transactions in Payables Management, Receivables Management, Inventory Control, and Bank Reconciliation. The reconcile routine will not change data automatically
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#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
Share
Report
All responses (
Answers (