Browse By Tags

Hi there. There seems to be a de-synchronization between the product and its location. The product shows null quantity in the location. The location shows a quantity (59) but a null product and is "empty" Misc. issue and receipt is also messed…

I am trying to import/export BPs from one endpoint to another. However, when I import the file the BP numbers are chronologically assigned instead of keeping the same BP numbers from the exported file. Where do I go to adjust this?

The Sage Data Migration Tool (DMT) is designed to help streamline the import process, delivering a 50% to 60% improvement over standard import methods, reducing errors and saving time when importing into Sage X3. Sage DMT improves and simplifies the…

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

Hi everyone, I'm looking for the description of this field: Table - FXDASSETS field ACGGRP_0 Example: ACGGRP_0 CM The description must be similar, but I have not been found a table yet with this description, please someone has an…

Hello, It feels like I'm overlooking something simple, because tying lot numbers to our delivery records should be fairly straightforward. When I pull up a sample delivery record in Sage X3, I can select Stock lot and see which Lot number were included…

Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

Is there a definitive list for what is considered a special character?

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?

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?

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

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?

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…