• Save Time and Avoid Loss: Essential Data Backup Tips

    Your data is vulnerable to various risks, such as hardware failures, cyberattacks, and natural disasters. Backing up your data and having those backups easily accessible is often the quickest, most affordable way to recover. In fact, backups may be your…
  • Recovery Time Objective RTO with Sage X3

    We are new to X3 and I watched the process of getting all the stuff installed. Our partner called in experts from each vendor to install their parts. We have x3, Datalinx, SEI with MSSQL. The total install time we were billed for exceeded 20 hours…
  • How do I join STOJOU to GACCCODE?

    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…
  • How can I go about joining the SINVOICED table to the STOJOU table?

    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…
  • SAGE x3v11 ACGGRP field description

    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…
  • SVG locked when arrived table AUDITL

    Hello, I run SVG all nigths at 21.00. When the proccess DOSSVG arrive to AUDITL table show this message: \AUDITL.dat can`t delete. And the proccess SVG is locked. Any idea or suggestion? Thanks!!
  • Best Practice of Sage X3 Backup

    Is there any best practice or document for Sage X3 PU9 or V11backup, like auto daily backup of entire Sage X3 including transactional database, MongoDB and application folder? My understanding here is we have to do the backup of 3 layers below manually…
  • SEI Subqueries

    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…
  • Disaster Recovery

    Is there any documentation outlining what needs to be backed up for Disaster Recovery? SQL backups are done, but what happens if the server is lost? What steps can one follow to recover a system having only the SQL backups?
  • Folder Backup for X3 including MongoDB and Syracuse Setup

    Hi All, Taking a backup of a folder is easy process in Sage X3 V6.5. We could extract to SVG and restore these onto the new folder. In V7 also this is possible for sure. But how can we get the back up of Mongo DB and Syracuse if we need to move into…