FC

Gets the FC balance of Item.

TopalBaeBalanceFC("Code")

This Function returns the fc balance of the account or group based on a given Code.

Function call:
=TopalBaeBalanceFC("1000") or =TopalBaeBalanceFC("CellNo.")

Example:

Figure 1: return the fc balance of account

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalanceFCByClient("Client";"Code")

This Function returns the balance fc of the account or group based on a given Clientname and Code.

Function call:
=TopalBaeBalanceFCByClient("Mon Bijou AG";"1000") or =TopalBaeBalanceFCByClient("Client";"CellNo.")

Example:

Figure 2: return the fc balance of account by client

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalanceFCByDate("code";"date")

This Function returns the balance fc of the account or group based on a given Code and Date.

Function call:
=TopalBaeBalanceFCByDate("1000";"01.04.2016") or =TopalBaeBalanceFCByDate("CellNo.";"01.04.2016")

Example:

Figure 3: return the fc balance of account by date

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalanceFCByClientDate("Client";"Code";"Date")

This Function returns the balance fc of the account or group based on a given Client, Code and Date.

Function call:
=TopalBaeBalanceFCByClientDate("Mon Bijou AG";"1000";"01.04.2016") or =TopalBaeBalanceFCByClientDate("Client";"CellNo.";"Date")

Example:

Figure 4: return the fc balance of account by client, date

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalFcCcByDate("Code";"Cost Center";"Date") [WORKING PROCESS]

This Function returns the balance fc of the account or group based on a given Code, Cost Center and Date.

Function call:
=TopalBaeBalFcCcByDate("1000";"Bern";"01.04.2016") or =TopalBaeBalFcCcByDate("CellNo.";"Cost Center";"Date")

Example:

Figure 5: Account Name

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeBalFcCcByClientDate("Client";"Code";"Cost Center";"Date") [WORKING PROCESS]

This Function returns the balance fc of the account or group based on a given Code, Cost Center and Date.

Function call:
=TopalBaeBalFcCcByClientDate("Mon Bijou AG";"1000";"Bern";"01.04.2016") or =TopalBaeBalFcCcByClientDate("Client";"CellNo.";"Cost Center";"Date")

Example:

Figure 6: Account Name

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.