Skip to main content
Solved

Report Attaching via Notification Template is not working

C
Varsity I
Forum|alt.badge.img+1

Hi all,

 

I have customized report and I wanted to attach it using notification template which is triggered by a Business event and Generic inquiry. But the issue is I am getting error saying “Object reference not set to an instance of an object”. 

Business Event History

But when I’m running report in usual way it is generating without any issue. Also I can generate that report programmatically from code side as well. 

 

I tried passing fixed parameters and passing parameters through the GI as well in notification template. however, it is not working and it always gives above error message. 

 

what can be the issue here?

Best answer by charithalakshan49

Hi @manikantad18 Thanks for being so helpful🤝.

However, I was able to resolve the issue by removing the following sorting fields from the corresponding report. I think those sorting fields are useless as they are showing as DELETED and those may have effected the report generation in notification template as well.

 

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

10 replies

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

Hi @charithalakshan49 

can you share the Notification XML report attachment here?

Share the screenshot of Report paramters?

Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
S
2 people like this
  • Chris Hackett
    Chris Hackett
  • S
    saisuryad08
C
Varsity I
Forum|alt.badge.img+1

@manikantad18 Thanks for the response. here they are,

DocType Parameter

 

RefNbr Parameter

 

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

Hi 

Are you passing parameter values in the template  as shown below.

We are sending the Invoice report along with Invoice confirmation email, So we need to pass the parameter values.

Acumatica Functional Consultant & Customer Experience Supervisor
S
1 person likes this
  • S
    saisuryad08
C
Varsity I
Forum|alt.badge.img+1

@manikantad18  Yes. I tried that as well. But it shows the same error in Business event history.

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

Hi @charithalakshan49 

Can you confirm if the email is sending with out attaching the report?

Thanks

Acumatica Functional Consultant & Customer Experience Supervisor
S
1 person likes this
  • S
    saisuryad08
C
Varsity I
Forum|alt.badge.img+1

Hi @manikantad18  Yes. When I remove the report attachment. it is sending without any issue. 

Manikanta Dhulipudi
1 person likes this
  • Manikanta Dhulipudi
    Manikanta Dhulipudi
Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @charithalakshan49 

Please share the GI Xml, Business event and report if possible.

Thanks

Acumatica Functional Consultant & Customer Experience Supervisor
S
1 person likes this
  • S
    saisuryad08
C
Varsity I
Forum|alt.badge.img+1

Hi @manikantad18 Thanks for being so helpful🤝.

However, I was able to resolve the issue by removing the following sorting fields from the corresponding report. I think those sorting fields are useless as they are showing as DELETED and those may have effected the report generation in notification template as well.

 

Manikanta Dhulipudi
1 person likes this
  • Manikanta Dhulipudi
    Manikanta Dhulipudi
Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
charithalakshan49 wrote:

Hi @manikantad18 Thanks for being so helpful🤝.

However, I was able to resolve the issue by removing the following sorting fields from the corresponding report. I think those sorting fields are useless as they are showing as DELETED and those may effect the report generation in notification template as well.

 

Thank you for the Update.

Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
C
S
3 people like this
  • Chris Hackett
    Chris Hackett
  • C
    charithalakshan49
  • S
    saisuryad08
A
Freshman I
  • asullivanNAW
  • Freshman I
  • 2 replies
  • February 13, 2024

I had the same experience with a business event.   The report sorting fields had a ‘DELETED’.   I removed this from report and the business event work as I needed.    

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved