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.
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.
