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

This article describes how to change the US-NACHA-CCD+ format to include an invoice number in the Addenda record in Electronic Funds Transfer (EFT) for Payables Management in Microsoft Dynamics GP.

Applies to:   Microsoft Dynamics GP
Original KB number:   968015

Introduction

To change the US-NACHA-CCD+ format to add an invoice number to the Addenda record, follow these steps:

1. Make a backup of the existing US-NACHA-CCD+ format. To do it, follow these steps:

   1. On the Cards menu, point to Financial, and then select 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're creating a new EFT format ID, you can skip this section.

   3. Select 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. Select Export.

2. Edit the format to add an invoice number in the Addenda record. To do it, 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, select 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, select Data Field.
   7. Leave the Pad Char field blank.
   8. In the Justify drop-down list, select Left or Right based on the bank requirements.
   9. Select the line that you created, and then select Show Details to open the data field line for more specifications.
   10. In the Table Names drop-down list, select PM Apply to History File.
   11. In the Field Name Lookup window, select Apply to Document Number, and then select Select.
   12. Select Save.

3. Test the EFT file to verify that the file meets the bank requirements. To do it, follow these steps:

   1. On the Cards menu, point to Financial, and then select 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, select US-NACHA-CCD+.
   4. Select Save.
   5. On the Microsoft Dynamics GP menu, point to Tools, point to Routines, point to Financial, and then select Generate EFT Prenotes.
   6. In the Generate EFT Prenotes window, enter the EFT checkbook ID that you're using in the Checkbook ID field.
   7. In the Prenotes For area, select Vendors Only.
   8. In the Prenote Format ID field, enter the EFT format ID that you created in steps 3a through 3c.
   9. Select Process.
   10. Make sure that the created prenote meets the bank requirements.

Disclaimer

Microsoft and/or its suppliers make no representations or warranties about the suitability, reliability or accuracy of the information contained in the documents and related graphics published on this website (the "materials") for any purpose. The materials may include technical inaccuracies or typographical errors and may be revised at any time without notice.

To the maximum extent permitted by applicable law, Microsoft and/or its suppliers disclaim and exclude all representations, warranties, and conditions whether express, implied or statutory, including but not limited to representations, warranties, or conditions of title, non infringement, satisfactory condition or quality, merchantability and fitness for a particular purpose, with respect to the materials.

Rapid Publishing Disclaimer

Rapid publishing articles provide information directly from within the Microsoft support organization. The information contained herein is created in response to emerging or unique topics, or is intended supplement other knowledge base information.