Answer

Processing Status (ARPayment\CCPaymentStateDesc) field doesn't work in GI

Forum|Forum|2 years ago
August 9, 2023
2 replies
78 views

+1

fosterjeff01
Freshman II

Has anyone found a way to get the Processing Status (ARPayment\CCPaymentStateDesc) to display in a GI? It is always blank in the GI, even though if you go into the form there is data displayed for the field. Would be EXTREMELY helpful to be able to see and filter for transactions that have declined, etc.

Best answer by hkabiri

@fosterjeff01 It is a bit complex but you can simply Use ExternalTransaction DAC and you can find DocType and RefNbr for the ARPayment. Using ProcStatus would give you the value it shows on UI for Processing Status. However, you need to rely on the Max TransactionID as your payment might have multiple row for the same payment but only last one would be the status you see on UI.

As you can see in my screenshot I have two rows for 002687 payment and TransactionID 133 is the last one. In case you want to check completed transactions you can add condition ExternalTransaction.Completed equals 1 and that shows the latest one.

+8

hkabiri
Acumatica Support Team
Answer
Forum|Forum|2 years ago
August 9, 2023

@fosterjeff01 It is a bit complex but you can simply Use ExternalTransaction DAC and you can find DocType and RefNbr for the ARPayment. Using ProcStatus would give you the value it shows on UI for Processing Status. However, you need to rely on the Max TransactionID as your payment might have multiple row for the same payment but only last one would be the status you see on UI.

As you can see in my screenshot I have two rows for 002687 payment and TransactionID 133 is the last one. In case you want to check completed transactions you can add condition ExternalTransaction.Completed equals 1 and that shows the latest one.