Need EFT Settlement Date in SmartList

(0) Share

Report

Posted on by Althea ADS

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

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Jeff Grant on at

Like (0)

Report

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

Was this reply helpful? Yes No