Email automation for Daily Stock Received

​@MarkD Only way is to work on Business events but cracking it is little difficult where you can use Insite table for qty changes.

Hey ​@MarkD ,

I think you’re on the right track, a Business Event on a schedule will do the trick.  Prior to configuring that though, you’ll need to create your Report or GI.  If you are looking for what was received that day, I would look at the POReceiptLine as your starting point.  Set a date filter so it only looks at today, then start adding whatever relevant fields you need.

You may have to do an Inner Join to InventoryItem to be able to grab Item Class, and if CompanyID doesn’t live in POReceiptLine, I would tie into its header, POReceipt.

Once everything is set up as you like, it’s easy enough to set up the Business Event on a Schedule, and do an Email Notification as its subscriber.  Within the Email Template you can configure attaching your fancy new report to an email:

 

 Hope that gets you close, good luck!