The following sections describe the available Topal Excel functions. The subsequent chapers describe each function with a respective example.
Each function is assigned to a specific section to get an overview.
The follow functions return the Name such as from the COA Name or Account.
Function
|
Parameter
|
Description
|
Example
|
|
code
|
Get COA Name by Code
|
=TopalBaeName(1)
|
|
Client, Code
|
Get COA Account Name by Client and Code
|
=TopalBaeNameByClient("Mon Bijou AG";1)
|
|
code
|
Get COA Name2 by Code
|
=TopalBaeName2(1)
|
|
Client, Code
|
Get COA Account Name2 by Client and Code
|
=TopalBaeName2ByClient("Mon Bijou AG";1)
|
The follow functions return the Code of the Parent COA Item.
Function
|
Parameter
|
Description
|
Example
|
|
code
|
Get code of parent COA item by code
|
=TopalBaeParentCode(1000)
|
|
Client, Code
|
Get Code of parent COA item by Client and Code
|
=TopalBaeParentCodeByClient("Mon Bijou AG";1000)
|
The follow functions return the Balance such as by the Parameter Client, Code, Date and Cost Center.
Function
|
Parameter
|
Description
|
Example
|
|
code
|
Get balance
|
=TopalBaeBalance(1000)
|
|
Client, Code
|
Get balance by Client and Code
|
=TopalBaeBalanceByClient("Mon Bijou AG";1000)
|
|
code, date
|
Get balance by date
|
=TopalBaeBalanceByDate(1000;"01.01.2016")
|
|
Client, Code, Date
|
Get balance by Client and date
|
=TopalBaeBalanceByClientDate("Mon Bijou AG";1000;"01.01.2016")
|
|
Code, CC, Date
|
Get balance by Code, Cost Center and Date
|
=TopalBaeBalCcByDate(1000;"Bern";"01.01.2016")
|
|
Client, Code, CC, Date
|
Get balance by Client, Code, Cost Center and Date
|
=TopalBaeBalCcByClientDate("Mon Bijou";1000;"Bern";"01.01.2016")
|
|
code, dateFrom, dateUntil
|
Get balance by dates
|
=TopalBaeBalanceByDates(1;"01.01.2016";"30.11.2016")
|
|
Client, Code, Datefrom, Dateuntil
|
Get balance by Client, Code and Date range
|
=TopalBaeBalanceByClientDates("Mon Bijou AG";10000;"01.01.2016";"31.01.2016")
|
|
Code, CC, Datefrom, Dateuntil
|
Get balance by Code, Cost Center and Date range
|
=TopalBaeBalCcByDates(1000;"Bern";"01.01.2016";"31.01.2016")
|
|
Client, Code, CC, Datefrom, Dateuntil
|
Get balance by Client, Code, Cost Center and Date range
|
=TopalBaeBalCcByClientDates("Mon Bijou AG";1000;"Bern";"01.01.2016";"31.01.2016")
|
The follow functions return the currency of the Code using Parameter like Client, Code.
Function
|
Parameter
|
Description
|
Example
|
|
code
|
Get currency code
|
=TopalBaeCurrency(1000)
|
|
Client, Code
|
Get currency Code by Client and Code
|
=TopalBaeCurrencyByClient("Mon Bijou";1000)
|
The follow function return the COA/Account type of the Item using Parameter like Client, Code.
Function
|
Parameter
|
Description
|
Example
|
|
code
|
Get COA type code of COA item by code
|
=TopalBaeCOATypeCode(1)
|
|
Client, Code
|
Get COA type Code of COA item by Client and Code
|
=TopalBaeCOATypeCodeByClient("Mon Bijou AG";1)
|
|
code
|
Get COA type name of COA item
|
=TopalBaeCOAType(1001)
|
|
Client, Code
|
Get COA type name of COA item by Client and Code
|
=TopalBaeCOATypeByClient("Mon Bijou AG";1001)
|
|
code
|
Get account type by code
|
=TopalBaeAccountType(1000)
|
|
Client, Code
|
Get account type name by Client and Code
|
=TopalBaeAccountTypeByClient("Mon Bijou AG";1000)
|
|
code
|
Get account type code by COA code
|
=TopalBaeAccountTypeCode(1000)
|
|
Client, Code
|
Get account type Code by Client and Code
|
=TopalBaeAccountTypeCodeByClient("Mon Bijou AG";1000)
|
These functions verify if the Item is active.
Function
|
Parameter
|
Description
|
Example
|
|
code
|
true if item is active
|
=TopalBaeActive(1000)
|
|
Client, Code
|
true if item is active by Client and Code
|
=TopalBaeActiveByClient("Mon Bijou AG";1000)
|
These function return name, code, type, balance, budget, budget cf of mirror account.
Function
|
Parameter
|
Description
|
Example
|
|
code
|
Get COA Mirror Account Name by code
|
=TopalBaeMirrorName(1000)
|
|
Client, Code
|
Get COA Mirror Account Name by Client and Code
|
=TopalBaeMirrorNameByClient("Mon Bijou AG";1000)
|
|
code
|
Get COA Mirror Account Name2 by code
|
=TopalBaeMirrorName2(1000)
|
|
Client, Code
|
Get COA Mirror Account Name2 by Client and Code
|
=TopalBaeMirrorName2ByClient("Mon Bijou AG";1000)
|
|
code
|
Get code of parent coa item of mirror account by code
|
=TopalBaeMirrorParentCode(1000)
|
|
Client, Code
|
Get Code of parent COA item of mirror account by Client and Code
|
=TopalBaeMirrorParentCodeByClient("Mon Bijou AG";1000)
|
|
code
|
Get COA type code of mirror account by code
|
=TopalBaeMirrorCOATypeCode(1000)
|
|
Client, Code
|
Get COA type Code of mirror account by Client and Code
|
=TopalBaeMirrorCOATypeCodeByClient("Mon Bijou AG";1000)
|
|
code
|
If COA item has a mirror
|
=TopalBaeCOAHasMirror(1000)
|
|
Client, Code
|
If COA item has a mirror by Client and Code
|
=TopalBaeCOAHasMirrorByClient(Mon Bijou AG";1000)
|
|
code
|
Get COA type name of coa mirror account
|
=TopalBaeMirrorCOAType(1000)
|
|
Client, Code
|
Get COA type name of coa mirror account by Client and Code
|
=TopalBaeMirrorCOATypeByClient("Mon Bijou AG";1000)
|
|
code
|
Get mirror account type by code
|
=TopalBaeMirrorAccountType(1000)
|
|
Client, Code
|
Get mirror account type by Client and Code
|
=TopalBaeMirrorAccountTypeByClient("Mon Bijou AG";1000)
|
|
code
|
Get mirror account type code by COA code
|
=TopalBaeMirrorAccountTypeCode(1000)
|
|
Client, Code
|
Get mirror account type Code by Client and Code
|
=TopalBaeMirrorAccountTypeCodeByClient("Mon Bijou AG";1000)
|
|
code, dateFrom, dateUntil
|
Get balance of mirror account by dates
|
=TopalBaeMirrorBalanceByDates(1;"01.01.2016";"31.12.2016")
|
|
Client, Code, Datefrom, Dateuntil
|
Get balance of mirror account by Client, Code and Date range
|
=TopalBaeMirrorBalanceByClientDates("Mon Bijou AG";1000;"01.01.2016";"31.01.2016")
|
[in Progress]
|
Code, CC, Datefrom, Dateuntil
|
Get balance of mirror account by Code, Cost Center and Date range
|
=TopalBaeMirrorAcctBalCcByDates(1000;"Bern";"01.01.2016";"31.01.2016")
|
[in Progress]
|
Client, Code, CC, Datefrom, Dateuntil
|
Get balance of mirror account by Client, Code, Cost Center and Date range
|
=TopalBaeMirrorAcctBalCcByClientDates("Mon Bijou AG";1000;"Bern";"01.01.2016";"31.01.2016")
|
|
code, dateFrom, dateUntil
|
Get balance CF of mirror account by dates
|
=TopalBaeMirrorBalanceCFByDates(1;"01.01.2016";"31.12.2016")
|
|
Client, Code, Datefrom, Dateuntil
|
Get balance CF of mirror account by Client, Code and Date range
|
=TopalBaeMirrorBalanceCFByClientDates("Mon Bijou AG";1;"01.01.2016";"31.12.2016")
|
|
code, dateFrom, dateUntil
|
Get budget of mirror account by code and dates
|
=TopalBaeMirrorBudgetByDates(1000;"01.01.2016";"31.12.2016")
|
|
Client, Code, Datefrom, Dateuntil
|
Get budget of mirror account by Client, Code and Date range
|
=TopalBaeMirrorBudgetByClientDates("Mon Bijou AG";1000;"01.01.2016";"31.01.2016")
|
[in Progress]
|
Code, CC, Datefrom, Dateuntil
|
Get budget of mirror account by Code, Cost Center and Date range
|
=TopalBaeMirrorAcctBudgetCcByDates(1000;"Bern";"01.01.2016";"31.01.2016")
|
[in Progress]
|
Client, Code, CC, Datefrom, Dateuntil
|
Get budget of mirror account by Client, Code, Cost Center and Date range
|
=TopalBaeMirrorAcctBudgetCcByClientDates("Mon Bijou AG";1000;"Bern";"01.01.2016";"31.01.2016")
|
|
code, dateFrom, dateUntil
|
Get budget CF of mirror account by code and dates
|
=TopalBaeMirrorBudgetCFByDates(1000;"01.01.2016";"31.12.2016")
|
|
Client, Code, Datefrom, Dateuntil
|
Get budget CF of mirror account by Client, Code and Date range
|
=TopalBaeMirrorBudgetCFByClientDates("Mon Bijou AG";1000;"01.01.2016";"31.01.2016")
|
Key Performance Indicator (KPI)
Gets the Key Performance Indicator of an item.
Function
|
Parameter
|
Description
|
Example
|
|
Name, Datefrom, Dateuntil
|
Returns the Key Performance Indicators (KPI) Value based on the Name and Date range
|
=TopalBaeKpiValueByDates("Unternehmenserfolg";"01.01.2014";"31.03.2014")
|
|
Client, Name, Datefrom, Dateuntil
|
Returns the Key Performance Indicators (KPI) Value based on the Client, Name and Date range
|
=TopalBaeKpiValueByClientDates("Mon Bijou AG";"Unternehmenserfolg"
;"01.01.2014";"31.03.2014")
|
|
SubnodeName, Name, Datefrom, Dateuntil
|
Returns the Key Performance Indicators (KPI) Value based on the SubnodeName, Name and Date range
|
=TopalBaeKpiValueBySubnodeNameAndDates
("Geldflussrechnung";"Unternehmenserfolg";"01.01.2014";"31.03.2014")
|
|
Client, SubnodeName, Name, Datefrom, Dateuntil
|
Returns the Key Performance Indicators (KPI) Value based on the Client, SubnodeName, Name and Date range
|
=TopalBaeKpiValueBySubnodeNameAndClientDates("Mon Bijou AG";"Geldflussrechnung";"Unternehmenserfolg";"01.01.2014";"31.03.2014")
|
Gets the Foreign Currency balance of an item.
Function
|
Parameter
|
Description
|
Example
|
|
code
|
Get FC balance
|
=TopalBaeBalanceFC(1000)
|
|
Client, Code
|
Get FC balance by Client and Code
|
=TopalBaeBalanceFCByClient("Mon Bijou AG";1000)
|
|
code, date
|
Get FC balance by date
|
=TopalBaeBalanceFCByDate(1000;"01.01.2016")
|
|
Client, Code, Date
|
Get FC balance by Client, Code and date
|
=TopalBaeBalanceFCByClientDate("Mon Bijou AG";1000;"01.01.2016")
|
[in Progress]
|
Code, CC, Date
|
Get FC balance of mirror account by Code, Cost Center and Date range
|
=TopalBaeBalFcCcByDate(1000;"Bern";"01.01.2016")
|
[in Progress]
|
Client, Code, CC, Date
|
Get FC balance of mirror account by Client, Code, Cost Center and Date range
|
=TopalBaeBalFcCcByClientDate("Mon Bijou AG";1000;"Bern";"01.01.2016")
|
Gets the balance/budget "Carried Forward" of an item.
Function
|
Parameter
|
Description
|
Example
|
|
code
|
Get CF balance by Code
|
=TopalBaeBalCF(1000)
|
|
Client, Code
|
Get CF balance by Client and Code
|
=TopalBaeBalanceCFByClient("Mon Bijou AG";1000)
|
|
code, dateFrom, dateUntil
|
Get CF balance by dates
|
=TopalBaeBalanceCFByDates(1;"01.01.2016";"30.11.2016")
|
|
Client, Code, Datefrom, Dateuntil
|
Get CF balance by Client, Code and Date range
|
=TopalBaeBalanceCFByClientDates("Mon Bijou AG";1;"01.01.2016";"30.11.2016")
|
|
code, dateFrom, dateUntil
|
Get CF budget by code and dates
|
=TopalBaeBudgetCFByDates(1000;"01.01.2016";"31.12.2016")
|
|
Client, Code, Datefrom, Dateuntil
|
Get CF budget by Client, Code and Date range
|
=TopalBaeBudgetCFByClientDates("Mon Bijou AG";1000;"01.01.2016";"31.01.2016")
|
Gets the budget by Client, Code, Cost Center, Date range.
Function
|
Parameter
|
Description
|
Example
|
|
code, dateFrom, dateUntil
|
Get budget by code and dates
|
=TopalBaeBudgetByDates(1000;"01.01.2016";"31.12.2016")
|
|
Client, Code, Datefrom, Dateuntil
|
Get budget by Client, Code and Date range
|
=TopalBaeBudgetByClientDates("Mon Bijou AG";1000;"01.01.2016";"31.01.2016")
|
[in Progress]
|
Code, CC, Datefrom, Dateuntil
|
Get budget by Code, Cost Center and Date range
|
=TopalBaeBudgetCcByDates(1000;"Bern";"01.01.2016";"31.01.2016")
|
[in Progress]
|
Client, Code, CC, Datefrom, Dateuntil
|
Get budget by Client, Code, Cost Center and Date range
|
=TopalBaeBudgetCcByClientDates("Mon Bijou AG" ;1000;"Bern";"01.01.2016;"31.01.2016")
|
Can retrieve information like code, city, street, zip of client also get current client name.
Function
|
Parameter
|
Description
|
Example
|
|
clientName
|
Get client code by name
|
=TopalClientCode("Mon Bijou AG")
|
|
clientName
|
Get client city by name
|
=TopalClientCity("Mon Bijou AG")
|
|
clientName
|
Get client street by name
|
=TopalClientStreet("Mon Bijou AG")
|
|
clientName
|
Get client zip by name
|
=TopalClientZip("Mon Bijou AG")
|
|
|
Get current client name
|
=TopalCurrentClientName()
|
Login or Logout function.
Function
|
Parameter
|
Description
|
Example
|
|
|
Show login window
|
=TopalLogin()
|
|
|
Logout
|
=TopalLogout()
|
Sets the VAT Period by given Client, Period.
Function
|
Parameter
|
Description
|
Example
|
|
vatPeriod
|
Set current VAT period by date
|
=TopalSetGlobalVATPeriod(2016)
|
|
Client, VatPeriod
|
Set current VAT period by Client and date
|
=TopalSetGlobalVATPeriodByClient("Mon Bijou AG";"01.01.2016")
|
Gets the previously or by date fiscal year and sets the fiscal year.
Function
|
Parameter
|
Description
|
Example
|
|
fiscalYearName
|
Get previous fiscal year name by current Fiscal Year name
|
=TopalGetPreviousYear(2016)
|
|
Client, FiscalYear
|
Get previous fiscal year name by client name and current Fiscal Year
|
=TopalGetPreviousYearByClient("Mon Bijou AG";2016)
|
|
fiscalYearName
|
Get fiscal year date from by current Fiscal Year name
|
=TopalGetFiscalYearDateFrom(2016)
|
|
Client, FiscalYear
|
Get fiscal year date from by client and current Fiscal Year
|
=TopalGetFiscalYearDateFromByClient("Mon Bijou AG";2016)
|
|
fiscalYearName
|
Get fiscal year date until by current Fiscal Year name
|
=TopalGetFiscalYearDateUntil(2016)
|
|
Client, FiscalYear
|
Get fiscal year date until by client and current Fiscal Year
|
=TopalGetFiscalYearDateUntilByClient("Mon Bijou AG";2016)
|
|
fiscalYearName
|
Set current Fiscal Year
|
=TopalSetGlobalFiscalYear(2016)
|
|
Client, FiscalYear
|
Set current Fiscal Year by client
|
=TopalSetGlobalFiscalYearByClient("Mon Bijou AG";2016)
|
|