Email custom report

Email Custom query

This script will generate a report from a SQL query and send it as an attachment to an email recipient.

Prerequisites: For each order item, a supplier must be defined in the Edit Stock Item -> Suppliers screen in order to split out the order item. Each Supplier in the Suppliers register must have a Fulfillment Location in the Inventory Control -> Locations screen associated with it. i.e Items which can be fulfilled by Supplier 1 will be assigned to the fulfillment location Location 1.

Fig 1.1

Email Custom query using LW email settings

This script will generate a report froma SQL query and send it as an attachment to an email recepient. The script will use the LW email settings to send the email.

Prerequisites: For each order item, a supplier must be defined in the Edit Stock Item -> Suppliers screen in order to split out the order item. Each Supplier in the Suppliers register must have a Fulfillment Location in the Inventory Control -> Locations screen associated with it. i.e Items which can be fulfilled by Supplier 1 will be assigned to the fulfillment location Location 1.

Fig 1.2

Email Low Stock

Low Stock Email Report

This sample code will email a nominated email address all stock items that are below the minimum level.

Prerequisites: For each order item, a supplier must be defined in the Edit Stock Item -> Suppliers screen in order to split out the order item. Each Supplier in the Suppliers register must have a Fulfillment Location in the Inventory Control -> Locations screen associated with it. i.e Items which can be fulfilled by Supplier 1 will be assigned to the fulfillment location Location 1.

Fig 2.1

Email Reporting

Daily order summary (email)

This macro will email you a daily summary of your received and processed orders, by source.

Prerequisites: For each order item, a supplier must be defined in the Edit Stock Item -> Suppliers screen in order to split out the order item. Each Supplier in the Suppliers register must have a Fulfillment Location in the Inventory Control -> Locations screen associated with it. i.e Items which can be fulfilled by Supplier 1 will be assigned to the fulfillment location Location 1.

Fig 3.1

Email to Customer 

Email customer after X days after processing an order

Prerequisites: For each order item, a supplier must be defined in the Edit Stock Item -> Suppliers screen in order to split out the order item. Each Supplier in the Suppliers register must have a Fulfillment Location in the Inventory Control -> Locations screen associated with it. i.e Items which can be fulfilled by Supplier 1 will be assigned to the fulfillment location Location 1.

Fig 4.1

Oversell warning 

High Volume Selling Warning

Prerequisites: For each order item, a supplier must be defined in the Edit Stock Item -> Suppliers screen in order to split out the order item. Each Supplier in the Suppliers register must have a Fulfillment Location in the Inventory Control -> Locations screen associated with it. i.e Items which can be fulfilled by Supplier 1 will be assigned to the fulfillment location Location 1.

Fig 5.1