Currency

The follow functions return the currency of the Code using Parameter like Client, Code.
 
TopalBaeCurrency("Code")
This Function returns the currency of the account based on a given Code.
 
Function call:
=TopalBaeCurrency("1000") or =TopalBaeCurrency("CellNo.")
 
Example:
Figure 1: return the curreny of account
 
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
 
TopalBaeCurrencyByClient("Client";"Code")
This Function returns the currency of the account based on a given Client and Code.
 
Function call:
=TopalBaeCurrencyByClient("Mon Bijou AG";"1000") or =TopalBaeCurrencyByClient("Client";"CellNo.")
 
Example:
Figure 2: return the curreny of account by client
 
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.