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.")
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.
TopalBaeActiveByClient("Client";"Code")
|
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.")
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.