Skip to main content
Solved

Customer Attributes in Acumatica Report Designer relationship

  • 25 September 2024
  • 4 replies
  • 77 views

Forum|alt.badge.img

i want to display the attributes on my report i cant find his relationship to the customer 😅

 

 

Best answer by nhatnghetinh

Hi @jhoncandare04 

The system will create a field in the form AttributeID_Attributes into the Customer DAC. Please see the screenshots below.

 

 

 

 

 

 

 

Best Regards,

NNT

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

4 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 356 replies
  • Answer
  • September 25, 2024

Hi @jhoncandare04 

The system will create a field in the form AttributeID_Attributes into the Customer DAC. Please see the screenshots below.

 

 

 

 

 

 

 

Best Regards,

NNT


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 502 replies
  • September 25, 2024

Hi @jhoncandare04 ,

If you still don't see the fields where @nhatnghetinh describes, you may need to apply the Refresh function for the DAC in the Report Designer build schema.

Hope this helps!

Laura


bryanb39
Pro II
Forum|alt.badge.img+5
  • Pro II
  • 177 replies
  • September 25, 2024

An alternative and often more efficient way to use the Attribute value in formulas and filters is to use the CSAnswers table:

Join any table including customers to CSAnswers
NoteID to RefNoteID
=’LOCATION’ to AttributeID

To put a string or formula in the relationship field, select a field first on either side to create the row, then click on Parent Formula.  

When doing this with multiple Attributes or even 1, I’d recommend using the Child Alias column and naming it the Attribute name.  
 


 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 31 replies
  • September 26, 2024
nhatnghetinh wrote:

Hi @jhoncandare04 

The system will create a field in the form AttributeID_Attributes into the Customer DAC. Please see the screenshots below.

 

 

 

 

 

 

 

Best Regards,

NNT

Thank you


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