Manipulate time and date: Sage X3

I will be discussing how to manipulate time and date in Sage X3. To get the current date in a Date variable , use the date function $ . In the same way, to have the current date and time in a Datetime variable , use the datetime function $ (only from U9). The canonical form to represent date and time with a string is: YYYY-MM-DDThh: mm: ssZ #attention […]

Continue reading


 HR Processes

The modern Human Resources Organization and the effective HR Management is based on strong, simple and effective HR Processes. The HR Processes are always divided into the functional areas and the HR Managers are responsible for the design, development and re-design of the HR Processes as the HR Strategy can be implemented.   The HR Processes are the […]

Continue reading


 Sage x3, X3 People – Crystal Reports error – NGPAY.rpt : Table does not exist

Sage X3 Application: Sage X3 , Sage X3 People, Crystal report Scenario: When running a crystal report either from Sage X3 ERP or Sage X3 People and you encounter an error like “XXXX.rpt: Table does not exist” Possible cause: Physical report does not exist in the folder Missing default values Resolution: A copy of the […]

Continue reading


 Crystal Report: Convert Amount to Words

Report Application: Crystal Report Version: 2013 Scenario: I have a field {ARIBH.AMTNETTOT} that has amount in figures and the client needs the amounts in words Solutions //extract Naira  only Propercase(ToWords(truncate({ARIBH.AMTNETTOT}),0) + ‘ Naira and ‘ + //extract the Kobo and convert to words Another formula for rounding up. ToWords(remainder({ARIBH.AMTNETTOT}*100,100),0) + ‘ Kobo Only.’)   Do […]

Continue reading


 How to setup a workflow to email payslip to employees: Sage X3 People

Application: Sage X3 People Version: U9 patch 5   Open Setup, General parameters, Parameter values. Expand SUP chapter and click on Action button for the WRK Group.Following are some of the important parameters and their descriptions:SERMES – We can specify the SMTP server Hostname or IP address here. This server will then be used to […]

Continue reading


 Sage X3 People:Training Management

Training management Sage X3 People training management module is a most have module for any organization that is interested in building her human capital to meet the evolving business environment. Training budgets: Budget wizard to define training plans and budget Training needs, requests, and auto detection Gross training costs calculation and budget control     […]

Continue reading


 Sage X3 People: Payslip by Email

This function in Sage X3 People allows to send to the employee the monthly payslips by email. This function can be used to send by email This function allows to send to the employee the monthly payslips by email. This function can be used to send by email payslips corresponding to several criteria.payslips corresponding to […]

Continue reading


 Sage X3: Disciplinary

Sage X3 people has a function called “Disciplinary(Sanctions) which enables HR personnel report misconduct incidents that happened during the year and to record potential employee’s appeal.   You can use the data to provide statistical reports to management and to identify specific trends of concern around misconduct or mismanagement issues that may need attention or further […]

Continue reading