CF

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.