Sales Orders - Notifications

Overview

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

Navigation: Office > My Organisation > Staff > Notifications > Sales Orders (CPYSTAFF.EMAIL_SO)

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

)