These function return name, code, type, balance, budget, budget cf of mirror account.
TopalBaeMirrorName("Code")
This Function returns the name of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorName("1020") or =TopalBaeMirrorName("CellNo.")
Figure 1: mirror account
Example:
Figure 2: return name of mirror account
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
TopalBaeMirrorNameByClient("Client";"Code")
This Function returns the name of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorNameByClient("Mon Bijou";"1021") or =TopalBaeMirrorNameByClient("Clientname";"CellNo.")
Figure 3: Topal COA
Example:
Figure 4: Mirror Account Name
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
TopalBaeMirrorName2("Code")
This Function returns the second name of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorName2("1020") or =TopalBaeMirrorName2("CellNo.")
Figure 5: Topal COA
Example:
Figure 6: Mirror Account Name 2
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
TopalBaeMirrorName2ByClient("Client";"Code")
This Function returns the second name of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Function call:
=TopalBaeMirrorName2ByClient("Mon Bijou";"1021") or =TopalBaeMirrorName2ByClient("Clientname";"CellNo.")
Figure 7: Topal COA
Example:
Figure 8: Mirror Account Name 2
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
TopalBaeMirrorParentCode("Code")
This Function returns the name of a mirror parent account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorParentCode("1000") or =TopalBaeMirrorParentCode("CellNo.")
Example:
Figure 9: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorParentCodeByClient("Client";"Code")
This Function returns the name of a mirror parent account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Function call:
=TopalBaeMirrorParentCodeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorParentCodeByClient("Client";"CellNo.")
Example:
Figure 10: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorCOATypeCode("Code")
This Function returns the code type of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorCOATypeCode("1020") or =TopalBaeMirrorCOATypeCode("CellNo.")
Figure 11: Topal COA
Example:
Figure 12: Mirror Account Name
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
TopalBaeMirrorCOATypeCodeByClient("Client";"Code")
This Function returns the code type of a mirror account. In Topal one can define an account as mirror account.
Is an account defined as mirror account, the respective name will be returned.
Function call :
=TopalBaeMirrorCOATypeCodeByClient("Mon Bijou AG";"1021") or =TopalBaeMirrorCOATypeCodeByClient("Client";"CellNo.")
Figure 13: Topal COA
Example:
Figure 14: Mirror Account Name
Error Message:
An error will be displayed, if a given account is not available or is not defined as mirror account in the Chart of account.
TopalBaeCOAHasMirror("Code")
This Function returns true or false depending if the account has a mirror or not.
Function call :
=TopalBaeCOAHasMirror("1000") or =TopalBaeCOAHasMirror("CellNo.")
Example:
Figure 15: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeCOAHasMirrorByClient("Client";"Code")
This Function returns true or false depending if the account has a mirror or not.
Function call :
=TopalBaeCOAHasMirrorByClient("Mon Bijou AG";"1000") or =TopalBaeCOAHasMirrorByClient("Client";"CellNo.")
Example:
Figure 16: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorCOAType("Code")
This Function returns the kind of type of the given mirror Code.
Function call :
=TopalBaeMirrorCOAType("1000") or =TopalBaeMirrorCOAType("CellNo.")
Example:
Figure 17: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorCOATypeByClient("Client";"Code")
This Function returns the kind of type of the given mirror Code.
Function call :
=TopalBaeMirrorCOATypeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorCOATypeByClient("Client";"CellNo.")
Example:
Figure 18: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorAccountType("Code")
This Function returns the type of the mirror account based on a given Code.
Function call:
=TopalBaeMirrorAccountType("1000") or =TopalBaeMirrorAccountType("CellNo.")
Example:
Figure 19: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorAccountTypeByClient("Client";"Code")
This Function returns the type of the mirror account based on a given Code.
Function call:
=TopalBaeMirrorAccountTypeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorAccountTypeByClient("Client";"CellNo.")
Example:
Figure 20: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorAccountTypeCode("Code")
This Function returns the type of a mirror account based on a given Code.
Function call:
=TopalBaeMirrorAccountTypeCode("1000") or =TopalBaeMirrorAccountTypeCode("CellNo.")
Example:
Figure 21: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorAccountTypeCodeByClient("Client";"Code")
This Function returns the type of a mirror account based on a given Code.
Function call:
=TopalBaeMirrorAccountTypeCodeByClient("Mon Bijou AG";"1000") or =TopalBaeMirrorAccountTypeCodeByClient("Mon Bijou AG";"CellNo.")
Example:
Figure 22: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorBalanceByDates("code";"dateFrom";"dateUntil")
This Function returns the balance of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBalanceByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 23: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorBalanceByClientDates("Client";"Code";"DateFrom";"DateUntil")
This Function returns the balance of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorBalanceByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceByClientDates("Client";"CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 24: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorAcctBalCcByDates("Code";"Cost Center";"DateFrom";"DateUntil") [WORKING PROCESS]
This Function returns the balance of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorAcctBalCcByDates("1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBalCcByDates("CellNo";"Cost Center";"DateFrom";"DateUntil")
Example:
Figure 25: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorAcctBalCcByClientDates("Client";"Code";"Cost Center";"DateFrom";"DateUntil") [WORKING PROCESS]
This Function returns the balance of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorAcctBalCcByClientDates("Mon Bijou AG";"1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBalCcByClientDates("Client";"CellNo";"Cost Center";"DateFrom";"DateUntil")
Example:
Figure 27: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorBalanceCFByDates("code";"dateFrom";"dateUntil")
This Function returns the balance cf of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBalanceCFByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceCFByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 28: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorBalanceCFByClientDates("Client";"Code";"DateFrom";"DateUntil")
This Function returns the balance cf of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorBalanceCFByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBalanceCFByClientDates("Client";"CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 29: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorBudgetByDates("code";"dateFrom";"dateUntil")
This Function returns the balance of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBudgetByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 30: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorBudgetByClientDates("Client";"Code";"DateFrom";"DateUntil")
This Function returns the balance of a mirror account or mirror group based on a given Client, Code and Date range.
Function call:
=TopalBaeMirrorBudgetByDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetByDates("Client";"CellNo.";"DateFrom";"DateUntil")
Example:
Figure 31: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorBudgetCcByDates("Code";"Cost Center";"DateFrom";"DateUntil") [WORKING PROCESS]
This Function returns the balance of a mirror account or mirror group based on a given Code, Cost Center and Date range.
Function call:
=TopalBaeMirrorAcctBudgetCcByDates("1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBudgetCcByDates("CellNo.";"Cost Center";"DateFrom";"DateUntil")
Example:
Figure 32: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorAcctBudgetCcByClientDates("Client";"Code";"Cost Center";"DateFrom";"DateUntil") [WORKING PROCESS]
This Function returns the balance of a mirror account or mirror group based on a given Clientname, Code, Cost Center and Date range.
Function call:
=TopalBaeMirrorAcctBudgetCcByClientDates("Mon Bijou AG";"1000";"Bern";"01.04.2016";"30.04.2016") or =TopalBaeMirrorAcctBudgetCcByClientDates("Client";"CellNo.";"Cost Center";"DateFrom";"DateUntil")
Example:
Figure 33: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorBudgetCFByDates("code";"dateFrom";"dateUntil")
This Function returns the budget of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBudgetCFByDates("1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetCFByDates("CellNo.";"01.04.2016";"30.04.2016")
Example:
Figure 34: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeMirrorBudgetCFByClientDates("Client";"Code";"DateFrom";"DateUntil")
This Function returns the budget of a mirror account or mirror group based on a given Code and Date range.
Function call:
=TopalBaeMirrorBudgetCFByClientDates("Mon Bijou AG";"1000";"01.04.2016";"30.04.2016") or =TopalBaeMirrorBudgetCFByClientDates("Client";"CellNo.";"DateFrom";"DateUntil")
Example:
Figure 35: Account Name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
