|
|
|
PeriodProjected([BudgetCode: String,] StartPeriod: Number[, EndPeriod: Number] [, BranchRange: String, DepartmentRange: String, Segment1Range: String, Segment2Range: String, Selection: String, ConsolidateBy: String] [, Level: Number, ExcludeNull: Boolean])
Period projected balance from actual figures up to report Period and budgeted figures for future periods relative to report period over the specified period range. If a budget code is not passed then the default budget is used. Optionally can be passed additional parameters to calculate projected summed period over a range of accounts. If additional parameters are not supplied, they will default from the iterator for the band.
Note: Branch and Department are only available in Accredo Saturn.
Note: If any of the BranchRange, DepartmentRange, Segment1Range, Segment2Range, Selection and ConsolidateBy parameters are passed in, all these parameters must be passed in.
PeriodProjected function syntax has these named arguments:
Parameter |
Description |
|---|---|
Budget Code |
Optional. Budget code to use. If not specified, defaults to the Default Budget Code set in GL Settings. |
Start Period |
Required. The starting period number. |
End Period |
Optional. If End Period is not included, the Start Period is used as a single period. |
Branch Range |
Optional. Range of branches to be included. If this is entered, the Department Range, Segment 1 Range and Segment 2 Range must be entered. If this is not entered, defaults from the Iterator.
|
Department Range |
Optional. Range of departments to be included. If this is entered, the Branch Range, Segment 1 Range and Segment 2 Range must be entered. If this is not entered, defaults from the Iterator.
|
Segment 1 Range |
Optional. Range of Segment 1 values to be included. If this is entered, the Branch Range, Department Range and Segment 2 Range must be entered. If this is not entered, defaults from the Iterator. |
Segment 2 Range |
Optional. Range of Segment 2 values to be included. If this is entered, the Branch Range, Department Range and Segment 1 Range must be entered. If this is not entered, defaults from the Iterator. |
Selection |
Optional. Selection to be included. |
Consolidate By |
Optional. String to consolidate by. |
Level |
Optional. The level to total to. |
Exclude Null |
Optional. When True, nulls will be excluded. |
|
|
|
