i want to display the attributes on my report i cant find his relationship to the customer 😅
Answer
Customer Attributes in Acumatica Report Designer relationship
Best answer by nhatnghetinh
Hi
The system will create a field in the form AttributeID_Attributes into the Customer DAC. Please see the screenshots below.
Best Regards,
NNT
+11Hi
The system will create a field in the form AttributeID_Attributes into the Customer DAC. Please see the screenshots below.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
+8Hi
If you still don't see the fields where
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+6An 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.
https://www.fiverr.com/acudatica
Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.