Management - Notifications
Overview
- Notifications can be emailed to staff members. There are two sets of notifications: Sales and Management. These notifications summarise the current day's business activities.
- Ideally, schedule them after business close but before midnight to ensure management has up-to-date information to make informed decisions and maintain smooth operations.
Available Options
Note
These options are available for all the staff records. Check the applicable checkboxes on the staff member's Detail tab to activate the notifications.
Notifications - Sales
Notifications - Management
- Quotations
- Summary
- Procurement
Notifications Content
Management - Summary
- Sales Orders by Due Date (Projected Turnover): This section displays all the Sales Orders (SO) sorted by their due dates. The rows reflect the SO Status group, and the columns divide the totals into This Month, Next Month, Later and No Due Date.
- Transaction Summary: Displays a list of top Customer, Supplier and Inventory transactions. It shows both amounts and transaction quantities.
- Bank Balances: Displays all the Bank Accounts, including receipts, payments and balances.
- Inventory Ageing: Lists the Inventory categories and their respective ageing (how long items are in stock).
- Customer and Supplier Age Analyses.
SQL for BOS Server (Management - Summary)
select
EMAIL_TO,
EMAIL_CC,
EMAIL_BCC,
SUBJECT,
BODY
from NOTIFICATION_MANAGEMENT
(
:DATE_IN -- Set to null for current day.
)Management - Quotations
| Field | Description |
|---|---|
| Status | The Quotation Transaction Status. |
| QT No. | The Quotation Number. |
| Date | The date on which the original Quotation was created. |
| Forecast | Forecast date. |
| Rep | The staff member assigned as the representative. |
| User | The user who created the Quotation. |
| Customer | The name of the customer on the Quotation. |
| Item | A sequential number which is given to each line item. |
| Category | The Quotation's category. |
| Description | Description of the items. |
| Qty | The number of units. |
| Cost | Total cost of the item. |
| Profit | The line item's profit (total less the cost). |
| Total | The VAT exclusive total in the local currency. |
| /Unit | The price for one unit. |
| Adj% | The adjustment (e.g. discount) percentage. |
| MU% | Markup percentage. |
| GM% | Gross Margin percentage. |
SQL for BOS Server (Management - Quotations)
select
EMAIL_TO,
EMAIL_CC,
EMAIL_BCC,
SUBJECT,
BODY
from NOTIFICATION_MANAGEMENT_QT
(
:DATE_IN -- Set to null for current day
)Management - Procurement
Info
This notification displays Active Purchase Orders grouped by Due Date as well as Materials that are purchased and require Replenishment.
SQL for BOS Server (Management - Procurement)
select
EMAIL_TO,
EMAIL_CC,
EMAIL_BCC,
SUBJECT,
BODY
from NOTIFICATION_PROCUREMENT