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 Update Client Record in Classic POS
Overview Updating client information is an essential function in ClassicPOS, enabling users to maintain and update existing client records. This ensures that client data remains accurate and up to date for daily operations, reporting, and effective ...How to Create a New Client in Classic POS
Overview This function is created to centralize and manage client information in ClassicPOS. The Client Form allows users to create, update, and maintain customer records, supporting the management of personal information, transaction history, ...POS Hold Bill Feature
Hold Bill Feature – Retail POS 1. Overview The Hold Bill feature allows cashier to temporarily save an ongoing transaction and resume it later. ✅ Enabled by default for Retail POS Designed to improve queue efficiency Prevents loss of sales when ...OAuth Project & Client Permission Management
Overview The OAuth Project & Client Permission module controls which roles can access, configure, and manage OAuth projects and client credentials within the system. Permissions are managed under System Configuration > User Roles Permission > All ...Xilnex Auth Integration Guide
Introduction Xilnex Auth implements OAuth 2.0, a widely adopted authorization framework that enables secure access to protected resources by issuing access tokens to client applications. This document provides a comprehensive guide on how to use ...
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 ...