Customize Business Software |Best Accounting System | SQL Account HQ

SQL Suite Customization

Put Your Business Ideas to Work


Revolutionize Your Business with
SQL Suit Customizable Cloud Technology

Having hard time finding a solution that offers both customizable workflows and on-the-go accessibility?

Look no further than SQL Cloud Accounting. Our powerful solution allows you to unleash the full potential of your growing business, without having to sacrifice either customizable workflows or the ability to access your data from anywhere, at any time. SQL Business Suite offers highly scalable and dependable business solutions that are a game-changer for taking your business to new heights and unlocking its full potential.

Don’t just take our word for it โ€“ check it out why over 250,000 companies trust our popular and in-demand catalog of customization options. From commission rewarding to operation customization, preventive customization and more, we offer everything your business needs to succeed. Our suite of customizable workflows is tailored to meet the unique needs of your business and take it to new heights.

SQL Customize Catalogue

Search Title
Category
Product
Module
Reset

READY TO TURN YOUR BUSINESS IDEA INTO A REALITY?

SQL Cloud Accounting is the key to your business's success.

Contact us today and let our team of experts help you build your digital business world. We will work with you to create a tailored solution that fits your business’s specific needs.ย 

Send Inquiry

Try it for free!

Download brochure

Customization Tutorial

Malaysia's first accounting software provide step-by-step custom tutorial videos.

We understand that customization can seem daunting, which is why SQL Account provides detailed, step-by-step tutorial videos. These resources are designed for users with programming knowledge and cover the essential aspects of customization, such as:
  • Editing and creating reports.
  • Writing and implementing custom scripts.
  • Testing and verifying changes to ensure they work as intended.
  • Applying design changes to enhance usability.
These self-learning tools empower you to take full control of your accounting system.

Important Considerations
Customization is a powerful tool, but it also comes with responsibilities. Itโ€™s essential to:
  • Test Thoroughly: Any changes or customizations should be extensively tested to avoid disruptions.
  • Document Modifications: Keep track of all customizations for easier troubleshooting and updates.
  • Seek Expert Help When Needed: While our tutorials are comprehensive, some customizations may require professional expertise. Our team is always available to provide specialized assistance for a fee.

The Benefits of Customization
  • Efficiency: Streamline operations and save time by automating manual processes.
  • Accuracy: Reduce errors by tailoring the software to match your exact requirements.
  • Flexibility: Easily adapt to changing business needs without replacing your software.
  • Cost-Effectiveness: Invest in a solution that grows with your business, eliminating the need for frequent replacements.

Professional Support for Advanced Customization
While our tutorials offer a wealth of knowledge for self-learning, we understand that not every business has in-house programming expertise. For advanced customization needs, our team of professionals is ready to assist with fee. From detailed consultations to implementation, we ensure that your software works exactly as you envision.

Get Started Today
Whether youโ€™re looking to adjust a simple report or completely overhaul your accounting workflows, SQL Account provides the tools and resources you need. Explore the possibilities with our easy-to-follow tutorials, and unlock the full potential of customizable accounting software tailored specifically for your business.

Transform the way you manage your finances with SQL Accountโ€”the accounting software that adapts to you, not the other way around.

Flamerobin

FlameRobin is a tool specifically designed for accessing Firebird databases.

DIY Field

SQL Accounting Software comes with the great features of DIY Fields modules, it allowed you to create unlimited data fields, you can create any type of fields that suit your business nature, such as data field, date field, memo field & more!


SQL DIY Fields can be created in any documents entry in SQL, such as maintain customer, quotation,
invoices & more!

Customization Report

Customizing reports in SQL Account and Payroll allows you to display information tailored to your specific business requirements.

Videos
Report Builder (rtm)

Calculation using Variable

This tutorial will cover the five key data types in Report Builder and provide a step-by-step guide on performing a simple calculation to determine the unit price after applying a discount.

Capture Column From Database
using Variable

This tutorial will guide you on how to retrieve Shelf information from the Maintain Stock Item module and display it in a report.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:20 Introduction
00:2100:50ย  Step 1 : Open the Report in Report Builder
00:5102:29ย  ย Step 2 : Write SQL Query
02:3002:39ย  Step 3 : Save as New Report Name
02:4002:52ย  Step 4 : Preview the Report

Sum Total Using Variable

Today’s tutorial will guide you on how to use a Variable to calculate totals, such as the Total Quantity or Total Tax Amount.

String Replace Function using Variable

In this step by step tutorial for beginner, learn how to use the string replace all function in report builder.

StringReplaceAll function which is used to replace specific text.

For this video, weโ€™ll show how to change the report amountโ€™s English currency word from โ€œCentsโ€ to โ€œSenโ€, by this end of video, you’ll have a solid understand how to use the StringReplaceAll function.

Time Stamps
00:0000:16 Introduction
00:1701:15ย  ย Explanation on StringReplaceAll Function
01:1602:12ย  ย Replace English Currency Word from Cents to Sen

Display Data by Different Component

In this step by step tutorial for beginner, you will learn how to work with SQL queries to display data and interact with various components, including Label, Memo, RichText, Barcode and Image.

๐‹๐š๐›๐ž๐ฅ
๐ŸŒŸLabel are normally used to display short text.
๐ŸŒŸIn this Tutorial, we will show you how to capture shelf information using a Label Component.
๐ŸŒŸLabel is to display the data at Text.

๐Œ๐ž๐ฆ๐จ
๐ŸŒŸMemo are normally to print multiple lines of plain text in a report like Description, Description 2 and etc.
๐ŸŒŸIn this tutorial, we will show you how to display more descriptions in plaintext using Memo Component.
๐ŸŒŸMemo is to display the data at ComponentName.Text

๐‘๐ข๐œ๐ก๐“๐ž๐ฑ๐ญ
๐ŸŒŸRichText is used to display formatted text in reports, such as Notes or More Descriptions.
๐ŸŒŸIn this Tutorial, we will show you how to capture Maintain Stock Item Note to display using a RichText Component.
๐ŸŒŸRichText is to display the data in ComponentName.RichText

๐๐š๐ซ๐œ๐จ๐๐ž
๐ŸŒŸBarcodes render data in machine-readable formats for inventory tracking and scanning.
๐ŸŒŸIn this Tutorial, we will show you how to capture Maintain Stock Item Barcode to display using a Barcode Component.
๐ŸŒŸBarCode is to display the data in ComponentName.Data

๐ˆ๐ฆ๐š๐ ๐ž
๐ŸŒŸImage is used to display bitmaps and Windows metafiles in reports.
๐ŸŒŸIn this Tutorial, we will show you how to capture Maintain Stock Item Image to display using a Image Component.
๐ŸŒŸImage is to display the data in ComponentName.Picture

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:11ย  Introduction
00:1201:06ย  ย Label
01:0702:07 Memo
02:0802:53ย  RichText
02:5403:43ย  Barcode
03:4404:22ย  Image

Get Data From Available Pipeline

In this step by step tutorial for beginner, learn how to retrieve the available pipeline from the RTM Report.

The available pipeline allows you to extract report data from an existing report table and reform using SQL language. This includes action like sorting column or grouping as a new pipeline tailored to your specific needs.

In todayโ€™s tutorial, weโ€™ll teach you on sorting invoice reports by delivery date and item code, such as arranging invoices from the earliest to the latest. By default, reports display data in the order they were entered.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:36 Introduction
00:3701:03ย  Declaration Variable
01:0401:51ย  ย  Procedure GlobalOnCreate
01:5201:55ย  ย  Procedure ReportBeforePrint
01:5603:03ย  ย LocalSQLSelect
03:0403:07ย  SetDataPipelineFieldLink(Optional Step)
03:0803:25ย  Example of Data Pipeline FieldLink is not required
03:2605:31ย  ย Example of How to set Data PipelineFieldLink
05:3205:46ย  Result

Get Data Directly From Database

In this step by step tutorial for beginner, we’ll show you how to get Data directly from the database in RTM Report. This approach is similar to using the Available Pipeline. If youโ€™re not familiar with the Available Pipeline, refer to ย ย  โ€ข Report Builder (RTM) – Get Data From Available Pipeline

๐Ž๐ฏ๐ž๐ซ๐ฏ๐ข๐ž๐ฐ ๐Ÿ๐จ๐ซ ๐†๐ž๐ญ ๐ƒ๐š๐ญ๐š ๐Ÿ๐ซ๐จ๐ฆ ๐€๐ฏ๐š๐ข๐ฅ๐š๐›๐ฅ๐ž ๐๐ข๐ฉ๐ž๐ฅ๐ข๐ง๐ž ๐ฏ๐ฌ ๐†๐ž๐ญ ๐ƒ๐š๐ญ๐š ๐๐ข๐ซ๐ž๐œ๐ญ๐ฅ๐ฒ ๐Ÿ๐ซ๐จ๐ฆ ๐ƒ๐š๐ญ๐š๐›๐š๐ฌ๐ž
Before moving forward, letโ€™s quickly review the difference between using the Get Data from Available Pipeline vs Getting Data Directly from the Database.
The Available Pipeline retrieves data from a predefined data pipeline within the report table, such as sorting by delivery date or item code.
In contrast, Getting Data Directly from the Database gets data directly from SQL table, often using fields like Code to track additional details. This method is ideal for retrieving information not included in the predefined pipeline, such as batch details from Maintain Batch or BOM components in stock items etc.

In todayโ€™s tutorial, weโ€™ll show you ๐ก๐จ๐ฐ ๐ญ๐จ ๐๐ข๐ฌ๐ฉ๐ฅ๐š๐ฒ ๐ญ๐ก๐ž ๐ฌ๐ญ๐จ๐œ๐ค ๐›๐š๐ญ๐œ๐ก ๐ž๐ฑ๐ฉ๐ข๐ซ๐š๐ญ๐ข๐จ๐ง ๐๐š๐ญ๐ž ๐ข๐ง ๐ญ๐ก๐ž ๐’๐š๐ฅ๐ž๐ฌ ๐ˆ๐ง๐ฏ๐จ๐ข๐œ๐ž ๐‘๐ž๐ฉ๐จ๐ซ๐ญ using the Get Data Directly from Database method.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:14 Introduction
00:1500:44 Overview for Get Data from Available Pipeline vs Get Data directly from Database
00:4500:52 Get Maintain Batch Table directly from SQL Database
00:5301:13 Declaration Variable
01:1401:37 Procedure GlobalOnCreate
01:3802:22 Procedure ReportBeforePrint
02:2303:49 Set DataPipelineFieldLink
03:5004:08 Result

DateTimeToString Function

In this step by step tutorial for beginner, learn how to use the DateTimeToString function in report builder.

DateTimeToString function used to convert a date and time value into a string format for use in SQL queries.

For this video, weโ€™ll demonstrate how to use this function to capture the total outstanding invoice amount for a customer up to Sales Invoice Date.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:20 Introduction
00:2100:44 Step 1 : Declaration Variable
00:4501:11 Step 2 : Explanation on DateTimeToString Function
01:1202:08 Step 3 : Construct SQL Queries
02:0902:48 Step 4 : Retrieve Query Results

Driver Commission Report

In this step by step tutorial for beginner, learn how to create a Driver Commission Report for the Month in Sales Invoice Listing.

This report calculates the commission rate as long as the invoice is created, with no payment required. The driver commission is calculated per trip, and each item will have its own commission rate.

Summarize the information as below :
Location as the Driver Name,
Commission Rate from Maintain Stock Item,
Formula calculate the commission = Commission Rate x Quantity.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:32 Introduction
00:3301:26 Step 1 : Create DIY Field & Brief on Default Sorting
01:2701:58 Step 2 : Create Available Pipeline – Sort by Location
03:5705:06 Step 3 : Change Report Data Pipeline to newly created pipeline
05:0705:30 Step 4 : Set Group by Location Custom Field
05:3106:53 Step 5 : Adjust Component Position and Add a New Label
06:5407:29 Step 6 : use Variable capture Due Date from Customer Invoice
07:3010:02 Step 7 : Commission Rate Calculation
10:0310:34 Step 8 : Variable Calculation Sequence
10:3511:03 Step 9 : Use DBCalc to Sum Up Field
11:0413:02 Step 10 : Create Available Pipeline – Capture Description from Document_Location

Fast Report fr3

Basic Guideline for Creating a
Simple Sales Invoice Format

In this step by step tutorial for beginner, you’ll learn about the commonly used components for designing reports and how to create a simple Sales Invoice format.

๐Ÿ’ŽUnderstanding Report Object Toolbar
The Fast Report Designer represents reports as a collection of schematic pages. Objects are placed anywhere on the report pages and are used to define the report’s appearance and to display various information, such as text and graphics.

๐Ÿ’ŽUnderstanding Bands
Bands are one of the most important concepts in Fast Report.
โœจThe Group Header is a grouping header that prints on every page.
โœจThe Master Data represents the main dataset of the report.
๐ŸŒŸThe Detail Data section is used to display all item details.
โœจThe Group Footer functions as the grouping footer and appears only on the last page.
โœจThe Page Footer is displayed on every page of the report.

๐Ÿ’ŽPrint position, Stop position and Print count
โœจ Print Position determines where the Group footer will be printed on the page.
โœจ Stop Position defines where printing should stop, detail will stop at the input value.
โœจ Print Count specifies how many number of item records inputs should be printed.

๐Ÿ’ŽCreating a Invoice Report
Step 1 : Choose the appropriate report
Step 2: Add a Picture.
Step 3: Add Customer Email Address.
Step 4: Add a Note.
Step 5: Add a Sum of Quantity.
Step 6: Draw a Line for Better Formatting.
Step 7: Center Objects Horizontally in the Band.
Step 8: Align Objects.
Step 9: Save and Preview the Report.

๐Ÿ’Ž Alignment Toolbar
โœจ Align Left aligns the left edges of all selected objects to the first selected object.
โœจ Align Middle aligns the horizontal centers of all selected objects to the first selected object.
โœจ Align Right aligns the right edges of all selected objects to the first selected object.
โœจ Align Top aligns the top edges of all selected objects to the first selected object.
โœจ Align Centre aligns the vertical centers of all selected objects to the first selected object.
โœจ Align Bottom aligns the bottom edges of all selected objects to the first selected object.
โœจ Space Horizontally distributes the selected objects evenly along the horizontal axis.
โœจ Space Vertically distributes the selected objects evenly along the vertical axis.
โœจ Centre Horizontally centers each selected object individually within its horizontal band.
โœจ Centre Vertically centers each selected object individually within its vertical band.
โœจ Shrink/Grow Width adjusts the width of all selected objects to match the first selected object.
โœจ Shrink/Grow Height adjusts the height of all selected objects to match the first selected object.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:15 Introduction
00:1602:07 Part 1 : Understanding Report Object Toolbar
02:0803:10 Part 2 : Understanding Bands
03:1104:53 Part 3 : Print Position, Stop Position and Print Count
04:5405:07 Part 4 : Creating a Invoice Report
05:0805:28 Part 4 – Step 1 : Choose the Appropriate Report
05:2905:57 Part 4 – Step 2 : Add a Picture
05:5806:26 Part 4 – Step 3 : Add Customer Email Address
06:2706:54 Part 4 – Step 4 : Add a Note
06:5507:20 Part 4 – Step 5 : Add Sum of Quantity
07:2107:35 Part 4 – Step 6 : Draw a Line for Better Formatting
07:3608:52 Alignment Toolbar
08:5309:12 Part 4 – Step 7 : Center Objects Horizontally in the Band
09:1309:37 Part 4 – Step 8 : Align Objects
09:3809:54 Part 4 – Step 9 : Save and Preview the Report

Simple Calculation Using Memo

In this step by step tutorial for beginner, learn how to add a simple calculation using a Memo to your FR3 report. Specifically, weโ€™ll focus on calculating the unit price after applying a discount.

Formula to calculating the Net Unit price = Amount / Qty

FormatDateTime Function

In this step by step tutorial for beginner, learn how to use the FormatDateTime function in fr3 Report, which is used to convert a date value into a string format for use in SQL queries.

For this video, weโ€™ll demonstrate how to use this function to capture the total outstanding invoice amount for a customer up to Sales Invoice Date.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:22 Introduction
00:2300:33 Step 1 : Declaration Variable
00:3401:06 Step 2 : Explanation on FormatDateTime Function
01:0701:52 Step 3 : Construct the SQL Query
01:5302:33 Step 4 : AddDataset and LinkTo Methods
02:3402:53 Result

Customization Script

Customizing scripts in SQL Account allows you to automate and extend the functionality of the software. Scripts are useful for tailoring specific business processes, such as creating automated tasks, performing custom calculations for amounts, and more.

Videos
DIY Script

SQL Account SDK

SQL Account Software Development Kit (SDK) is a collection of software tools and code samples that helps developers build applications for a specific platform, framework, or service.

It provides a list of available objects and sample coding that you can integrate and call from DIY script.

In essence, an SDK simplifies the development process by providing the necessary components, making it easier for developers to build software that works with specific technologies or services.

DIY Script Event

Welcome to tutorial video on the SQL DIY Script Event. Today will brief on SQL DIY Script Event.

The SQL DIY Script empowers you to create your own scripts directly within an event list in our SQL software. This versatile feature enables you to customize the software to meet your specific needs, from commission rewards and operational adjustments to preventive measures and beyond.

OnGridColumnValueChanged

In this step by step tutorial for beginner, weโ€™ll guide you through the process of using the OnGridColumnValueChanged event to tailor calculations for your business operations. This event is particularly useful in scenarios like a Sales Module, where you need to automate the calculation of amounts based on your business-specific requirements.

๐–๐ก๐š๐ญ ๐ข๐ฌ ๐ญ๐ก๐ž ๐Ž๐ง๐†๐ซ๐ข๐๐‚๐จ๐ฅ๐ฎ๐ฆ๐ง๐•๐š๐ฅ๐ฎ๐ž๐‚๐ก๐š๐ง๐ ๐ž๐ ๐„๐ฏ๐ž๐ง๐ญ?
๐ŸŒŸ OnGridColumnValueChanged event triggers the script whenever a value of a cell or column in a grid (such as a data grid or table) is changed.

๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ ๐Ž๐›๐ฃ๐ž๐œ๐ญ๐ข๐ฏ๐ž
๐ŸŒŸ We will show you how to write a DIY Script using the OnGridColumnValueChange event for travel agency business, such that it can be used to auto calculate the amount charges for hotel room.

๐…๐จ๐ซ๐ฆ๐ฎ๐ฅ๐š ๐Ÿ๐จ๐ซ ๐’๐ฎ๐›๐ญ๐จ๐ญ๐š๐ฅ ๐‚๐š๐ฅ๐œ๐ฎ๐ฅ๐š๐ญ๐ข๐จ๐ง
๐ŸŒŸ The formula for the Sub Total Amount is =(Room Rate Per Night)ร—(Number of Nights)ร—(Number of Rooms) – Discount

๐‘๐ž๐ฌ๐ฎ๐ฅ๐ญ
๐ŸŒŸ The result of this script would achieve is whenever the user changed the value in the fields of Qty, Price, Night, and Discount, the amount will follow the formula and change accordingly.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:45 Introduction
00:4601:42 Create DIY Field
01:4302:11 Why need to create DIY Fields
02:1204:43 Function and Procedure
04:4405:09 SameText Procedure and Editing Field
05:1005:50 Field Name and Data Type
05:5106:26 Main Function
06:2707:18 Compile Script
07:1907:32 Show Message Procedure
07:3307:42 Ending Demo

TDataSource

In this step by step tutorial for beginner, learn how to use TDatasource to retrieve data from the form. TDataSource serves as a bridge between dataset components and data-aware controls on a form. It simplifies the process of binding data to UI elements and ensures smooth interaction between the database and the user interface.

In this tutorial video, we will guide you on how to use the TDataSource object in the OnBeforeSave event script to validate the Sub Total amount calculations. Such that, this script can ensure the amount would be recorded correctly according to the formula.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:17 Introduction
00:1801:16 Usage of TDatasource
01:1701:58 Tutorial of using TDatasource
01:5902:27 While Loop
02:2703:24 Main Function
03:2504:07 Ending Demo

TClientDataset

โœจ The TClientDataset holds a local, in-memory copy of the data and operates independently of the database connection after fetching the data. It can be used whenever you want to refer to other data stored in another table.

โœจ In this tutorial, we will guide you on how to utilise TClientDataSet in the OnGridColumnValueChanged event to retrieve the custom field value from the stock item.

โœจ The result of this script is that whenever the user calls out or changes the item code in the sales invoice detail, the custom field value from the stock item would be copied into a column of the sales invoiceโ€™s detail.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:18 Introduction
00:1900:41 Usage of TClientDataset
00:4201:14 Create DIY Field
01:1501:30 Create Quick Form
01:3103:11 Function & Procedure
03:1203:23 Main Function
03:2403:38 Ending Demo

In this step by step tutorial for beginner, learn how to use the TxQuery to query on local, using SQL statements.

TxQuery provides you the capability to use SQL query statement to query on a local, in-memory copy of the data. It can be used whenever you want to filter to the data stored in the TDataSet descendant component.

For this video, weโ€™ll show you on how to utilize TxQuery in the OnBeforeSave event to capture the total Qty in the invoice.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:17 Introduction
00:1800:32 Usage of TxQuery
00:3300:54 Create DIY Field
00:5501:13 Declaration
01:1402:09 Main Function
02:1002:24 Ending Demo

In this step by step tutorial for beginner, learn how to create the button in SQL Account.

With utilizing this TcxButton class, you can customize your interface at the Invoice or other documents to include an additional Button that can execute a certain task you given.

In this tutorial, I will guide you on how to utilise TcxButton in the OnOpen event to add a button in the Sales Invoice.

The result of this script is that whenever the user opens the Sales Invoice, the button will be created and resides beside the Button Move Down of the Invoice. And this button will function to sum up the Qty of all items in the invoice and display it in the browse table.

๐“๐ข๐ฆ๐ž ๐’๐ญ๐š๐ฆ๐ฉ๐ฌ
00:0000:14 Introduction
00:1500:36 Usage of TcxButton
00:3700:58 Create DIY Field
00:5902:03 Procedure
02:0403:10 Main Function
03:1103:35 Ending Demo

STEP 1: Scan QR Code to pay

SQL

STEP 2: Click here to email payment info