Sometimes you just need to know who entered a transaction into your Microsoft Dynamics GP system. As you may have already noticed, GP has no standard window to show who entered a particular transaction.However, most of the transaction tables in the GP database do have a field for the “User ID.” This field shows the last person to touch the record, and you can easily modify your GP reports within Report Writer to include this field on your reports.Additionally, third-party vendors such as Fastpath and Rockton Software offer modules specifically for helping companies keep better track of changes to data. … [Read more...] about Who Did It? Tracking Changes in Dynamics GP

Do you ever have to output financial information with GP SmartLists and then go through the same manual efforts in Excel? Perhaps you need to export to Excel to filter out certain groups (such as top customers) or sort data (largest dollar amount to smallest dollar amount, for example).This is a typical headache for accountants trying to get a monthly analysis of business performance. It’s often a monthly ordeal and can take precious time out of your busy schedule.If this sounds familiar, you should know that we can help you create SQL objects that do the heavy lifting for you. Once the objects are loaded, you can view the data with your tool of preference, such as an Excel Refreshable Report, a SQL Server Reporting Services report or … [Read more...] about Sort Data Faster, Smarter With Our Custom Solutions