Our customer has asked us to create a SmartList of payments that includes the settlement date if it was an EFT payment. I cannot locate where this date is stored in GP after the EFT file is generated so I can link it to the payment history table.
Any guidance is greatly appreciated!
Thanks,
Althea
Hi Althea,
The only table that would hold date information for a processed EFT payment after the EFT file tables (CM20202/CM20203) have been cleared after EFT creating is PM30200 (PM History).
In this table you can locate payments by the DOCTYPE value of '6'.
As for available dates, the DOCDATE field will hold the 'Check Date' value and the DINVPDOF and PSTGDATE fields will hold the 'Post to GL' date set during the payment posting activity.
Best Regards,
Jeff