Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Notify Customer when o...
Finance forum
Unanswered

Notify Customer when open customer transactions are settled

Posted on by 77
 Hi, I need to email a customer when a customer open transaction is settled.  What's the best trigger for this?
 
Should it be when a record is inserted into the CustSettlement Table?
 
Thank You
  • CU01050835-0 Profile Picture
    CU01050835-0 77 on at
    Notify Customer when open customer transactions are settled
    I found the answer.
    The proper method can be found in the post method of the following class: CustVendTransSettlement
     
    The method returns a list of everything settled.
  • CU01050835-0 Profile Picture
    CU01050835-0 77 on at
    Notify Customer when open customer transactions are settled
    That was my first thought, but I've been asked to this real time so I need to find good method for the trigger.
  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 7,405 User Group Leader on at
    Notify Customer when open customer transactions are settled
    Hi,
     
    In this case i think you must create a new batch job to search of transactions group by customer account.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • CU01050835-0 Profile Picture
    CU01050835-0 77 on at
    Notify Customer when open customer transactions are settled
    Or one payment for 3 invoices in which case I cannot send the notification on the insert method of CustSettlement
  • CU01050835-0 Profile Picture
    CU01050835-0 77 on at
    Notify Customer when open customer transactions are settled
    But what if two payments are made to pay one invoice and I only want to send out one notification that one invoice was paid?  In this case, I would be sending two notifications instead of one?
  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 7,405 User Group Leader on at
    Notify Customer when open customer transactions are settled
    Hi,
     
    Yes, you can create a table extension and override insert method.
    for e.g.
    [ExtensionOf(tableStr(CustSettlement))]
    final class CustSettlement_Extension
    {
        public void insert()
        {
            next insert();
            // add your logic here
        }
    }
    Best regards,
    Mohamed Amine MAHMOUDI

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans