Code
The follow functions return the Code of the Parent COA Item.
This Function returns the code of the parent account or group based on a given Code.
Function call :
=TopalBaeParentCode("1000") or =TopalBaeParentCode("CellNo.")
=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.
An error will be displayed if given account does not exist in your Chart of Account.
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.")
=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.
An error will be displayed if given account does not exist in your Chart of Account.