Trailing Sales Orders Window
Graphically displays sales orders that are not fully posted. The sales orders are sorted backward on a timeline and shown in periods by different relations to today’s date.
The timeline on the X-axis is divided in five period stacks, which each show the sum of orders until the last day of the period. The difference between two adjoining period stacks reflects the change in the sum of orders from one period to the next. For example, you can change the period length from Day to Week to see orders with document dates five weeks back instead of five days back.
Note
Data in the chart is based on the Document Date field of the orders, which is the date on which the order was created. However, when you select the Delayed Orders view, the data is filtered by the Shipment Date field on the orders.
When you click a stack in the chart, the Sales Orders window opens and shows not fully posted sales orders with document dates in the selected period and with order status that relate to where on the stack you clicked. Each order status is represented by a color on the stack.
You define how trailing sales order numbers are displayed in the chart by selecting among the following options from the menus above the chart.
| Menu | Option | Description |
|---|---|---|
|
Show |
||
|
All Orders |
Displays all not fully posted sales orders until the document date of the youngest order, which means the order with the most progressed document date. |
|
|
Orders Until Today |
Displays all not fully posted sales orders with document dates until today’s date. To provide a true representation of today’s data, the last stack ends on today’s date even if today’s date is in the middle of the selected period. |
|
|
Delayed Orders |
Displays all not fully posted sales orders with shipment dates that are before today’s date, which means that they should have been shipped earlier than today. The last stack ends on today’s date. |
|
|
Period Length |
||
|
Day |
Each stack covers one day. |
|
|
Week |
Each stack except for the last stack covers one week. The last stack contains data from the start of the week until the date that is defined by the Show option. |
|
|
Month |
Each stack except for the last stack covers one month. The last stack contains data from the start of the month until the date that is defined by the Show option. |
|
|
Quarter |
Each stack except for the last stack covers one quarter. The last stack contains data from the start of the quarter until the date that is defined by the Show option. |
|
|
Year |
Each stack except for the last stack covers one year. The last stack contains data from the start of the year until the date that is defined by the Show option. |
|
|
Options: Value to Calculate |
||
|
Amount |
The Y-axis shows the totaled LCY amount of the orders. It is based on the Line Amount Excl. VAT field on sales order lines. |
|
|
No. of Orders |
The Y-axis shows the number of orders. |
|
|
Options: Chart Type |
||
|
Stacked Area |
Displays the data in area layout. |
|
|
Stacked Area (%) |
Displays the percentage distribution of the four order statuses in area layout. |
|
|
Column Area |
Displays the data in column layout. |
|
|
Column Area (%) |
Displays the percentage distribution of the four order statuses in column layout. |
|
Tip
For more information on how to navigate in the user interface, see Work with Microsoft Dynamics NAV. For assistance in finding specific pages, see Search.
See Also
Reference
Generic Charts
Use Work Date as Base
Other Resources
How to: Add Charts to Role Centers and List Places
Sales Order
Document Date
Shipment Date
Line Amount