Skip to main content

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! 

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


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 


 

 


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 


Reply