• Default Locations

    I want to mass update all the existing products with their respective locations. However, when I am trying to export default locations along with the types, i don't know how to export multiple types. Upon exporting only receipt is getting exported. See…
  • Import of miscellaneous receipts for inventory

    We are importing inventory receipts into a new warehouse. We are using the import template FTIMSR. It works fine. The issue we are having is dealing with errors and the subsequent creation of multiple misc receipt records in Sage X3. If we build a long…
  • Encounter error when running Stock Accounting Interface

    Upon running the Stock Accounting Interface interface, I consistently encounter the following error: SOOCKSE22006354 Nonexistent dimension value (STKIS Line 3) Miscellaneous issue VCRNUM=MIOCKSE23003691 Upon thorough investigation, it has come to my…
  • Having error while using BIS import template to import file

    I am having problem while import using BIS import template, there is error on DUDDAT field. But when using import simulation, DUDDAT can get the value from my import file. Is anyone facing this problem or anyone can advise me on this? The attachment below…
  • 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…
  • Webscheduler 2016_SP9_UP4_1 Sagex3 interface

    Hi, I have a problem to load data into Analytics from X3. The logfile for the service: at INTERFACE_SAGE_SERVICE.Service1.OnTimedEvent(Object source, ElapsedEventArgs e) [1/25/2021 9:49:26 AM]Creating Json... [1/25/2021 9:49:26 AM]URL: XXXXX.XXXXX…
  • V12 Folder Copy Via Console

    Hello, I am trying to copy our production folder using the copy function in the console. I have tried it twice and each time, it finishes and I can create the endpoint, but there are several tables that do not get loaded into the DB. There doesn't appear…
  • Purchase Order import - sequence numbers

    Is it possible to import purchase orders and assign the PO number at the time of import. These PO's are coming over from the retired system and we do not want to use the sequence as part of the import. Looking at KB 95260 it implies this is not possible…
  • Unit of Measure Import Template

    Hi, I have created Unit of Measure Import template in V12, when i try to import the data getting error message "Field: UOMDES: Mandatory Field" SEED Folder - 12.0.23 (Patch) Any Recommendations please, thanks for your help. Regards, Karthick…
  • Inquiry - Excel Export Error

    Hi, Run a Dimension Inquiry, and select the Excel Export to export the data, system alerts the error message, Error Message, @X3.TRT/SUBAEXP1$adx(554) Error 31 No more memory available adg_realloc3 failed to free memory - diff:27018000 free:480204…