Customer payments incremental push data entity

(0) Share

Report

Posted on by CU21052024-0

259

Hi All,

I'm working on incremental push to export Customer Payments and any associated Reversals.

Yesterday I posted and exported a customer payment (initial inc push). And today I reversed that payment
and in incremental export file, I'm seeing two records one for the original credit (exported in first file) and one for the debit/reversal.

This happens because the reversal creates a new record in the CustSettlement table and also updates the existing settlement record. Below is the relation used in data entity.

Can anyone suggest to pull just the newest, most relevant record (either the reversal or the updated original) in an incremental push?

Select * from ledgerJournalTrans
Left outer Join custTrans on custtrans.Recld = ledgerJournalTrans.CustTransId
left outer join custSettlement on custSettlement. Transrecid = custTrans.recid
left outer join custtrans as ct1 on ctl.recid =

custSettlement.offsetrecid

Thanks in advance!

I have the same question (0)