How to change the US-NACHA-CCD+ format to include an invoice number in the Addenda record in Electronic Funds Transfer for Payables Management in Microsoft Dynamics GP

1. Make a backup of the existing US-NACHA-CCD+ format. To do this, follow these steps:
   
   1. On the Cards menu, point to Financial, and then click EFT File Format.
   2. In the EFT File Format Maintenance window, enter the EFT format ID that you want change in the EFT Format ID field.
      If you are creating a new EFT format ID, you can skip this section.
      
   3. Click Import/Export.
      
   4. In the EFT File Format Import/Export window, enter the path to which you want to save the file in the Export format from current selection to field.
      
   5. Click Export.
      
2. Edit the format to add an invoice number in the Addenda record. To do this, follow these steps:
   1. In the EFT File Format Maintenance window, make sure that the US-NACHA-CCD+ format is specified in the Format Type field.
   2. In the Line Type drop-down list, click Addenda.
   3. In the Length field, type the appropriate length of the line.
   4. In the Start-End field, type the value that you want to use.
   5. In the Description field, type a description.
   6. In the Maps To drop-down list, click Data Field.
   7. Leave the Pad Char field blank.
   8. In the Justify drop-down list, click Left or Right based on the bank requirements.
      
   9. Click in the line that you created, and then click Show Details to open the data field line for additional specifications.
   10. In the Table Names drop-down list, click PM Apply to History File.
       
   11. In the Field Name Lookup window, click Apply to Document Number, and then click Select.
   12. Click Save.
       
3. Test the EFT file to verify that the file meets the bank requirements. To do this, follow these steps:
   
   1. On the Cards menu, point to Financial, and then click EFT File Format.
   2. In the EFT File Format Maintenance window, type a new EFT format ID in the EFT Format ID field, and then type a description in the Description field.
      
   3. In the Format Type drop-down list, click US-NACHA-CCD+.
      
   4. Click Save.
      
   5. On the Microsoft Dynamics GP menu, point to Tools, point to Routines, point to Financial, and then click Generate EFT Prenotes.
      
      
   6. In the Generate EFT Prenotes window, enter the EFT checkbook ID that you are using in the Checkbook ID field.
   7. In the Prenotes For area, click Vendors Only.
      
   8. In the Prenote Format ID field, enter the EFT format ID that you created in steps 3a through 3c.
      
   9. Click Process.
   10. Make sure that the created prenote meets the bank requirements.
       

1. On the Transactions menu, point to Purchasing, and then click Select Checks.
2. In the One Check Per drop-down list, click Invoice.
   

DISCLAIMER