AccumulationRegisterManager.<Accumulation register name>.Balance
Syntax:
Parameters:
<PointInTime> (optional)
The point in time beginning at which balances must be gotten. If the parameter is not specified, current balances will be gotten (as of the last register register record date). If Date is passed as a parameter, balances will be gotten as of the beginning of the day; if PointInTime is passed, balances will ignore register register records that occurred at that point in time.
<Filter> (optional)
Structure containing a set of register dimension values for which totals must be filtered. Structure key name must be the same as the register dimension name specified in the designer, and value of an element of structure - sets value selected on given dimension.
If the parameter is not specified filter is not used.
<Dimensions> (optional)
List of dimensions for which balances must be gotten. Line containing dimension names separated by commas.
If you don't specify the parameter or set the empty string, remainders are created for all dimensions.
<Resources> (optional)
List of resources for which balances must be gotten. Line containing resource names separated by commas.
If you don't specify the parameter or set the empty line, remainders are created for all resources.
Default value: Empty string.
Returned value:
Created values table.
Description:
Availability:
Note:
Example:
Balance = AccumulationRegisters.Balance; Filter = New Structure; Filter.Insert("Nomenclature",SelNomenclature); Filter.Insert("Warehouse", Selection); BalanceTable = Balance.Balance(SelDate,Filter, "Nomenclature,Warehouse", "Quantity"); |