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.