You’re offline. This is a read only version of the page.
I am trying to reconcile the GL Entry table to an Invoice. When I look at the Invoice I have approximately 20 line Items. When I look at the GL Entry I see 19 lines. Reconciling the first 18 items on my Invoice is fairly easy, you can match by amount. Of the items I can't reconcile, I have two items on my Invoice (1,000 and 500) and one item in the GL Entry ( 1,500). It obvious, that the posting process is adding two entries from my invoice and creating one line in G/L Entry.
Why is the GL process combining these two items, but not others. I spoke with one person in our accounting dept. and they have no idea, but just happens occasionally. I know something is configured to cause this to occur.
If anyone can point me to where I should look, what screens and how to navigate to them, it would be much appreciated.
Thanks,
Mike
*This post is locked for comments
Hi Suresh, I didn't see an Item setup table in the database. I am using NAV 2009 R2. I double checked General Posting Groups, Inventory Posting Groups and Customer Posting Groups. They are all the same for my 20 Items on my Invoice. So you would think they would all be combined into one GL Entry Line, but they are not. Only two Items are being combined. Any other ideas on where I can look?
It will depend on your item setup and what posting groups they use. Please check this link
itsolutions.bdo.ca/.../how-dynamics-nav-uses-posting-groups-in-sales-transactions
Hi Amol, thanks for responding.
I checked and all the items on my Invoice belong to the same Gen Prod Posting Group (I am looking at the database table "Item", field "Gen_ Prod_ Posting Group".
If what you say is true all items would be combined into one entry in the GL.
Any other ideas?
Thanks,
Mike
Check the Gen Prod.Posting group of these two items .If it is same then it will get added...
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (