Table 760 "Trailing Sales Orders Setup"

Base Application · Microsoft.Sales.Analysis · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Trailing Sales Orders Setup
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	User ID	Text[132]	—	DataClassification EndUserIdentifiableInformation
2	Period Length	Option	—	OptionCaption: Day,Week,Month,Quarter,Year
3	Show Orders	Option	—	OptionCaption: All Orders,Orders Until Today,Delayed Orders
4	Use Work Date as Base Δ BC28	Boolean	Specifies if you want data in the Trailing Sales Orders chart to be based on a work date other than today’s date. This is generally relevant when you view the chart data in a demonstration database that has fictitious sales orders.
5	Value to Calculate	Option	—	OptionCaption: Amount Excl. VAT,No. of Orders
6	Chart Type	Option	—	OptionCaption: Stacked Area,Stacked Area (%),Stacked Column,Stacked Column (%)
7	Latest Order Document Date	Date	—	FlowField: max(“Sales Header”.“Document Date” where(“Document Type” = const(Order)))

Keys

Key1: User ID (clustered)

Procedures

GetCurrentSelectionText(): Text[100]: Returns a formatted text string describing the current chart settings.
GetStartDate(): Date: Returns the start date for chart calculations based on the current settings.
GetBusinessChartType(): Enum "Business Chart Type": Returns the business chart type enum value based on the current chart type setting.
SetPeriodLength(PeriodLength: Option): Updates the period length setting for the chart.
SetShowOrders(ShowOrders: Integer): Updates the show orders filter setting for the chart.
SetValueToCalcuate(ValueToCalc: Integer): Updates the value to calculate setting for the chart.
SetChartType(ChartType: Integer): Updates the chart type setting for visual display.

Relations

Latest Order Document Date: CalcFormula Table 36 “Sales Header”

Pages and codeunits on this table

Page 761 “Trailing Sales Orders Setup” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Trailing Sales Orders Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.