Question

Send Quick report output as Excel file through mail when custom event is triggered

  • 25 April 2024
  • 3 replies
  • 63 views

Badge +1

When a custom event is triggered (When a shipment is closed), I want to run a quick report and send its output as a Excel file through email.


3 replies

Userlevel 4
Badge +9

That would have to be an additional custom event. So, my recommendation is for you to specify as precisely as ever possibly your requirements for the event that will send the quick report. The assign that job to a System Developer and then create the quick report.

Alternatively you can add the extra code to your existing custom event.

Just remember to document exactly what the event/-s are to do. Undocumented events is a real pain once you start an upgrade project.

/Jonas

Badge +1

So, the requirement is as follows.

When I Close a shipment, it should execute a Quick report by passing the shipment_id and then mail the output of that Quick report as an Excel to the email of receiver in that shipment.

The exported file should be a .xlsx file, that is the requirement.

Userlevel 4
Badge +9

I’m not sure I quite get it, is it not a Consignment Note you are specifying?

/Jonas

Reply