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:

  1. Physical report does not exist in the folder
  2. Missing default values

Resolution:

  1. A copy of the report not only needs to be in the report dictionary but also needs to exist in the folder on the server.
  2. Create/copy default values  for your crystal report


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

Application: Sage X3 People

Version: U9 patch 5

 

  1. Open Setup, General parameters, Parameter values.
  2. 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 send workflow email notifications. This field can be left blank if local email client is to be used to send workflow emails.

    TRAMEL – This parameter determines whether workflow logs are to be enabled or disabled.

    TYPMES – This parameter determines the default email sending mechanism. The possible options are:

    Server: Choose this option if SMTP Server is to be used to send workflow mails. SMTP server Hostname or the IP address must be specified the in the SERMES parameter.

    Client: Choose this option if the local email client (e.g. Outlook mail client) credentials is to be used to send the workflow emails.

    WRKRMTDIR – We need to specify the WORKFLOW directory path that on the webserver. This is the path where workflow replies will be stored for batch execution.

    WRKRMTHTTP – This is the X3 webserver machine name or IP address, with the relevant port number (e.g. 28880) and the X3 workflow process name AdxWfC (this name is case sensitive).

    WRKRMTMAC – This is the X3 webserver Hostname or the IP address along with the X3 Runtime service port number (e.g. 1802).

    WRKSINTER – This is the X3 webserver URL which can be accessed over the internet

    WRKSINTRA – This is the X3 webserver URL that can be accessed within the LAN (intranet)

    Hope this blog on Workflow parameters would help you in tuning your workflows as desired.

  3. Verify that you have an email server entered for parameter SERMES.
  4. Click OK.
  5. Click on Action button for RPT Group.
  6. Verify that ASAIDEST parameter is set to No.
  7. Open Setup, Workflow, Workflow rules.
  8. Select EMLPAY workflow and create a new workflow called EMLPAY2 , by coping EMLPAY.
  9. Set the condition on the workflow to only run when your Employee Payslip report is printing(in this example it’s ALLPAYSLIP)
  10. Click on Recipients tab and add Employee to the recipients, similar to below,( note this will email to the employee).
  11. On the Message tab, verify that GFILPATH is set under attached documents.
  12. Save and Validate.
  13. Open Personnel Management, Employee, Address Tab, Detail Section and Email ensure the employee has a valid email address
  14. Go to Report, Payroll Management
  15. Select ALLPAYSLIP report( this is the report we set as part of the workflow)
  16. Choose output of Message.
  17. Click Print.
  18. Your Employee would receive an email with the attached payslip

 


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 several criteria.

 

This screen allows you to:

  • Select the payslips to sent by email by entering criteria for the company, the site, the department, the profile, the employees and the population.
  • Specify the dates of the payslips. It is possible to send more than one payslip by pay date for the same payment month.

To send the Pay slip by email, the follow criteria must be fulfilled:

  • The pay slip status must be calculated or printed;
  • The Setup must be completed.

At the end of the process, a log file displays the report of the generation.

 

 


How to manually unlock a code file

When you open a code file in the Sage X3 People internal editor (function ADOTRT), Sage X3 people locks the file to prevent simultaneous modification. When you close the file, the lock is released. But if you experience an unexpected exit from the system while you have a file opened in the editor (for example, due to power failure), the file lock might not be released. In this case, when you open the file again, you will see a warning message and the file will be in read-only mode.

In such situations, to release the lock manually you have to delete a temporary file that X3 People creates to mark the code file as locked. This temporary file has the same name as your code file and an extension of ‘LCKsrc’. For example, if you open the SPEPOH code file, X3People will create a temporary file called ‘SPEPOH.LCKsrc’.

The temporary file is created in the same directory as its corresponding code file. This is usually the TRT subdirectory of your X3 People folder. To release the lock, all you have to do is delete the temporary file (be careful not to delete the .src and .adx files of the same name!)