x Want to participate? Join the group to interact

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

  • Planning work order material import for BOM change

    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…

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

  • Importing new components to existing BOMs

    I would like to add additional costing components to existing product BOMs in Sage X3 (v11). When using the import template BOMPD, it requires a field for the BOM component sequence (BOMSEQ), however, each BOM has a different number of existing components…

  • Sage X3 - Stock Accounting Task

    Hi Sage X3 V 12 pu 24 Patch. We have recently had a SQL corruption that was repaired on the client. Long story short restoring to a valid backup was not an option. Not ideal and measures have been taken to avoid this in the future. The SQL is…

  • delete product site

    I want to delete product-site records that they do not have transactions in that site. when I use transaction mass update, it dose not check it has transaction or not and delete it directly and it is wrong because I want to delete the same record from…

  • Best way to import BP Contacts under Common Data > BPs > BP's > Contacts tab?

    Hi I'd like to import email contacts under this contact function for about 1000 BP's. I have my list of BP's and the email address. I will flag them all with code being their BPCNUM followed by _STA. All fields will be the same such as language, country…

  • Import Inventory Value Change values to revalue stock

    Has anyone managed to import values to do a value change of stock?

  • What is the best way to get a GLCode attached to either an Item or a PO?

    I am trying to join one of the following tables to GACCOUNT. PORDERQ or ITMMASTER. There doesn't seem to be many ways to get from GACCOUNT to an ITMREF_0 or POHNUM. I have tried a few different options but none seem to be working. Your help, as always…

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

  • Where can I find GL code and descriptions of the code?

    I am building out existing access report in sagex3. Where can I find GLcode and descriptions? I've looked at the accounting data model tab and am just not really sure what I am looking for. Thank you in advance!

  • Looking for Total Usage Qty

    Good Morning! I am currently working on swapping from Process Pro To Sagex3 and one of the columns in PP is Usage qty which is total qty used for the year. Is there a field in sagex3 for this? As always, your responses are greatly appreciated!

  • What is EOQ?

    is it estimated order quantity? Does anyone know the name of the column in sql? As always, your responses are greatly appreciated!

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

  • Format data on export by Adding characters

    hi, When i export some data for exemple à LOT NUMBER, i want to add a "XX" at the beginning of it when we export the data with an export template i take from the table OUTPUTM : [OUM]LOT I'm trying to use =FORMAT$ But i'm stuck on how to express…

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

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

  • How To Replicate Same Folder, Same SQL Database from a Production Server to a Data Recovery Server Automatically

    Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks

  • Sage X3 V12 on Oracle RDS

    Hi All, I installed the Oracle RDS database instead of MS SQL Server. The database is on diff. server and location and the challenge are – how to config. this in the below screenshots in Sage X3 Console? What are the inputs required to provide here…

  • Import companies and sites

    Is it possible to import multiple companies and sites?

  • Import SIH using Web Services

    Hi all, as you can read i'm trying to import an invoice in my Sage X3 V9 PATCH 6 using Web Services, in my specific script(SPESIH) there is an action that i don't want to perform if i'm importing using web services. I wonder if there is a method to…

*Community Hub is the new name for Sage City