EFT file with count per vendor of checks

(0) Share

Report

Posted on by Richard Wheeler

75,850 Moderator

Our bank indicated that for record 21 on the detail they need number of remittance, which is the number of invoices paid by vendor. So if we have on check for a vendor but it paid 5 invoices, then we the 5 for record 24. Is this possible?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Cheryl Waswick on at

Like (0)

Report

Hi Richard,

GP can only count/sum AFTER the records are printed, so you cannot count the addenda records on a line BEFORE them. So you would not be able to put a count of the addenda lines paid by a payment in the DETAIL line. It is documented in this KB article:

support.microsoft.com/.../2956922

You would need a dexterity customization to achieve that, or a 3rd party product for EFT. The only work-around would be to print 'one check per invoice' instead of per vendor and then you can hard-code that count in the DETAIL line to a constant of 1.

Hope that helps,

Thanks

Cheryl Waswick

Microsoft Support

Was this reply helpful? Yes No