Sage X3

What is the best way to update planning work order material based on the updated BOM? There is no standard import template for MFGMAT. Users requested that they have three old components that is in 189 open work orders that "builds" phantom part# to…

Hello please should be informed that when i tried to import SEED Folder to console management all steps pass OK unless the last step it give error the impacted envirenement WIndows 2019 server SQL SERVER 2014 SAGE X3 V11 can you help plea…

Hi team, I need some assistance in resolving the unbalanced journal error I am getting when importing a file from Pastel. The import path am using is: More> Usage> Import> Table structuring/ Import. In the other post I saw that this might be related…

I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

On the customer screen, there is a default contact checkbox. Which table is this stored on? I cannot find it on CONTACT or CONTACTCRM table. On V11, Patch 14

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…

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…

Has anyone found a limit to the number of Screen Lines you can have an the BPA Activity Code (Number of BP addresses)? We have a customer with over 16,000 locations and our Customer Service team has asked if we can import them all. Currently we are set…

We have been investigating an odd issue at a customer site where we are unable to upload files as attachments or if we are doing an import. When doing the import, we select client & attempt to select the file and receive the message: file not found…

Is there a way to import lines of cycle count with the INV template? It sounds that the template can update qtys but does not allow to import new lines. Or is there any other template to do this? Thanks

Hi all, are there any default import export template for the object PJM in Sage X3 v11? I can't find it anywhere in my Sage X3.

How are subqueries performed in SEI without creating a custom DB view ? Creating an Order Shortage Report. I have a process that pull sinformation form the ITMMVT table in summary (Orders, Item info) but I need to join to the ORDERS table to find…