The Edit List show:
**ERROR: The ACCRUED distribution(s) don't equal the actual amount.
**ERROR: A distribution account is missing or invalid.
**ERROR: The PAY distribution(s) don't equal the actual amount.
where do I see this in SQL?
*This post is locked for comments
I am sure there is a way to query (sql) records which will display records that are missing account numbers.
Jehan,
If you have a Purchasing batch that you are trying to post in payables, your error tells me that the distribution types do not balance with the Payables Transaction window. The payables distributions for the PM transactions are in the PM10100 table. You can look in there, but you won't find a field that tells you which account is missing.
As Mariano suggested, clicking the 'Default' button on the distributions window will clear up the error which I suspect was created after the distributions were initially entered. If you open the distributions window and then change things on the Payables Transaction window, your distribution accounts will not be adjusted to match. The image below will tell you which Type goes with each field. If you add together each distribution for a Type, it should match the number on the entry window.
If you carefully add the types together, you will find the error.
Kind regards,
Leslie
I want to see the transaction in the database where it is missing distribution account.
You will not see any of these errors in SQL as the validation is done by the Microsoft Dynamics GP Dexterity dictionary code (Dynamics.dic). Click on the Distributions button on the transaction screen, then click the Default button. If you have missing distribution accounts you will need to complete the account setup on the vendor card.
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 (