Budget

Gets the budget by Client, Code, Cost Center, Daterange.

TopalBaeBudgetByDates("code";"dateFrom";"dateUntil")

This Function returns the budget of the account or group based on a given Code and Date range.

Function call:
=TopalBaeBudgetByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeBudgetByDates("CellNo.";"01.04.2016";"30.04.2016")

Example:

Figure 1: return budget of account by daterange

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBudgetByClientDates("Client";"Code";"DateFrom";"DateUntil")

This Function returns the budget of the account or group based on a given Clientname, Code and Date range.

Function call:
=TopalBaeBudgetByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeBudgetByClientDates("Client";"CellNo.";"DateFrom";"DateUntil")

Example:

Figure 2: return budget of account by client, daterange

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBudgetCcByDates("Code";"Cc";"DateFrom";"DateUntil") [WORKING PROCESS]

This Function returns the budget of the account or group based on a given Code, Cost Center and Date range.

Function call:
=TopalBaeBudgetCcByDates("1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeBudgetCcByDates("CellNo.";"Cost Center";"DateFrom";"DateUntil")

Example:

Figure 3: Account Name

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBudgetCcByClientDates("Client";"Code";"Cc";"DateFrom";"DateUntil") [WORKING PROCESS]

This Function returns the budget of the account or group based on a given Client, Code, Cost Center and Date range.

Function call:
=TopalBaeBudgetCcByClientDates("Mon Bijou AG";"1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeBudgetCcByClientDates("Client";"CellNo.";"Cost Center";"DateFrom";"DateUntil")

Example:

Figure 4: Account Name

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.