Sage X3

Please excuse my ignorance, but I'm trying to read some scripts in X3 and I'm wondering what the '!' before a function or command means. Also, can anyone confirm if the : is an end of line notation? I'm looking for 4gl language references that might…

Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…

A stock movement ran into an error and it made the quantity stuck in the CUMWIPQTY column. How do I get the product to be released from this column?

Hi Sagians, We have around 5000 locations to create. I have checked the default import template but couldn't find any. I have created my own template but it is not working. Below is my template. If Any one have idea please share..

Hello We share same infrastructure with another company. They got IT, not my company. Their IT refuse me to use crystal report and access database for security. So we do Microsoft Word for all Invoices, Orders, etc. Like t min per Word to do all…

We have our DOSSVG running as a nightly process on the batch server. For some reason, our SVG backups are failing because of the error popenw32. Anybody have any ideas as to why this is happening?

Have any Business Partners in Australia been able to successfully setup and import using the Advanced Bank Statement Import function in V12. Every demo I goto the users all say that simple products like Xero have import from australian banks and I am…

Hi, I have a problem with one of the folders on my solution - I receive an error message when I try to open any function: Thank you in advance for any clue where I should looking for a cause of this problem.

This error comes up anytime I try to validate any table. Please has anyone encountered this before?

Can sage send data to a webhook? If so, could you elaborate on the process for this? Thanks, Chris

From experience, doing a data extract (to SVG) while users are in the system works, but users report that X3 performs very poorly or not at all for the duration of the SVG. The 'spinning wheel' shows on screens when attempting to open / save records.…

Sage X3 Version 6.5 Patch 29 We have done a server migration. Installed Sage X3 v 6.5 on new server. Imported the folders +svg from old server On the new server when we log on to Sage we get the error message below. “@X3.TRT/TRTLIC$adx…

I am looking for solutions to copy our sage x3 production folder either nightly or live sync to another folder in the database. This backup/synced database should be accessible through sage as well for testing, always with up to date information (nightly…

Hello guys, Someone can tell me please if it's possible to invoke an external webservice (soap) using 4GL ? I don't find any information here about this subject. Thanks

We are on version 11 patch 9 I created a table and a custom import template: The first record is always created (after I RTZ the table) but instead of creating all of the other records it insists on updating them instead. Here is the error received…

Hi I have to import a file but as soon as I go over a certain number of lines, I get an error Maximum number of lines exceeded. I have changed the activity code to increase the lines and also the number of records on the GACCENTRY,GACCENTRYD and GACCENTRYA…

I was wondering if a sales order is locked by a user, is there a field on the database that will show that this order is locked?

Good Morning Sage City - Upgrading my companies V5 to V11 and trying to move over Cost records.. I've been mostly successful until the Overhead / ITCNAT table came into play. I keep getting an error message that reads "The total of natures of expense…

Hi, I'm trying to create projects (GESOPP) through REST Webservice.. I can create into OPPOR table but when I try to create for OPPORCRM (needed to be visible in GESOPP function) get the error message: "A Pre-sales or After-sales step must be…

Hi, While i'm creating a record due to some issue i lost the data in table maintenance ,can any one help me out to get lost data?

Hi , We are using Standard SIHFL (Sales Invoice Full) template but still we are facing issue which is showing error message as ITMREF(1) mandatory field. We have only 1 line in the Invoice which we import. We tried with same template using exporting…

I am trying to pull data from three tables but running into a relation issues. Table1: Customer Table. Table 2: Invoice Table Table 3: Invoice Detail Table On table 1 the customer number column is "BPCNUM_0" On Table 2: The customer number column is …

Hi, I am not able to open any of the Sage X3 fixed asset screens. I am getting below mentioned error:: Table Access Error D:\Sage\X3V11\folders\X3\tmp\sqltrt1489.log Temporary files : D:\Sage\X3V11\folders\X3\tmp\sqltrt1489.sql D:\Sage\X3V11…

I guess most of us already needed to find a field on a table we sometimes found, but sometimes the result returned was empty. What most of the time occurs is that you are searching for the right field, but from the wrong place. To help you identify…