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


Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

INTRODUCTION


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.

More Information


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 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.
Note To print the invoice number, make sure that you select Invoice in the One Check Per drop-down list in the Select Payables Checks window. To do this, follow these steps:


  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

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (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.