Author Archives: Greytrix

Guide to Setup X3 Recurring Journals

What is a Recurring Journal Entry? A recurring journal is a journal entry recorded periodically. The amount in the journal can be identical or varied depending on the requirement. For e.g. a payroll entry calculated for work done on hourly basis will have variable amount but identical accounts. Similarly a monthly rental expense can be… Read More »

How to Restrict data input in Sage X3

By just using different Options (Numeric or Alphanumeric) in X3, one can validate data as it is fed in the system to reduce mistakes and improve accuracy and consistency. All data types can be assigned a list of options for validating data when it is entered later on. Let’s take an example. If we assign… Read More »

Pattern Matching in Sage X3

You may often need to write a code that performs inexact pattern matching. The use of “PAT” allows you to find data that fits a certain pattern, rather than specifying the code exactly. New Stuff: Sage Introduces New Enhancements for Sage ERP X3 v6.5 (Patch 27) Syntax pat( expr_c, pattern ) Where “expr_c” is an alphanumeric… Read More »

Leveraging the Sigma Function Within Sage X3

In one of our last blog, we had seen the use of Calculator in Sage X3. Going further, we will now throw more light on the use and functionality of the same. New Stuff: How to remove spaces from a string To use the sigma formula, firstly we can open the calculator by pressing “Alt+Ctrl+k”. Also… Read More »