If you add an addenda line to the existing EFT file format in Payables Management in Microsoft Dynamics GP, only one addenda record is listed for each vendor payment. You would expect multiple addenda lines (each invoice that totals the payment amount) to be listed under the vendor payment detail line. Only one addenda line prints and the rest of the addenda records are missing.
For example, if five invoices make up the total vendor payment line, only the first addenda record is listed and the other four addenda records are omitted. You would expect five addenda records to be listed under the detail line for the vendor payment.
This is a problem in Microsoft Dynamics GP 10.0 and earlier versions, when using addenda records in the EFT file format. The addenda record will return only 'one' addenda record under each vendor payment when the check batch was generated using One Check Per Vendor. (Quality issue #50690)
This issue was fixed in Microsoft Dynamics GP 2010 Service Pack 1.
Work-around: During the Select Checks process, select the option for One Check per Invoice instead of One Check per Vendor. This work-around will generate a payment or detail line for each invoice, so there should only be one addenda record for each detail line.
Resolution: Upgrade to Service Pack 1 or higher for Microsoft Dynamics GP 2010.
This issue was not fixed in Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 9.0.