Skip to main content
Solved

Notification Source to Customer Table


Michaelh
Semi-Pro III
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

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

5 replies

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

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


Michaelh
Semi-Pro III
Forum|alt.badge.img+2
  • Author
  • Semi-Pro III
  • 187 replies
  • 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 


 

 


Nilkanth Dipak
Semi-Pro I
Forum|alt.badge.img+10

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


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