Only one addenda record is listed for each vendor payment in the EFT file when using Electronic Funds Transfer for Payables Management in Microsoft Dynamics GP

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.

Symptoms

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.


Cause

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.


Resolution

This issue was not fixed in Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 9.0.

More Information

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×