×
Menu
Index

Active

These functions verify if the Item is active.
 
TopalBaeActive("Code")
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.