Sage X3 - Add a new custom field in Journal Entry

Add a new custom field in Journal Entry

This is to show  how you can add a new custom field in journal entry. 

Add new field in GACCENTRTYD table. 

Add this new field to screens GACCENT2, GACCENTR1, GACCENTR3, GACCENTW as below. Save and click validation for those screen with validation button enabled. 

GACCENT2 screen, (HAE2)

GACCENTR1 screen, (XAE1)

GACCENTR3 screen (HAE2) 

GACCENTW screen (HAEW)

Global Validation on the windows - OGAS & OGGSTD for the object GAS

Go to  Journal Entry Transaction  (under Setup –> Financials –> Journal entry transactions). Make the changes and save the record as below.

Logout & Login to test the changes.










Comments

Post a Comment

Popular posts from this blog

Sage X3 - Install and configure SMTP in IIS 6 by using gmail account

Image
Install and Configure SMTP in IIS 6 by using GMAIL Account You can use your gmail as relay server to allow email to be sending out from X3 workflow. To enable it, you need to turn on 'Allow less secure apps' in your gmail account setting. In order to use SMTP relay server Windows Server 2012 , you need to enable SMTP server and Telnet Client in Add roles and features wizard. Once SMTP installed, go to IIS6.0 Manager, select the IP Address. Go to Delivery tab, click on outbound security button. Enter your gmail account and password. Tick TLS encrytion.  On same Delivery tab, click on outbound connection button, change the port to 587.  Click on Advance button, change the smart host to smtp.gmail.com. You may reset IIS and start SMTP virtual server once it's done. To use Sage X3 workflow emailing, you have to login X3, set up parameters value, configure workflow rules and user assignment. Go to parameter values, select S
Read more

Sage X3 - Regenerate Syracuse Certificate

Image
There are some of the reasons that you need to regenerate Sage X3 Syracuse certificate, the reasons could be: 1. Expired of certificate 2. Uninstall or re-install of X3 Syracuse 3. Changes of server information 4. Incomplete, corrupted or missing of information in Certificate 5. Changes of password of SageRT (Granted administrator user running X3 services) The possible error below that you encountered below might required regenerate the certificate in order for you able to login Sage X3 again. 1. Cannot read passphrase file. Maybe it has been created under another operating user. 2. Error connect ECONNREFUSED. Here are the steps to regenerate certificate for Syracuse: 1. Go to Syracuse installation directory, <Syracuse>\syracuse\cert_tools. Make backup of output folder by rename it.Click on certgen.bat, this will open a command prompt. 2. Fill in all necessary information for Country, State, City, Organization, Organization Unit, Name and Va
Read more