Sales Orders - Notifications

Overview#

This Notification displays Sales Order Items. The Stored Procedure name is NOTIFICATION_SALESORDERS.

Heading#

Sales Orders - Rep Name - Status - Date; Orders; Total

Fields#

• SO No
• Date - SO Date
• Rep
• User
• Order No.
• Customer
• Item No
• Category
• Description
• Total (Exc)
• Qty
• Status - SO Status - Show Colour
• Due Date (Coalesce Item Due Date, Trans Due Date)

SQL for BOS Server (All Sales Orders)#

select
EMAIL_TO,
EMAIL_CC,
EMAIL_BCC,
SUBJECT,
BODY
from NOTIFICATION_SALESORDERS
(
:DATEID_IN, --0=No Date Filter, 1=Use Date Filter
:DATESTART, --Null if No Date Filter
:DATEEND, --Null if No Date Filter
:REPID_IN, -- -1=All
:GROUPID_IN --Status Group - 1=Pending/Active, 2=Complete, -1=All
)

SQL for BOS Server (Sales Orders by Reps)#

select
EMAIL_TO,
EMAIL_CC,
EMAIL_BCC,
SUBJECT,
BODY
from NOTIFICATION_SALESORDERS_BYREP
(
:DATEID_IN, --0=No Date Filter, 1=Use Date Filter
:DATESTART, --Null if No Date Filter
:DATEEND, --Null if No Date Filter
:GROUPID_IN --Status Group - 1=Pending/Active, 2=Complete, -1=All
)