• Invoice Matching Data

    Can anyone tell me where, in the database, I can find the invoice matching data? I am looking at the GACCENTRYD table but it seems to have some holes in the data. Any guidance would be much appreciated. Regards, Dave
  • add Invoice header text after posted

    Is there a way to add Invoice header text after the invoice has been posted? I'm looking in the tables and there is a code but where is the actual text placed? any help appreciated. thanks.
  • SAGE ERP on DBCS OCI

    Hi all, It looks SAGE ERP is compatible only with Non-CDB Oracle DB. So this will create problems if we would adopt DBCS as SAGE ERP DB, correct? Any similar experience on SAGE to share? Is there any workaround you can suggest in order to make…
  • Product Line Details

    Looking to see if anyone can direct me to a table that houses the details from Product Line entries on ITMMASTER.
  • Line Amount field on Sales Order

    Is there no field on the sale order tables that displays the total value of the line? I see the field on the line but I cannot find in either the SORDERQ / SORDERP tables. As is now I do a calculation on reports to get the value but wondering if I'm just…
  • Difference between TRKFIRST and TRKFIRSTC fields?

    Tables like MFGHEAD, MFGITM, and MFGMAT have first TRKFIRST and TRKFIRST C and TRKLAST and TRKLAST C . What does the C mean at the end? Sometimes the two date versions are the same, but sometimes they are not. And the table dictionary in the online help…
  • SAGE X3 SERVER RUNNING OUT OF SPACE

    This morning I freed up 35GB of space on server. This afternoon we out of space again. Any ideas. We are a 50 user site, with nothing fancy or funny. V12 P29.
  • Where are the user sessions stored in the database?

    Hi, My idea is to dump such info every minutes in order to track effective session along the days and do analytics in a spreadsheet or so Can someone tell me where this information is stored (table or log file), please? Have a great day
  • Where are stored CLOB text ?

    Hello, One of my predecessor added an ACB Clob field (Y_COMMENT) in one of the OPP screen. This field allows user to write delivery related comment. Y_COMMENT isn't in the OPPOR table. I can't find the comment in ACLOB nor TEXCLOB either. …
  • [v12p30] Sage X3 console, Db login can change out sa SQL Server user login?

    Hi, Console: CFG.2.54.0.5 (from v12p30 ISO disc) I have noticed latest version and newer patch level of Sage X3 v12p30 now can set the Db login. It was previously impossible to edit and must use sa. Will there be any issue if I change…
  • Where is Sales Delivery line LOC field stored in database?

    From the screen I can see the value for LOC, but not in database, the value is empty.
  • APLLCK TABLE

    Good day Why does the APLLCK have records in even through the front end VERSYMB there is no records to display? Is there routine maintenance available to clear this table?
  • SQL version for X3 PU9

    Dear Support, I would like to enquiry on what are the SQL version is compatible with PU9? as now we can not get SQL 2014 version which installed for PU9 previously. Regards Jeff
  • Get SQL Instance from X3

    If I am logged into Sage X3, does anybody know how I can determine which SQL instance X3 is using? I thought it was in the Administration section, but I can't seem to find it. This is on V12.
  • locate deleted shipments

    Is it possible to locate the shipments that have been deleted? Understand the record is deleted from the tables but wondering if there are alternate tables which may store the data. We are looking to keep a scorecard of how many shipments are deleted…
  • PO line help

    good morning, i am looking for help finding a table, in the PO lines there is a cost profit center column, i can't find that field on the POORDERQ TABLE or any other link to a table, i am so frustrated
  • 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…
  • Looking to build a report for Sales by GLCode by month

    Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…
  • 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!
  • What is the column name for AvailableStock->TotalRequirements in sql?

    I am looking to get the sql column name for total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.
  • 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!
  • Where can I find the received qty from a PO?

    As seen above, I am looking for received/delivered qty from a Purchase Order. Is it the Received STK or PUR in the PORDERQ table? so far I have been using received stk, but am unsure if that is correct
  • 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…