Skip to main content
Solved

Send AR Aging report to customers

  • October 25, 2022
  • 3 replies
  • 250 views

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi I would like to Populate the customer Billing Email automatically when we run the report for one customer for sending an Email.

 Response from Acumatica :The report will need to be customized in order to meet this requirement. Even if the customer is indicated in the report parameter, there is no link between this parameter and the mailing settings of the report.

 

Looking for some best approach to meet this requirement.

Best answer by Manikanta Dhulipudi

Hi Everyone

 

Acumatica confirmed the report actions cannot be customized.Thanks

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

3 replies

Forum|alt.badge.img+3
  • Jr Varsity I
  • 62 replies
  • October 26, 2022

Hey,

You can utilize MailSettings on the report to default the billing email address on the aging report. To access the billing email, you must connect BAccount and BillingContact to your report (CustomerMaster does not have the billingId). Then, you can add the below into the TO field under mailing Settings.

=iif([@CustomerID] <> null, [BillingContact.EMail], '')

The above will only populate if a customer is selected.

I hope this helps!

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi Everyone

 

Acumatica confirmed the report actions cannot be customized.Thanks


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 711 replies
  • November 18, 2022

@manikantad18 as @yhartman mentioned, it may not work straight out of the box running the canned report, but this is a very easy modification to make to the report and I can assure you that the customer mailing address can be pulled for this.

It will require “customizing” the report, but technically ANY modification to the report is considered a customization.

Can you please PM the case # so I can follow up?
Here is an example which ac@yhartman provided several months ago:
 

 


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