By using this function, you can include the commitment amounts for ledger account / cost center / cost unit combination balance in the worksheet.
Value
1 - original commitment amount.2 - cost amount.3 - correction amount.4 - outstanding commitment amount.
Example
COMM_BAL( 621, 2001, 4400, WAREHOUSE, PRINTERS, 4 )
As a result of the above function, the outstanding commitment amount for the combination of cost center 'WAREHOUSE' and cost unit 'PRINTERS' is included for financial year 2001, based on the amounts entered on general ledger account 4400.
See also:
[Alphabetical overview of parameters]
Excel Add-in Manual > Contents > Functions > COMM_BAL