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.