x Want to participate? Join the group to interact

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

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

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

  • Connect Existing DB Server to Brand New App Server

    Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

  • What's the Employees table name?

    You can manage Employees at: Common Data > Manufacturing tables > Employees But I can't find the corresponding table. Does anybody know what's the table name?

  • link between Gaccentry and Bank

    Hi. Is there a table, where I can find the link between Gaccentry and Bank? Thanks in advance. MatteoS

  • Photos for ldap users

    can anyone help with info on setting up photos to sync from LDAP active directory. i have the ldap sync set up for user auth and provisioning but i haven't used the photo field of the mapping. I just tried putting "thumbnailPhoto" in that field since…

  • importing inventory with expiration date

    We are in the process of finalizing inventory conversion and plan to use SMR template (Misc Receipt) to load it. We added the fielSHLDAT and Coefficient to be able to load the expiration date, our product do have one to be loaded as well as lot number…

  • Import/Export template for PJM in Sage X3 V11

    Hi all, are there any default import export template for the object PJM in Sage X3 v11? I can't find it anywhere in my Sage X3.

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

*Community Hub is the new name for Sage City