445
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,645
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (