Skip to main content
Answer

How to join CSAttribute and CSAttributeDetail without duplicating results

  • March 5, 2025
  • 4 replies
  • 160 views

I’m fairly new in working on Generic Inquiries, and would like some guidance on how best proceed. I’m attempting to pull in attribute values from inventory item on a quote. My existing table is below:


​​​

All of the Join Types are set to Inner:

When I view the inquiry, it is essential replicating the lines:

 

The quote itself only has 4 items:

 

Best answer by bwhite49

To prevent duplication, you will likely need to add each attribute one at a time and you only need to add CSAttributeDetail for combo box type attrbutes. CSAnswers already has all the data you need for text data. So if you need to add 5 attributes from an item into your report, you are going to need to add CSAnswers 5 times into your data relations. One relation for each attribute. I don’t think you need CSAttribute involved.

 

 

4 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • March 5, 2025

@alfonsosnchz Editing the previous comment. I think you need to link CRQuote to InventoryItem first so only the items on the quote are coming in


  • Author
  • Freshman I
  • March 5, 2025

Hi ​@BenjaminCrisman, when I attempt to add inventory table using the add related table function from CRQuote, I get the following:

 


bwhite49
Captain II
Forum|alt.badge.img+10
  • Captain II
  • Answer
  • March 5, 2025

To prevent duplication, you will likely need to add each attribute one at a time and you only need to add CSAttributeDetail for combo box type attrbutes. CSAnswers already has all the data you need for text data. So if you need to add 5 attributes from an item into your report, you are going to need to add CSAnswers 5 times into your data relations. One relation for each attribute. I don’t think you need CSAttribute involved.

 

 


  • Author
  • Freshman I
  • March 6, 2025

@bwhite49 THANK YOU!!!!!! I updated the relation as you indicated and it worked exactly like I needed.