GP Guru Level Up: Episode 1 - How to use a macro to process 300+ NSF in Dynamics GP in minutes

Out of the 13,000 records we drafted there were 300+ transactions with No Sufficient Fund (NSF) or bank account was not yet ready to be drafted. In this video I will show you how to create a macro to save you time and energy in processing NSF in Dynamics GP.



Here is the NSF macro template for future use:

# DEXVERSION=18.00.0021.000 2 2
CheckActiveWin dictionary 'default'  form 'RM_Misc_Transaction' window 'RM_Misc_Transaction' 
  TypeTo field 'Customer Number' , '09728003SA'
  MoveTo field 'Document Type' item 1  # 'Sales / Invoices' 
  ClickHit field 'Document Type' item 7  # 'Payments' 
  MoveTo field '(L) Document Number' 
  TypeTo field '(L) Document Number' , 'PYMNT000000343441'
  MoveTo field 'Void Date' 
  TypeTo field 'Void Date' , '01262022'
  MoveTo field 'GL Posting Date' 
  MoveTo field '(L) NSF Button' 
  ClickHit field '(L) NSF Button' 
NewActiveWin dictionary 'default'  form 'RM_Misc_Transaction' window 'RM_NSF_Debit_Charge' 
  MoveTo field 'Document Amount' 
  MoveTo field 'Transaction Description' 
  TypeTo field 'Transaction Description' , 'NSF Charge - R01'
  MoveTo field 'Document Date' 
  TypeTo field 'Document Date' , '01272022'
  CommandExec dictionary 'default'  form 'RM_Misc_Transaction' command 'OK Button_w_RM_NSF_Debit_Charge_f_RM_Misc_Transaction' 
NewActiveWin dictionary 'default'  form 'RM_Misc_Transaction' window 'RM_Misc_Transaction' 


Steps:
  1. Prepare your Excel file with the following columns:
    1. Void Date
    2. Customer Number
    3. Amount
    4. Reason Code
    5. Payment Number
  2. Copy the macro template (above) to a blank MS Word
  3. Select Mailings >> Select Recipients >> Use an Existing List (look for your excel file), make sure to mark "First row of data contains column headers" >> click OK.
  4. Highlight one field at a time for field mapping and then click on Insert Merge Field. Make sure not to drop any single quote.
  5. Finish and Merge >> Edit Individual documents
  6. Select ALL >> OK
  7. Review your listings and verify

Once verified, copy the content of MS Word into a Note Pad and save as a mac file. This file will be used to PLAY in NSF window.


 

Comments

Post a Comment

Popular posts from this blog

WHERE TO GO IN ARIZONA

Image
DynamicsCon Live 2023 THE SCOTTSDALE PLAZA RESORT & VILLAS 7200 N SCOTTSDALE RD, SCOTTSDALE, ARIZONA, 85253, USA DynamicsCon LIVE, Hosted by Dynamics User Group returns May 22nd-25th in sunny Scottsdale, AZ! We’re returning with twice the content and breakout room space! Over 115 sessions will be happening over the course of 3 days, with a welcome reception to kick off and reunite the DUG community the evening of Monday, May 22nd. Dynamics User Group (DUG) Arizona would like to welcome you!  The Scottsdale Plaza Resort & Villas is located just minutes away from the restaurants, shops, and art galleries of Old Town Scottsdale listed below . Also, there are many places to explore if you are staying few more days after the conference. With a dazzling array of amazing sights, Arizona’s desert climate is home to some astounding geological formations and canyons that are well worth exploring. The Grand Canyon, for example, is one of the United States’ most famous sights, while the i
Read more

GP Guru Level Up: Episode 3 - How to bring your out of the box Aged Trial Balance into Smartlist

Image
 We had a great session at our Dynamics User Group Virtual with our guest speaker Marion Palaming discussing techniques in using SQL Views to create  PM and RM Aged Trial Balance into Smartlist. Here are the SQL Views used in the presentation: Disclaimer: did some minor updates from Victoria Yudin's SQL Views RECEIVABLES MODULE USE ['yourDB] GO /****** Object:  View [dbo].[RM_SMAging_CurrentDate]    Script Date: 4/21/2023 10:54:48 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RM_SMAging_CurrentDate] AS SELECT CM.CUSTNMBR AS Customer_ID, CM.CUSTNAME AS Customer_Name, CM.PYMTRMID AS Customer_Terms, CM.CUSTCLAS AS Customer_Class, CM.PRCLEVEL AS Price_Level, RM.CURNCYID,               CASE RM.RMDTYPAL WHEN 1 THEN 'Sale / Invoice' WHEN 3 THEN 'Debit Memo' WHEN 4 THEN 'Finance Charge' WHEN 5 THEN 'Service Repair' WHEN 6 THEN 'Warranty' WHEN 7 THEN 'Credit Memo' WHEN 8 THEN 'Return' WHEN 9 THEN &
Read more

GP Guru Level Up: Episode 2 - How to use the Replicator to create a macro with John Arnold

Image
 In continuation of my previous blog in  Episode 1  about using a macro to process NSF, I learned that there's an easiest way to create a macro using the  Replicator and it's   free for everyone!  This is developed by John Arnold , Senior Software Engineer from US Digital. Preparation steps: Go to John's website:  Rnoldz.com/ Click on Replicator >> Download the Replicator Excel File Right click on the file >>  Mark the checkbox to Unblock Security Open the Replicator File Ready your NSF macro Ready your data in Excel Here is the NSF macro template for future use: # DEXVERSION=18.00.0021.000 2 2 CheckActiveWin dictionary 'default'  form 'RM_Misc_Transaction' window 'RM_Misc_Transaction'    TypeTo field 'Customer Number' ,  '09728003SA'   MoveTo field 'Document Type' item 1  # 'Sales / Invoices'    ClickHit field 'Document Type' item 7  # 'Payments'    MoveTo field '(L) Document Number
Read more