SQL script to populate the Payables Distribution Type SETP (PM40103) table

Microsoft Dynamics GPI recently wrote a report for a client which included payables distributions; in order to output the distribution type, I joined to the Payables Distribution Type SETP (PM40103) table. Unfortunately, when the report was deployed, it didn't work: all of the rows had a blank distribution type.

When I investigated I found that the Payables Distribution Type SETP (PM40103) table was empty. My demo environment is running Fabrikam and had fifteen rows of data, so I decided to migrate my table content to the clients system using a simple SQL script to insert the extracted rows.

The script is a simple one which doesn't do any checking so confirm the table is empty before running.

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
INSERT INTO PM40103 (DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (1, 'CASH', 'CASH') ,(2, 'PAY', 'Accounts Payable') ,(3, 'AVAIL', 'Discounts Available') ,(4, 'TAKEN', 'Discounts Taken') ,(5, 'FNCHG', 'Finance Charge') ,(6, 'PURCH', 'Purchases') ,(7, 'TRADE', 'Trade Discounts') ,(8, 'MISC', 'Miscellaneous') ,(9, 'FREIGHT', 'FREIGHT') ,(10, 'TAXES', 'TAXES') ,(11, 'WRITE', 'Write Offs') ,(12, 'OTHER', 'OTHER') ,(13, 'GST', 'GST') ,(14, 'PPS', 'PPS') ,(15, 'UNIT', 'UNIT')

New Microsoft Dynamics GP Sample Data

Microsoft Dynamics GPMicrosoft have been adding quite a lot of new functionality to Microsoft Dynamics in recent versions, but the sample data has not been getting updated.

To remedy this, Terry Heley on the Dynamics GP Support and Services Blog has shared some macros, for Dynamics GP 2016, which add sample data into the Fabrikam sample data.

The new sample data focuses on a few modules:

  • Advanced Human Resources
  • Analytical Accounting
  • Workflow for HRP
  • Project Accounting Time and Expense
  • PTO Manager
  • Employee Self Service

Terry points out that this is a run at your own risk macro built on GP 2016, although it would probably be usable on Dynamics GP 2015 as well.

There are instruction documents with each macro as macros can crash based on the menu bar selected in user Preferences.

Also note that there is no support for these macros so no cases can be logged if issues are found.

The download link is available at the end of the post.