The follow functions return the Code of the Parent COA Item.
TopalBaeParentCode("Code")
|
This Function returns the code of the parent account or group based on a given Code.
Function call :
=TopalBaeParentCode("1000") or =TopalBaeParentCode("CellNo.")
Example:
Figure 1: return code of the parent account
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.
TopalBaeParentCodeByClient("Client";"Code")
|
This Function returns the code of the parent account or group based on a given Clientname and Code.
Function call :
=TopalBaeParentCodeByClient("Mon Bijou AG";"1000") or =TopalBaeParentCodeByClient("Clientname";"CellNo.")
Example:
Figure 2: return code of the parent account by client
Error Message:
An error will be displayed if given account does not exist in your Chart of Account.