Sage ERP X3 Blog

Remove folder from Sage X3 Remove folder in Sage X3 folder. Go to Setup > General Parameters > Folders. Delete the unused folder. Manual remove all tables, views and sequences in SQL by r unning the queries below to get all the drop queries of tables, views and sequences. Select 'DROP VIEW ' + TABLE_SCHEMA + '.[' + TABLE_NAME+']' from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA in ('FOLDER') Select 'DROP TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME+']' from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA in ('FOLDER') Select 'DROP SEQUENCE  ' + SEQUENCE_SCHEMA + '.[' + SEQUENCE_NAME+']' from INFORMATION_SCHEMA.SEQUENCES WHERE SEQUENCE_SCHEMA in ('FOLDER') Execute Drop queries from VIEW, TABLE and SEQUENCE. Once done, run the queries below to remove user/schema/login. Drop Schema FOLDER Drop User FOLDER Drop User FOLDER_REPORT DROP LOGIN FO...

How to increase Journal Entry screen size in Sage X3  This is to show you how to increase the screen size in Sage X3 and apply the new screen size in entire application. Scenario:             Customer would like to import journal entry lines with more than default of 300 lines.                            Look at journal entry screen dictionary, there’s GAS activity code control the size of the grid. Jump to the GAS activity code from the screen dictionary, change the default screen size to for example 1000.  It will prompt this message. What you need to do is rerun the dictionary validation for ‘GAS’ activity code, to make sure this new size apply to all transactions. Go to Development > Utilities > Dictionary > Validations > Dictionary, select ‘Complete’, then ...