Type

The follow function return the COA/Account type of the Item using Parameter like Client, Code.

TopalBaeCOATypeCode("Code")

This Function returns the code type of the account or group based on a given Code.

Function call:
=TopalBaeCOATypeCode("1000") or =TopalBaeCOATypeCode("CellNo.")

Example:

Figure 1: return code type of account

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeCOATypeCodeByClient("Client";"Code")

This Function returns the code type of the account or group based on a given Code.

Function call :
=TopalBaeCOATypeCodeByClient("Mon Bijou AG";"1000") or =TopalBaeCOATypeCodeByClient("Client";"CellNo.")

Example:

Figure 2: return code type of account by client

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeCOAType("Code")

This Function returns what kind of type the item is based on a given Code.

Function call :
=TopalBaeCOAType("1000") or =TopalBaeCOAType("CellNo.")

Example:

Figure 3: return item type

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeCOATypeByClient("Client";"Code")

This Function returns what kind of type the item is based on a given Code.

Function call :
=TopalBaeCOATypeClient("Mon Bijou AG";"1000") or =TopalBaeCOATypeClient("Client";"CellNo.")

Example:

Figure 4: return item type by client

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeAccountType("Code")

This Function returns the type of the account based on a given Code.

Function call:
=TopalBaeAccountType("1000") or =TopalBaeAccountType("CellNo.")

Example:

Figure 5: return type of account

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeAccountTypeByClient("Client";"Code")

This Function returns the type of the account based on a given Code.

Function call:
=TopalBaeAccountTypeByClient("Mon Bijou AG";"1000") or =TopalBaeAccountTypeByClient("Client";"CellNo.")

Example:

Figure 6: return type of account by client

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeAccountTypeCode("Code")

This Function returns the type code of the account based on a given Code.

Function call:
=TopalBaeAccountTypeCode("1000") or =TopalBaeAccountTypeCode("CellNo.")

Example:

Figure 7: return type code

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeAccountTypeCodeByClient("Client";"Code")

This Function returns the type code of the account based on a given Code.

Function call:
=TopalBaeAccountTypeCodeByClient("Mon Bijou AG";"1000") or =TopalBaeAccountTypeCodeByClient("Client";"CellNo.")

Example:

Figure 8: return type code by client

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.