Skip to main content
Solved

How can we add the Payment Instruction details on Generic Inquiry

  • August 22, 2024
  • 8 replies
  • 123 views

maheshc73
Freshman II

I would like to add the below payment Instruction details to the Vendor Generic Inquiry

Required table name and Relations and fields to add on result Grid

 

Best answer by nhatnghetinh

Hi @maheshc73 

You need to create a new DAC by creating a SQL View to arrange the data in columns. This requires knowledge of SQL and a little knowledge of Customization.

 

Best Regards,

NNT

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

8 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 510 replies
  • August 22, 2024

maheshc73
Freshman II
  • Author
  • Freshman II
  • 9 replies
  • August 22, 2024

I need the result grid field mapping for the payment Instruction details

they have gone through that GI it brings only the first line


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 510 replies
  • August 22, 2024

Hi @maheshc73 

Please refer to the screenshot below and the attached xml file.

 

 

 

 

Best Regards,

NNT


maheshc73
Freshman II
  • Author
  • Freshman II
  • 9 replies
  • August 22, 2024

Hi @nhatnghetinh 

I appreciate your help I have run the GI given by you it repeats the vendors on the GI and the payment details are written to the next below line

 

 

The client needs these values side by side with headings as shown below screenshot

Can you help with this type of format


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 510 replies
  • August 23, 2024

Hi @maheshc73 

Please add these conditions.

 

 

Best Regards,

NNT


maheshc73
Freshman II
  • Author
  • Freshman II
  • 9 replies
  • August 23, 2024

Hi @nhatnghetinh 

the screen you shared still contains multiple lines can we bring that to a Single line with payment details side by side as below

 


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 510 replies
  • Answer
  • August 23, 2024

Hi @maheshc73 

You need to create a new DAC by creating a SQL View to arrange the data in columns. This requires knowledge of SQL and a little knowledge of Customization.

 

Best Regards,

NNT


  • Freshman I
  • 4 replies
  • January 23, 2025

Hi ​@maheshc73 ,

Yes - you can bring the payment instruction details side by side.

Need to add LocationAPPaymentInfo and VendorPaymentMethodDetail - this one needs to add multiple times with different Alias for each and is dependent on the number of payment method details you have. In my case, I only have 3, but looks like you have 5.

Link from VendorR to Location

 

Link from Location to each of the payment method details…

 

Note the different DetailID in each of the above..

Results grid:

 


Reply


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