Function

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.

Name

The follow functions return the Name such as from the COA Name or Account.

Function	Parameter	Description	Example
TopalBaeName	code	Get COA Name by Code	=TopalBaeName(1)
TopalBaeNameByClient	Client, Code	Get COA Account Name by Client and Code	=TopalBaeNameByClient("Mon Bijou AG";1)
TopalBaeName2	code	Get COA Name2 by Code	=TopalBaeName2(1)
TopalBaeName2ByClient	Client, Code	Get COA Account Name2 by Client and Code	=TopalBaeName2ByClient("Mon Bijou AG";1)

Parent

The follow functions return the Code of the Parent COA Item.

Function	Parameter	Description	Example
TopalBaeParentCode	code	Get code of parent COA item by code	=TopalBaeParentCode(1000)
TopalBaeParentCodeByClient	Client, Code	Get Code of parent COA item by Client and Code	=TopalBaeParentCodeByClient("Mon Bijou AG";1000)

Balance

The follow functions return the Balance such as by the Parameter Client, Code, Date and Cost Center.

Function	Parameter	Description	Example
TopalBaeBalance	code	Get balance	=TopalBaeBalance(1000)
TopalBaeBalanceByClient	Client, Code	Get balance by Client and Code	=TopalBaeBalanceByClient("Mon Bijou AG";1000)
TopalBaeBalanceByDate	code, date	Get balance by date	=TopalBaeBalanceByDate(1000;"01.01.2016")
TopalBaeBalanceByClientDate	Client, Code, Date	Get balance by Client and date	=TopalBaeBalanceByClientDate("Mon Bijou AG";1000;"01.01.2016")
TopalBaeBalCcByDate [in Progress]	Code, CC, Date	Get balance by Code, Cost Center and Date	=TopalBaeBalCcByDate(1000;"Bern";"01.01.2016")
TopalBaeBalCcByClientDate [in Progress]	Client, Code, CC, Date	Get balance by Client, Code, Cost Center and Date	=TopalBaeBalCcByClientDate("Mon Bijou";1000;"Bern";"01.01.2016")
TopalBaeBalanceByDates	code, dateFrom, dateUntil	Get balance by dates	=TopalBaeBalanceByDates(1;"01.01.2016";"30.11.2016")
TopalBaeBalanceByClientDates	Client, Code, Datefrom, Dateuntil	Get balance by Client, Code and Date range	=TopalBaeBalanceByClientDates("Mon Bijou AG";10000;"01.01.2016";"31.01.2016")
TopalBaeBalCcByDates [in Progress]	Code, CC, Datefrom, Dateuntil	Get balance by Code, Cost Center and Date range	=TopalBaeBalCcByDates(1000;"Bern";"01.01.2016";"31.01.2016")
TopalBaeBalCcByClientDates [in Progress]	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")

Currency

The follow functions return the currency of the Code using Parameter like Client, Code.

Function

Parameter

Description

Example

TopalBaeCurrency	code	Get currency code	=TopalBaeCurrency(1000)
TopalBaeCurrencyByClient	Client, Code	Get currency Code by Client and Code	=TopalBaeCurrencyByClient("Mon Bijou";1000)

Type

The follow function return the COA/Account type of the Item using Parameter like Client, Code.

Function

Parameter

Description

Example

TopalBaeCOATypeCode	code	Get COA type code of COA item by code	=TopalBaeCOATypeCode(1)
TopalBaeCOATypeCodeByClient	Client, Code	Get COA type Code of COA item by Client and Code	=TopalBaeCOATypeCodeByClient("Mon Bijou AG";1)
TopalBaeCOAType	code	Get COA type name of COA item	=TopalBaeCOAType(1001)
TopalBaeCOATypeByClient	Client, Code	Get COA type name of COA item by Client and Code	=TopalBaeCOATypeByClient("Mon Bijou AG";1001)
TopalBaeAccountType	code	Get account type by code	=TopalBaeAccountType(1000)
TopalBaeAccountTypeByClient	Client, Code	Get account type name by Client and Code	=TopalBaeAccountTypeByClient("Mon Bijou AG";1000)
TopalBaeAccountTypeCode	code	Get account type code by COA code	=TopalBaeAccountTypeCode(1000)
TopalBaeAccountTypeCodeByClient	Client, Code	Get account type Code by Client and Code	=TopalBaeAccountTypeCodeByClient("Mon Bijou AG";1000)

Active

These functions verify if the Item is active.

Function

Parameter

Description

Example

TopalBaeActive	code	true if item is active	=TopalBaeActive(1000)
TopalBaeActiveByClient	Client, Code	true if item is active by Client and Code	=TopalBaeActiveByClient("Mon Bijou AG";1000)

Mirror

These function return name, code, type, balance, budget, budget cf of mirror account.

Function

Parameter

Description

Example

TopalBaeMirrorName	code	Get COA Mirror Account Name by code	=TopalBaeMirrorName(1000)
TopalBaeMirrorNameByClient	Client, Code	Get COA Mirror Account Name by Client and Code	=TopalBaeMirrorNameByClient("Mon Bijou AG";1000)
TopalBaeMirrorName2	code	Get COA Mirror Account Name2 by code	=TopalBaeMirrorName2(1000)
TopalBaeMirrorName2ByClient	Client, Code	Get COA Mirror Account Name2 by Client and Code	=TopalBaeMirrorName2ByClient("Mon Bijou AG";1000)
TopalBaeMirrorParentCode	code	Get code of parent coa item of mirror account by code	=TopalBaeMirrorParentCode(1000)
TopalBaeMirrorParentCodeByClient	Client, Code	Get Code of parent COA item of mirror account by Client and Code	=TopalBaeMirrorParentCodeByClient("Mon Bijou AG";1000)
TopalBaeMirrorCOATypeCode	code	Get COA type code of mirror account by code	=TopalBaeMirrorCOATypeCode(1000)
TopalBaeMirrorCOATypeCodeByClient	Client, Code	Get COA type Code of mirror account by Client and Code	=TopalBaeMirrorCOATypeCodeByClient("Mon Bijou AG";1000)
TopalBaeCOAHasMirror	code	If COA item has a mirror	=TopalBaeCOAHasMirror(1000)
TopalBaeCOAHasMirrorByClient	Client, Code	If COA item has a mirror by Client and Code	=TopalBaeCOAHasMirrorByClient(Mon Bijou AG";1000)
TopalBaeMirrorCOAType	code	Get COA type name of coa mirror account	=TopalBaeMirrorCOAType(1000)
TopalBaeMirrorCOATypeByClient	Client, Code	Get COA type name of coa mirror account by Client and Code	=TopalBaeMirrorCOATypeByClient("Mon Bijou AG";1000)
TopalBaeMirrorAccountType	code	Get mirror account type by code	=TopalBaeMirrorAccountType(1000)
TopalBaeMirrorAccountTypeByClient	Client, Code	Get mirror account type by Client and Code	=TopalBaeMirrorAccountTypeByClient("Mon Bijou AG";1000)
TopalBaeMirrorAccountTypeCode	code	Get mirror account type code by COA code	=TopalBaeMirrorAccountTypeCode(1000)
TopalBaeMirrorAccountTypeCodeByClient	Client, Code	Get mirror account type Code by Client and Code	=TopalBaeMirrorAccountTypeCodeByClient("Mon Bijou AG";1000)
TopalBaeMirrorBalanceByDates	code, dateFrom, dateUntil	Get balance of mirror account by dates	=TopalBaeMirrorBalanceByDates(1;"01.01.2016";"31.12.2016")
TopalBaeMirrorBalanceByClientDates	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")
TopalBaeMirrorAcctBalCcByDates [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")
TopalBaeMirrorAcctBalCcByClientDates [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")
TopalBaeMirrorBalanceCFByDates	code, dateFrom, dateUntil	Get balance CF of mirror account by dates	=TopalBaeMirrorBalanceCFByDates(1;"01.01.2016";"31.12.2016")
TopalBaeMirrorBalanceCFByClientDates	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")
TopalBaeMirrorBudgetByDates	code, dateFrom, dateUntil	Get budget of mirror account by code and dates	=TopalBaeMirrorBudgetByDates(1000;"01.01.2016";"31.12.2016")
TopalBaeMirrorBudgetByClientDates	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")
TopalBaeMirrorAcctBudgetCcByDates [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")
TopalBaeMirrorAcctBudgetCcByClientDates [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")
TopalBaeMirrorBudgetCFByDates	code, dateFrom, dateUntil	Get budget CF of mirror account by code and dates	=TopalBaeMirrorBudgetCFByDates(1000;"01.01.2016";"31.12.2016")
TopalBaeMirrorBudgetCFByClientDates	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

TopalBaeKpiValueByDates	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")
TopalBaeKpiValueByClientDates	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")
TopalBaeKpiValueBySubNodeNameAndDates	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")
TopalBaeKpiValueBySubNodeNameAndClientDates	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")

Foreign Currency (FC)

Gets the Foreign Currency balance of an item.

Function

Parameter

Description

Example

TopalBaeBalanceFC	code	Get FC balance	=TopalBaeBalanceFC(1000)
TopalBaeBalanceFCByClient	Client, Code	Get FC balance by Client and Code	=TopalBaeBalanceFCByClient("Mon Bijou AG";1000)
TopalBaeBalanceFCByDate	code, date	Get FC balance by date	=TopalBaeBalanceFCByDate(1000;"01.01.2016")
TopalBaeBalanceFCByClientDate	Client, Code, Date	Get FC balance by Client, Code and date	=TopalBaeBalanceFCByClientDate("Mon Bijou AG";1000;"01.01.2016")
TopalBaeBalFcCcByDate [in Progress]	Code, CC, Date	Get FC balance of mirror account by Code, Cost Center and Date range	=TopalBaeBalFcCcByDate(1000;"Bern";"01.01.2016")
TopalBaeBalFcCcByClientDate [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")

Carried forward (CF)

Gets the balance/budget "Carried Forward" of an item.

Function

Parameter

Description

Example

TopalBaeBalanceCF	code	Get CF balance by Code	=TopalBaeBalCF(1000)
TopalBaeBalanceCFByClient	Client, Code	Get CF balance by Client and Code	=TopalBaeBalanceCFByClient("Mon Bijou AG";1000)
TopalBaeBalanceCFByDates	code, dateFrom, dateUntil	Get CF balance by dates	=TopalBaeBalanceCFByDates(1;"01.01.2016";"30.11.2016")
TopalBaeBalanceCFByClientDates	Client, Code, Datefrom, Dateuntil	Get CF balance by Client, Code and Date range	=TopalBaeBalanceCFByClientDates("Mon Bijou AG";1;"01.01.2016";"30.11.2016")
TopalBaeBudgetCFByDates	code, dateFrom, dateUntil	Get CF budget by code and dates	=TopalBaeBudgetCFByDates(1000;"01.01.2016";"31.12.2016")
TopalBaeBudgetCFByClientDates	Client, Code, Datefrom, Dateuntil	Get CF budget by Client, Code and Date range	=TopalBaeBudgetCFByClientDates("Mon Bijou AG";1000;"01.01.2016";"31.01.2016")

Budget

Gets the budget by Client, Code, Cost Center, Date range.

Function

Parameter

Description

Example

TopalBaeBudgetByDates	code, dateFrom, dateUntil	Get budget by code and dates	=TopalBaeBudgetByDates(1000;"01.01.2016";"31.12.2016")
TopalBaeBudgetByClientDates	Client, Code, Datefrom, Dateuntil	Get budget by Client, Code and Date range	=TopalBaeBudgetByClientDates("Mon Bijou AG";1000;"01.01.2016";"31.01.2016")
TopalBaeBudgetCcByDates [in Progress]	Code, CC, Datefrom, Dateuntil	Get budget by Code, Cost Center and Date range	=TopalBaeBudgetCcByDates(1000;"Bern";"01.01.2016";"31.01.2016")
TopalBaeBudgetCcByClientDates [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")

Client

Can retrieve information like code, city, street, zip of client also get current client name.

Function	Parameter	Description	Example
TopalClientCode	clientName	Get client code by name	=TopalClientCode("Mon Bijou AG")
TopalClientCity	clientName	Get client city by name	=TopalClientCity("Mon Bijou AG")
TopalClientStreet	clientName	Get client street by name	=TopalClientStreet("Mon Bijou AG")
TopalClientZip	clientName	Get client zip by name	=TopalClientZip("Mon Bijou AG")
TopalCurrentClientName		Get current client name	=TopalCurrentClientName()

Login

Function	Parameter	Description	Example
TopalLogin		Show login window	=TopalLogin()
TopalLogout		Logout	=TopalLogout()

VAT Period

Sets the VAT Period by given Client, Period.

Function	Parameter	Description	Example
TopalSetGlobalVATPeriod	vatPeriod	Set current VAT period by date	=TopalSetGlobalVATPeriod(2016)
TopalSetGlobalVATPeriodByClient	Client, VatPeriod	Set current VAT period by Client and date	=TopalSetGlobalVATPeriodByClient("Mon Bijou AG";"01.01.2016")

Fiscal Year

Gets the previously or by date fiscal year and sets the fiscal year.

Function

Parameter

Description

Example

TopalGetPreviousYear	fiscalYearName	Get previous fiscal year name by current Fiscal Year name	=TopalGetPreviousYear(2016)
TopalGetPreviousYearByClient	Client, FiscalYear	Get previous fiscal year name by client name and current Fiscal Year	=TopalGetPreviousYearByClient("Mon Bijou AG";2016)
TopalGetFiscalYearDateFrom	fiscalYearName	Get fiscal year date from by current Fiscal Year name	=TopalGetFiscalYearDateFrom(2016)
TopalGetFiscalYearDateFromByClient	Client, FiscalYear	Get fiscal year date from by client and current Fiscal Year	=TopalGetFiscalYearDateFromByClient("Mon Bijou AG";2016)
TopalGetFiscalYearDateUntil	fiscalYearName	Get fiscal year date until by current Fiscal Year name	=TopalGetFiscalYearDateUntil(2016)
TopalGetFiscalYearDateUntilByClient	Client, FiscalYear	Get fiscal year date until by client and current Fiscal Year	=TopalGetFiscalYearDateUntilByClient("Mon Bijou AG";2016)
TopalSetGlobalFiscalYear	fiscalYearName	Set current Fiscal Year	=TopalSetGlobalFiscalYear(2016)
TopalSetGlobalFiscalYearByClient	Client, FiscalYear	Set current Fiscal Year by client	=TopalSetGlobalFiscalYearByClient("Mon Bijou AG";2016)