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])User Guide to Configure Biometric with SecuGen Hamster Pro HUPx
Introduction The Xilnex system supports biometric authentication using fingerprint scanners to enhance security and streamline employee login processes. Our platform now supports the SecuGen Hamster Pro HUPx fingerprint scanner, in addition to the ...
Recent Articles
Managing Lark User Email Mapping in Xilnex for Lark
Overview The Users card matches each Xilnex user to their Lark account by email. This is what lets features like Permission Approvals and Document Approvals deliver Lark cards to the right person. This article covers how to review the mapping and fix ...E-Wallet and Credit Card Payment - Recheck Status & Force Complete
This guide walks you through what to do when a payment goes through on the terminal or e-wallet, but Classic POS fails to commit sales. When Does This Happen? During payment, Classic POS will show a "Connecting to Ewallet party..." or processing ...E-Journal for BIR Compliance (Philippines)
Overview The E-Journal feature generates a .txt file that complies with BIR (Bureau of Internal Revenue) requirements in the Philippines. This feature is available only for the Philippines COM. Users from other countries' COMs will not be able to ...Disconnecting or Reconnecting Xilnex for Lark
This article covers how to disable a template, fully disconnect the integration from Lark, and reconnect it again. Disable a Template Turning a base off only stops that one base, everything else keeps syncing, and none of your existing data in Lark ...Creating a Base in Xilnex for Lark
Overview This article walks you through creating a base for a template, giving end users access to it in Lark, and verifying data is syncing correctly. Xilnex for Lark must already be connected before you start. If the Templates card isn't accessible ...
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 ...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 ...Buy 2 for Special Price Promotion
Use Case: Stock clearance, seasonal offers, or spotlight products. From the sample screenshot above, this promotion requires 2 items to trigger. If only 1 Milk Tea is added to the sales list, no discount will apply since the condition of 2 items is ...Creating Delivery Type for Sales in Classic POS
How to Create Delivery Type 1. Access to the [System Configuration] 2. Select the [Sales] section 3. In the [All Outlets] tab, look for the 'Delivery Type' 4. Click on the [Configure] In the Delivery Type Setup form: 1. Enter the Delivery Type. 2. ...