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
How to Stop Xilnex E-Invoicing
Scenarios Requiring Xilnex E-Invoicing Deactivation Deactivate Xilnex E-Invoicing when a business falls below mandatory thresholds or ceases operations, ensuring compliance with IRBM guidelines while avoiding unnecessary module activity. This ...Xilnex E-Invoicing Document Split
Type Descriptions Product Xilnex E-Invoicing New Features E-Invoice Document Splitting Document Splitting Function Type Toggle Configuration E-Invoice Settings Required DB Upgrade No Release Date 13 August 2025 Background When a generated payload ...Connecting KDS 2.0 to POS
Xilnex ClassicPOS Important Notice: As of now, in order to use KDS2.0, Classic POS version must be at least version 2.16 July 2025 and above. 1. In System Configuration > select Device Configuration > under This Machine > look for Kitchen Display ...Congiure a Client KDS - Connect to a Host KDS
KDS Client A KDS Client Device in Xilnex KDS 2.0 is a display screen (such as a tablet, monitor, or smart TV) located at a specific kitchen station (e.g., Grill, Bar, or Cold Station). Its primary function is to receive and display orders sent from ...Configure A Host KDS Device
A Host KDS in Xilnex KDS 2.0 is the designated central hub device responsible for synchronizing and managing the entire kitchen network. It acts as the primary authority, ensuring that all orders from the POS system are correctly distributed to ...
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 ...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 ...Importing Usernames in Xilnex Portal
What is User Import? User Import allows you to add, update, or manage multiple users in bulk rather than handling them one by one. This feature is especially useful for onboarding new employees, migrating data, or making large-scale updates to user ...Configuring Web Report Access
How to Configure Web Report Access? 1. Click on "System Configuration" on the left side panel. 2. Scroll down to find "User roles permission" under Users & Roles section. 3. Click on "All permission". 4. Click on "More", then select "Menu (Xilnex ...