Skip to main content
Solved

How to Get Opportunity Class Attributes in ReportDesigner for Sales Quote

  • 5 June 2024
  • 3 replies
  • 49 views

Hello,

I am amending our Sales Quote Template in ReportDesigner. I want to know how to get the Attributes from the Opportunity in the Attributes Tab (See first image)?

 

So, I have set up different Opportunity Classes that have different Attributes available. Once that Opportunity Class is selected on an Opportunity, those Attributes become available in the Attributes Tab. i want to be able to have the values available to pulled into the Sales Quote Template.

 

Please advise if any solutions.

3 replies

Dipak Nilkanth
Rank
Userlevel 6
Badge +4

Hi @bonnielemay ,

You need to join the CSAnswers table to the CSAttribute table and further join the CSAttribute to CSAttributeDetail by AttributeID to retrieve the attribute values.

Dipak Nilkanth || Acumatica Developer
nhatnghetinh
Rank
Userlevel 7
Badge +5

Hi @bonnielemay 

Please refer to the pictures below:

 

 

 

 

 

 

 

 

Best Regards,

NNT

Hi Everyone. If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*
B
Rank

Hello @Dipak Nilkanth and @nhatnghetinh ,

 

Thank you for your prompt responses. I am currently working on other urgent items; however, I will be definitely trying this recommended solution.

Once I do, I will provide an update.

Reply


Terms & ConditionsCookie settings