• Restricted Characters for Imports and Exports

    Hi! I have searched multiple blogs and sites for this answer (along with the online help center) and can't find a clear document that states which characters are restricted in Imports/Exports per table. I've been told by Consultants that certain characters…
  • Import Standard Costs for Assembled Items into a Storage Only Site (Non Manufacturing Site)

    We are trying to import standard costs for many sub assembly and manufactured finished goods, to a non manufacturing site. We have in the past, calculated the new standard costs at year end through normal functionality on the manufacturing site, and then…
  • 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…
  • Import Supplier Invoice (GESBIS) from Excel

    I need import 101 for dummies as we have never used imports before. Goal - to take an excel file containing supplier invoice information and import it into X3. I am on v12; patch 18. I have read the help from Setup>Usage>Imports/Exports>import/export…
  • IMPORTSIL creating file but not importing

    Hi, I want to create an import template via the 4GL code. It is creating the file perfectly but creates another file .err and doesnt import. When I use the same file created via the code and manually import the file it works, please could someone help…