Skip to main content

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?

Hi @charithalakshan49 

can you share the Notification XML report attachment here?

Share the screenshot of Report paramters?

@manikantad18 Thanks for the response. here they are,

DocType Parameter

 

RefNbr Parameter

 

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.

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

Hi @charithalakshan49 

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

Thanks

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

Hi @charithalakshan49 

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

Thanks

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.

 

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.

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.    

Reply


Terms & ConditionsCookie 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