You’re offline. This is a read only version of the page.
99
Hello,
I'm working on an EFT file format that contains only four fields that all relate to the invoices that were paid. I haven't been able to get the Applied Amount from the PM Applied To History file to appear in the EFT file. I've tried several format types and have not been successful. The format generates, but the Applied Amount is empty. I've tried US NACHA PPD+, US IAT NACHA, and User Defined. None of them appear to be able to generate the Amount applied into the EFT File.
Here are the file specs. It contains only four fields that need to be comma delimited.
Merchant Code (Vendor ID)
Invoice Number
Invoice Date
Amount Paid on Invoice
Can you point me in the right direction for formatting this as an EFT file? If this isn't possible, I'll build a custom SmartList.
This is on Dynamics GP 2016 R2.
Thanks,
Lisa
*This post is locked for comments
I have the same question (0)
Hi Lisa,
I believe you can get the fields you want by only mapping the 'ADDENDA' line type in the EFT File Format and not the Detail line. Use the 'PM Apply to History File' table for all fields, and use the Vendor ID, Apply To Document Number, Apply to Document Date and Applied Amount fields.
When you build the Payables batch, select ONE CHECK PER 'INVOICE' and build.
It will generate in a text file, so you would have to hardcode another field in-between each field above with a constant of a 'comma'. And then when you name the file location (in the checkbook master/Payables Options), you can put the name of the file and type the 'csv' extension on the file name.
The fields are really 'fixed' and not comma delimited, but hopefully with the csv file extension and comma's in-between the fields, the bank will accept it and can deal with any spaces or zeroes in the fields. But hopefully it will work.
Thanks
Cheryl
Microsoft Dynamics Online Community
Share
Report
All responses (
Answers (
