Client

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.

TopalCurrentClientName()

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.