This video shows how and where I use VBA (Visual Basics for Applications) in Microsoft Dynamics GP to save me TONS of time. I built this script MANY years ago and I still cannot live without it. It copies whatever I enter of the “Paid To” or “Received From” line to the “Description Line.
Keep in mind you need Customized Site License or Modifier for this to work for you.
Another “Out of the Box” Microsoft Dynamics GP Sales Order Processing (SOP) feature that is not used enough is Process Holds. In this video, I not only show how to set up a hold, but assign it, use it, and inquiry on them.
Stop the presses, well the printing (in SOP) - YouTube
Here is a report I like to build for my Dynamics GP customers. It can be used to verify whether accounts have been added since the last printing, and it can be used to compare totals of other reports to ensure accuracy.
Some clients simply give this statement to their CPA for write-up work and as an audit sheet.
FRx used as a summary TB and a CPA worksheet - YouTube
This video shows the Microsoft Dynamics GP Deduction AND the Benefit screens for employees with 401k plans. The Benefit is set to match the Employee’s deduction 100%, with both Benefit and Deduction having a maximum amount.
401k Strikes a match (Benefit to Deduction) - YouTube