Distributions Do Not Match in Microsoft Dynamics GP

Ever get the error “The distributions do not match” when saving an SOP Invoice or return document?  Typically this happens when someone edits the amounts. The Distribution Codes in the distribution window refer to specific values (such as the total receivables, or the total sales amount, or tax amount) and MUST match the
appropriate total on the invoice. For example, if the Sales code is edited, additional sales codes and GL distributions can be added to the list but the total of the distributions for all of the Sales codes must match the total sales on the invoice.

To fix it, open the distributions and click the Defaults button. This will set the distributions correctly (assuming all the account numbers are filled in). If necessary the user can edit distributions one at a time and save them until the error occurs again in order to identify the specific source of the error message.

Displaying Distributions in Payables Documents

Want to run a report that displays all of the distributions for a payables document and can be easily exported to Excel? Here are the instructions to do just that using SmartList.

• Open SmartList.
• Open the Account Transactions folder.
• Click on the Columns button.
• Click Add.
• Add the following columns:
  a. Originating Master ID
  b. Originating Master Name
  c. Originating Document Number
  d. Originating Posted Date
  e. Any other columns you want to see
• Enter the search criteria: Series = Purchasing.
• Click on Order By and insert Originating Master ID.
• Insert Originating Document Number.
• Close the Search window.
• Click Favorites and save the search.
• Click Excel.

This will display a distribution breakdown of all payables transactions. It will have one row for each distribution and for each transaction.