Intermediate - How to Configure a Calculated Field in Printing Format
Calculated Field Usage
Calculated Fields are a custom field in the printing format editor that allows users to be able to customize fields to have certain values for example if user wants to be able to have a Subtotal of a sale to show with the discount amount of a sales.
They may use this approach to show combine two fields into one field to show the calculated total value
1.0.1 Example POS receipt format
From the following POS receipt format, example you would like to configure the Total Sales to show the original value with the discount as well.
You may user the following in the format below.
1.1 Configurating the Calculated Field
In the printing format find the fields in the screenshot which in this case should be the two below:
“Total Sales with Tax”
“Total Discount Amount”
- So the formula in this case we want to use is “Total Sales with Tax” + “Total Discount Amount”
You will then need to navigate to the data member of this fields which are under “Text”. - This can be accessed on the right pane from “fields list”
- Right click on an area under the Text Data Member and select the add calculated field option and click on it
- By default, the calculated field will always have a default name of “calculatedField#
- From there on you may select the calculated field and then right click on it and select the Edit expression Option as below
- This should open the expression editor above and you may start keying in the required fields for the formula
- Navigate to the fields section and then select the two fields required from earlier
- Add the operator of “+” in between the two fields
- Then click on the Ok button below to finalize the new field
- You may then add a new label in the format to use the following calculated field and then save the whole printing format to finalize the changes
- The results will be as the following below
Related Articles
Intermediate - How to Configure and Use Approval Settings in Purchase Orders (PO)
1.0 What is approval setting In general, "approval setting" refers to the configuration or process by which a request, action, or change must be reviewed and approved before it proceeds. The term is often used in business, software applications, and ...Basic - How to check if Item not printing in the Receipt
How to check if Item not printing in the Receipt **We assume that Printing format is no issue and only several item unable to print. Sample from Sales Invoice Sample from Point of Sales (POS) 1.1 Root cause why the item did not print in the receipt ...Basic - How to enable E-Receipt Portal and QR Code Setup on Printing format in Xilnex
Enable E-Receipt Portal Enable the E-receipt functionality Once Enabled, you will be getting the E-Receipt portal link Continue under Theme & Styling, enabled for the E-Invoice (LHDN) You can customize the look and feel of the E-Receipt portal ...Basic - How To Configure Walk-In Client Name
How to Configure Walk-In Client Name Change the Walk In Client Name in system configuration (system configuration > Sales > Walk In Client Name [All Outlets])Intermediate - How to Bill & Post to Sales from Transfer Note
1.0 Purpose A bill is required from transfer note when an inventory transfer involves financial transactions, cost allocation, or compliance with tax and accounting regulations. It is used when stock is moved between outlets that operate as separate ...
Recent Articles
Available Events: Xilnex Event Hub
Last Updated: 05 May 2026 Sales # Event Name 1 Create Sales 2 Confirm Sales 3 Confirm Sales v2 4 Complete Sales 5 Complete Sales v2 6 Cancel Sales 7 Update Sales 8 Cancel Sales Order 9 Confirm Sales Order 10 Complete Sales Order 11 Post Quotation to ...Integrating with Xilnex: Event Triggers & Webhook Configuration
Overview Xilnex Event Hub is an integration framework that enables your system to automatically dispatch real-time notifications to external applications whenever a defined business action occurs — such as completing a sale, creating a client, or ...LiveOrder New UI Announcement
LiveOrder — New Ordering Experience Now Available What's New? We're excited to introduce LiveOrder New UI, a redesigned ordering experience built to make ordering faster and easier for your customers. What's Changing — and Why It Matters We've ...How to Cancel an E-Invoice on Dashboard
Overview Sometimes cancelling an e-invoice is inevitable. Common situations include: Incorrect buyer information (e.g., wrong name, TIN, or address) Transaction was voided or order was cancelled after invoice issuance Duplicate e-invoice issued for ...Guidelines to Set Up Promotion for Walk-in (System Default)
Guidelines to Set Up Promotion for Walk-in (System Default) Previously, the system did not have a specific indicator for walk-in customers. As a result, all promotion rules applied equally to all customer types, including walk-in customers. However, ...
Popular Articles
Basic - How to create a voucher-coupon
Voucher and coupon definition Voucher can be generated in bulk and can be used once Coupon can only be created one at a time (reusable code) and can be use multiple times Pre-voucher / coupon setup There are 2 things need to be prepared before we can ...Understanding DuitNow QR Payment in ClassicPOS
Introduction This document introduces the DuitNow QR payment feature available in the Xilnex Retail POS, enabling merchants to accept payments conveniently through Malaysia's national QR payment standard. The integration of DuitNowQR simplifies the ...Basic - How to change custom cost to another branch that don’t have custom cost
Change custom cost to another branch that don’t have custom cost 1. Get the item list from the location with custom cost (Item Code, Name, Custom Cost) 2. Make sure the Show Location Price are selected 3. Export the item list in Excel 4. The file ...Intermediate - How to Bill & Post to Sales from Transfer Note
1.0 Purpose A bill is required from transfer note when an inventory transfer involves financial transactions, cost allocation, or compliance with tax and accounting regulations. It is used when stock is moved between outlets that operate as separate ...Basic - How to enable E-Receipt Portal and QR Code Setup on Printing format in Xilnex
Enable E-Receipt Portal Enable the E-receipt functionality Once Enabled, you will be getting the E-Receipt portal link Continue under Theme & Styling, enabled for the E-Invoice (LHDN) You can customize the look and feel of the E-Receipt portal ...