Skip to main content
Answer

Notification Source to Customer Table

  • March 24, 2023
  • 5 replies
  • 172 views

Michaelh
Pro I
Forum|alt.badge.img+2

How do I join the NotificationSource table to the Customer table in a GI? I’m trying to output all mailing settings for each customer so we can see who has overrides enabled for specific functions (like invoices etc). I’ve tried using the DAC browser for this, but I’m not finding a way to get from A to B.

 

Anyone feeling super knowledgeable today? I’d love an assist on this one, thanks! 

Best answer by hkabiri

@Michael Hansen  You can use NotificationRecipient or NotificationSource DAC and join them to Customer using RefNoteId=NoteId fields respectively

5 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+8
  • Acumatica Support Team
  • Answer
  • March 24, 2023

@Michael Hansen  You can use NotificationRecipient or NotificationSource DAC and join them to Customer using RefNoteId=NoteId fields respectively


Michaelh
Pro I
Forum|alt.badge.img+2
  • Author
  • Pro I
  • March 24, 2023

Thank you!


Hi ​@Michaelh 
Could you check and confirm why it is not able to link the Customer with Notification recipient
Attached the GI - html Also 
FYKI 


 

 


DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi ​@abhinayaananadhan22,

I believe you cannot directly add the Customer DAC to the parent table. First, you need to establish a relationship between the Customer and the parent DAC so that the Customer can be used in the child table. Once the relationship is set, you can use the Customer as the parent in the next step.


Hope, it helps!


Thanks, I have tried but it shows the same error 
Where it shows the customer table is not connected to any other table