Hi,
I’m trying to create a generic inquiry to extract customer payment details (Account Number, Title of Account, Particulars, Code, and Reference) from this customer payment method screen, as displayed in be below screenshot.
However, the inquiry is generating duplicate records and I’m unable to extract the correct details. I’ve attached the generic inquiry for your reference. Could someone assist me with this issue?
Best answer by lauraj46
Hi
Based on the DAC Schema, it looks like the join between CustomerPaymentMethod and CustomerPaymentMethodDetails should be on PMInstanceID, not PaymentMethodID.
Hope this helps!
Laura
+8Hi
Based on the DAC Schema, it looks like the join between CustomerPaymentMethod and CustomerPaymentMethodDetails should be on PMInstanceID, not PaymentMethodID.
Hope this helps!
Laura
Hi
Appreciate for your help. I’ve now changed join to PMInstanceID and it’s correctly displaying value.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
