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' 

  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.



Popular posts from this blog

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

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

Extract Journal Entries for Auditors using SQL Query