Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
How do we get the credit status on the sales order to display 'Prepayment'? We have the payment terms configured as prepayment and the parameters in TC, TRS and VEN appear to be set accordingly.
Hoping someone can assist. Thanks, Christine
Sage X3 v12p34, SQL Server 2022 Standard edition.
Full error as follows: `Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'APLLCK', database 'x3v12'…
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
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.
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…
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…
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…
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.
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
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.
…
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…
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?
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
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.
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…
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
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…
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…
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!
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.
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!