The follow section describes Functions, which return the names based on the given Parameters. The information usually is retrieved from the chart of accounts.
TopalBaeName("Code")
This Function returns the name of the account or group based on a given Code.
Function call : =TopalBaeName("1000") or =TopalBaeName("CellNo.")
Example:
Figure 1: return name of the account
Error Message: An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeNameByClient("Client";"Code")
This Function returns the name of the account or group based on a given Clientname and Code.
Function call: =TopalBaeNameByClient("Mon Bijou AG";"1000") or =TopalBaeNameByClient("Mon Bijou AG";"CellNo.")
Example:
Figure 2: return name of the account by client
Error Message: An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeName2("Code")
This Function returns the second name of the account or group based on a given Code.
Function call : =TopalBaeName2("1000") or =TopalBaeName2("CellNo.")
Example:
Figure 3: return second name of the account
Error Message: An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeName2ByClient("Client";"Code")
This Function returns the second name of the account or group based on a given Clientname and Code.
Function call: =TopalBaeName2ByClient("Mon Bijou AG";"1000") or =TopalBaeName2ByClient("CellNo.")
Example:
Figure 4: return second name of the account by client
Error Message: An error will be displayed if given account does not exist in your Chart of Account.
