Can retrieve information like code, city, street, zip of client also get current client name.
TopalClientCode("clientName")
|
This Function returns the code of the client based on a given Client name.
Function call:
=TopalClientCode("Mon Bijou AG") or =TopalClientCode("clientName")
Example:
Figure 1: return the code of client
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalClientCity("clientName")
|
This Function returns the City of the client based on a given Client name.
Function call:
=TopalClientCity("Mon Bijou AG") or =TopalClientCity("clientName")
Example:
Figure 2: return the city of client
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalClientStreet("clientName")
|
This Function returns the City of the client based on a given Client name.
Function call:
=TopalClientStreet("Mon Bijou AG") or =TopalClientStreet("clientName")
Example:
Figure 3: return street of client
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalClientZip("clientName")
|
This Function returns the Zip of the client based on a given Client name.
Function call:
=TopalClientZip("Mon Bijou AG") or =TopalClientZip("clientName")
Example:
Figure 4: return zip of client
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns the current Client name.
Function call:
=TopalCurrentClientName()
Example:
Figure 5: return current client name
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.