Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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…
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…
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…
One of the beautiful things about working on Sage ERP X3 is that the technology is always improving. I simply can’t wait for version 7 to come out. There will be an amazing new set of technological gadgets to play with. We will be HTML 5 for our client…
