Quotations - Notifications

Overview

This Notification displays Quotation Items. The Stored Procedure name is NOTIFICATION_QUOTATIONS.

Navigation: Office > My Organisation > Staff > Notifications > Quotations (CPYSTAFF.EMAIL_QT)

Quotations - Rep Name - Status; Date; Quotes; Total

QT No.: The Quotation Number.
Date: The date on which the original quotation was created.
Rep: The Staff Member assigned the role of representative in Office > My Organisation > (select Staff Member) Role > Rep
User: Indicates the Staff member or originator of the Quotation
Customer: The name of the Customer selected from a dropdown list to whom the Quotation is addressed
Item No.: A sequential number is given to each Quotation item
Category: The Job Category description
Description: Description of the items in the Estimate for specific products and services
Total (Excl): A line-item total in the local Currency of the transaction, excluding the VAT amount
Qty: Indicates the number of Units
Status - QT Status - Show Colour: Indicates the current Status of the Quotation
Forecast: Forecast date

select

EMAIL_TO,

EMAIL_CC,

EMAIL_BCC,

SUBJECT,

BODY

from NOTIFICATION_QUOTATIONS

(

: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

)