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 »