Skip to main content
Answer

Generic Inquiry Appointment Screen

  • January 31, 2024
  • 5 replies
  • 62 views

Forum|alt.badge.img

I am trying to add quoteNbr to my Opportunities screen. I made it to where you can see the column for quoteNbr but nothing populates. What am I missing on my generic inquiry to pull that over???

Best answer by YasasWithanage76

Hello @CAMORRISON ,

Please try this relationship to join CROpportunity DAC and the CRQuote DAC.

 

 

5 replies

gorazem
Varsity I
Forum|alt.badge.img
  • Varsity I
  • January 31, 2024

The DAC for CROpportunity has the ‘QuoteNbr’ field listed as ‘Nonexistent in DB’ so I’m not sure If that’ll populate on a GI.

I did also see a “CRQuote” table, that has a field “OpportunityID”, so you may need to join those tables, and display the QuoteNbr from the CRQuote table.


Forum|alt.badge.img
  • Author
  • Freshman I
  • February 1, 2024

I was able to add the column I just can’t get the link with the quote number to populate...


gorazem
Varsity I
Forum|alt.badge.img
  • Varsity I
  • February 1, 2024

Did you join the tables? Share your GI


YasasWithanage76
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Employee
  • Answer
  • February 2, 2024

Hello @CAMORRISON ,

Please try this relationship to join CROpportunity DAC and the CRQuote DAC.

 

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • February 2, 2024

Amazing! That worked. Thank you!