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
E-Receipt Portal User Guide: Retrieve Sales, Enter Buyer Details, and Submit to IRBM
What is the E-Receipt Portal? The E-Receipt Portal is a web-based page provided by Xilnex that allows buyers (taxpayers) to claim a transaction and submit it to IRBM as an Individual E-Invoice for validation. Log in using the portal URL provided by ...Generate E-Invoice Submission Manually
Xilnex E-Invoicing is designed to run automatically once setup is completed. However, there are situations where you may need to manually generate an e-invoice to react promptly: Wrong setup or misconfiguration that prevented auto submission You ...Production Release (2025-01-05)
This release enhances e-Invoice compliance by enforcing Individual e-Invoice submission for high-value sales and selected classification codes. Release Date: 26 December 2025 Classic Release Classic Release Classic Version: 2.16.77200.251217.3 and ...Enforcing Individual E-Invoice for Classification Code
Under LHDN E-Invoice requirements, certain activities and transactions must be issued as Individual E-Invoices for each transaction, where consolidated E-Invoice submission is not permitted. For these activities, taxpayers are required to obtain full ...CX Builder Use Case 1: Setup Signup Get Voucher/Points/Credit
Use for loyalty app or lite applications, vouchers/points/credits will be auto generated to user after they successfully signup as members. Go to portal https://portal.xilnex.com/ Go to Customer Engagement>Customer Engagement Platform>Customer ...
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 ...