Integrating EFT/ACH payment with our bank. Need some help with field mapping.
Fields Needed:
Total payment amount
My companies ABA #
Receiving Party Account number
Receiving Bank Primary ID
*This post is locked for comments
Thanks Somakarpagamoorthy. You beat me to it...
Finally figured out the solution. It appears a decimal place has to be set within the Decimal place field. Once I set it to "2," all subsequent EFT files process correctly. Who knew. BTW this was thew ONLY field that I had to set the decimal place.
I am not sure why you do not see dollars and cents in the DOCAMNT field. My system has the field set as numeric(19,5) so the decimals are saved in the field. I am not really familiar with how the currency settings work. You should verify that the transactions are using a currency that is set to 2 decimal places.
Jeff
So I reconfigured the EFT flat file to pull from the PM302000 table and I'm still not pulling cents?
Any thoughts on where I should look next? Currency config?
Jeff, In regards to the CHEKTOTL amount:
I just posted another test batch and I do not see the transaction in the PM10300 table.
I do see it in the CM20202 table with a line for each vendor.
Thoughts?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
