One of our clients recently noticed that upon posting some payables transactions (with distributions in balance), when drilling down to the posted invoice's distributions, they are seeing only the payables account.
I checked some of these invoices, and verified that the resulting GL entry was correct and both accounts (payables and purchasing) were hit with the entry.
Is this something a check links might help with? Thanks!
*This post is locked for comments
This is strange situation. May be someone was deleted the one line of distribution from back end table PM10100 by mistakenly. To resolve this contact your GP partner to insert the missing distribution line to the table PM10100 in SQL.
Hope this helps!!!
Hi Leslie,
Yes, that's correct. I found that both sides of the journal entry posted to the GL, but when drilling down to the source document, only one half is there.
If the distribution table only has one leg of the journal entry, It should not have even posted, but it did? If I am reading this right, all of the postings were correct, but the inquiry window is wrong. Is that it?
Kind regards,
Leslie
May try this:-
Microsoft Dynamics GP -> Tool -> Utilities -> Purchasing -> Reconcile Purchasing Document (Select that particular Purchase Order)
or
Microsoft Dynamics GP -> Tool -> Utilities -> Purchasing -> Reconcile (Select that particular vendor id)
P/S: To be safe, try with TEST COMPANY first.
Unfortunately there was no change after running check links :(
Okay, then I would run Check Links on the Payables Open files. That might fix it.
Hi Frank,
Thanks for the response. I checked PM10100 for one of the affected unpaid invoices (which should have 2 distribution lines) and the second line is missing altogether. The account index is properly populated on the one line that exists.
J, can you look at the PM tables and determine whether the account index is on all lines of the entry? PM10100 if unpaid, PM30600 if paid. Let us know what you find.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (