What FlexCalc Solutions

Case SummaryApp Building

Unique Business Requirement

Understanding each business requirement is unique. It is no longer practical and efficient to offer standard software package to meet a wide range of user requirements, especially in the area of ​​calculation and related business logic.

Desktop Computing

The goal of FlexCalc Builder is to provide a suitable environment for building applications, while FlexCalc WebDesktop supports single-user, both support implementation on your desktop or laptop with our annual support services. However, this site provides free support services to anyone who needs self-service support by using published information.

FlexAccount Standard Accounting

FlexAccount 2020, in addition to providing a standard accounting software package with necessary customisation services, plays an important role for FlexCalc Builder when you need to deploy FlexCalc applications for concurrent users.

FlexAccount Custom Process

FlexAccount 2020 offers a new feature – Custom Process, which allows you to customise the screen of selection criteria directly. The Custom Process also allows you to interact many process executions with your Apps.

Accounting Practice

IFRSbox is one of the important websites that provides a very practical guide for accountants to implement certain accounting rules. This website focuses on how to implement and automate these rules in accordance with various scenarios in accordance with the requirements of your dynamic business.

Other than Accounting Practice

Whenever your built applications are not related to accounting or finance, you can implement them directly through the FlexCalc WebDesktop or FESA App Server with FlexCalc Server. The main difference from FlexAccount 2020, it does not provide a standard accounting software package.

Most Use Cases are Concise

In addition to the Command & Function Reference, this solution page is specifically written to solve various problem scenarios. To ensure ease of understanding, each developed use case and proposed solution is very concise, and their history of cases are linked.

Achieve Advanced Accounting Automation

Although the FlexCalc source code is compact, this website is one of the significant documentation projects in Accounting Practice. Here you will find a wide matching of business requirements for your goal – getting an advanced accounting automation anywhere since you can build Apps very quickly.

How to Use the Published Data

A lot the Excel Workbooks displayed here are not images. It is not recommended to download and execute files directly from the Internet. Whenever you need a specific application, you can create one or more Excel workbooks, and then copy the necessary data from the screen to your Excel workbook – for security purposes. Or you can request the purchase of disk version of your selected App from our sales department.

Solving Steep Learning Curve of ETL

Case SummaryApp Building

Solving Steep Learning Curve of ETL (1a)

Most ETL software requires a steep learning curve for accountants when accounting includes different calculation rules. Our main requirement is to demand for flexible approach to learning through success – each processing result can be seen only in a few steps of configuration.


Initially, you can focus on how to use the command below:-

Amend Data: This command allows you using source data table (e.g. Excel) to amend target data table (e.g. Data Building) by one or more matching columns.

DB Sub-folder = Ledger\Date is used to define data load to DB.Case1.Fact(Data) by sub-folder “Ledger\Data”.

% Match – definition of the data modification rule, the minimum requirement is to specify the name of the DB Sub-folder plus optional column names. If an additional column is defined, for example, the Document number, the data amendment will also validate the existence of the same document number previously posted. Only the corresponding document number can be changed.

Select Data: Select Data is used to filter records from source data table (e.g. Data Building) by one or more filter settings, match records will be copied to target data table (e.g. Excel).

Select data will extract data from DB.Case1.Fact(Data) to Excel(Case1Output.xlsx,Report) which includes records:-

  • Ledger = L01
  • Product = Crystal
  • Amount >3,000 and Amount <50,000

Recycling Unstructured Data

Case SummaryApp Building

Recycling Unstructured Data (1b)

An analysis of the personnel appraisal document shows that, despite the fact that our company implemented tier 1 ERP software, every year finance staff spent a significant amount of time managing unstructured data, tedious tasks included data entry and copying, less time on financial data analysis.


Having studied Solving Steep Learning Curve of ETL (1a), you can copy the data file and change it to different layouts to check if the same setting can process the files.

You may success or not success. It may due to you have change column name of these layouts. If you want to maintain the column name of the Data Building storing your fact table, you can learn how to use below command.

Map Column: When column names of source data are not identical with common columns of target data, Map Column allows you to configure each pair of column name mapping.

DT(Data) is used to keep extracted data in memory temporary for using by subsequent command i.e. Amend Data.

Also See Excel Connector to learn about Different Layouts

Foreign Currency Transaction

Case SummaryApp Building

Foreign Currency Transaction (1c)

Files are sent from foreign branches, each transaction is indicated in foreign currency. During consolidation, every time I have to convert it to a Hong Kong dollar at a daily exchange rate.


You can learn how to use the JoinTable function. If you need to add a new column, for example, the exchange rate for your data, you can use the JoinTable function with the  Compute Column command. In addition, using Multiply function and Round function are also necessary to complete your exercise.

Step 1: Insert Compute Column

This command supports you to effect different kinds of calculation rules with referring to column names of source data table or given values, in order to support generation of new or replace column values of target data table.

Step 2: Insert %JoinTable(ExRate) & %Multiply(Original Amount, Exchange Rate,Round2)

These two command functions are used to obtain the appropriate exchange rates with reference to the corresponding date and currency data and to multiply the initial amount by the exchange rates.

Step 3: Configure Exchange Rate Master Table (Click to Next Worksheet of below Workbook)

For testing, you can use the following CalcRule file with the insertion of a new worksheet named JoinTable.ExRate, where JoinTable is a required worksheet prefix “JoinTable.”, and ExRate is a user-defined table name. This table name must be matched the name of the %JoinTable(TableName).

Solution 1 Part 2