Active
These functions verify if the Item is active.
This Function returns if the account is active or not based on a given Code.
Function call:
=TopalBaeActive("1000") or =TopalBaeActive("CellNo.")
=TopalBaeActive("1000") or =TopalBaeActive("CellNo.")
Example:
Figure 1: return if account is active or not
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.
This Function returns if the account is active or not based on a given Clientname and Code.
Function call:
=TopalBaeActiveByClient("Mon Bijou AG";"1000") or =TopalBaeActiveByClient("Client";"CellNo.")
=TopalBaeActiveByClient("Mon Bijou AG";"1000") or =TopalBaeActiveByClient("Client";"CellNo.")
Example:
Figure 2: return if account is active or not by client
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
An error will be displayed if given account does not exist in your Chart of Account.