|
|
|
BudgetOpening([BudgetCode: String,] PeriodId: Number[, BranchRange: String, DepartmentRange: String, Segment1Range: String, Segment2Range: String, Selection: String, ConsolidateBy: String] [, Level: Number, ExcludeNull: Boolean])
Budget opening balance for period specified. Optionally can be passed additional parameters to calculate summed period opening balance 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 Branch, Department, Segment1, Segment2, Selection and ConsolidateBy parameters are passed in, all these parameters must be passed in.
BudgetOpening 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. |
Period ID |
Required. Period ID to use. |
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. |
|
|
|
