Gets the CF balance/budget of Item.
TopalBaeBalanceCF("Code")
This Function returns the cf balance of the account or group based on a given Code.
Function call:
=TopalBaeBalanceCF("1000") or =TopalBaeBalanceCF("CellNo.")
Example:
Figure 1: return cf balance of account
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeBalanceCFByClient("Client";"Code")
This Function returns the balance of the account or group based on a given Client and Code.
Function call:
=TopalBaeBalanceCFByClient("Mon Bijou AG";"1000") or =TopalBaeBalanceCFByClient("Client";"CellNo.")
Example:
Figure 2: return cf balance of account by client
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeBalanceCFByDates("code";"dateFrom";"dateUntil")
This Function returns the cf balance of the account or group based on a given Code and Date range.
Function call:
=TopalBaeBalanceCFByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeBalanceCFByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 3: return cf balance of account by daterange
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeBalanceCFByClientDates("Client";"Code";"DateFrom";"DateUntil")
This Function returns the balance cf of the account or group based on a given Client, Code and Date range.
Function call:
=TopalBaeBalanceCFByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeBalanceCFByClientDates("Client";"CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 3: return cf balance of account by client, daterange
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeBudgetCFByDates("code";"dateFrom";"dateUntil")
This Function returns the cf budget of the account or group based on a given Code and Date range.
Function call:
=TopalBaeBudgetCFByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeBudgetCFByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 5: return cf budget of account by daterange
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeBudgetCFByClientDates("Client";"Code";"DateFrom";"DateUntil")
This Function returns the budget cf of the account or group based on a given Client, Code and Date range.
Function call:
=TopalBaeBudgetCFByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeBudgetCFByClientDates("Client";"CellNo.";"DateFrom";"DateUntil")
Example:
Figure 5: return cf budget of account by client and daterange
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
