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.

Return to Microsoft Great Plains page
Return to Altico Practice Areas page