Skip to main content
Solved

Customer payment method detail inquiry screen

P
Jr Varsity III
Forum|alt.badge.img

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 ​@pankaj65 ,

Based on the DAC Schema, it looks like the join between CustomerPaymentMethod and CustomerPaymentMethodDetails should be on PMInstanceID, not PaymentMethodID.

Hope this helps!

Laura

View original
1 Attachments
Did this topic help you find an answer to your question?

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • 591 replies
  • Answer
  • March 10, 2025

Hi ​@pankaj65 ,

Based on the DAC Schema, it looks like the join between CustomerPaymentMethod and CustomerPaymentMethodDetails should be on PMInstanceID, not PaymentMethodID.

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
P
Jr Varsity III
Forum|alt.badge.img
  • pankaj65
  • Author
  • Jr Varsity III
  • 15 replies
  • March 10, 2025

Hi ​@lauraj46 ,

 

Appreciate for your help. I’ve now changed join to PMInstanceID and it’s correctly displaying value.

 

lauraj46
Chris Hackett
2 people like this
  • lauraj46
    lauraj46
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved