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.
Hello. Does anyone where credit card stubs are stored in V12? In version 6 it was XCSPSCNT.
We are in the middle of a migration to V12 and I'm trying to understand how credit card stubs are stored; because I will have to update some of my integrations…
Hello,
We use Netstock which has a "velocity" identifier that tells you in layman's terms how fast a product sells. It is separated into three main classifications: A, B and C and then three velocities: High (H), Medium (M) and Low (L). I am not sure…
Hello,
The short length of certain text fields is a constant complaint from our customers.
It is very necessary to increase the size of text fields, especially for DES, AX3 and NAM types
Regards
I have used the following T-SQL commands quite often when working on the SQL Server side. There are other ways to find some of this information, but you should have these commands in your toolbox.
Using the SQL Server Management Studio(SSMS) interface…
Hi,
We are a Blending & Packaging plant and have v9 Patch 5.
We have 'never' archived/purged in our Sage X3 (EM) so we have over 10yrs of data (Since June 2008...)
We've started to purge out some old data like the ATRACE and investigating into the…
We are on version 11 patch 9 I created a table and a custom import template:
The first record is always created (after I RTZ the table) but instead of creating all of the other records it insists on updating them instead. Here is the error received…
Good day everyone,
I am Manuel a rookie in the use of Sage X3. Fortunately over time have gotten myself familiar with the Interface and workings of the ERP system but on the development part have been stuck with a few challenge and hoping get it it…
I have the following Graphical query, the two tables are BPCUST AND SINVOICE.
How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018.
When I search for this its outputting all the invoices and duplicating…
Hopefully this is a simple request
I have a Purchase Receipts screen, and each line item has an associated Purchase Order.
I need to display a value from the purchase order (held in the PORDER table) on each line item
If I just add the PORDER…
Hi everyone,
Situation:
Many times for troubleshooting or reporting purposes, I came across the situation I would need to know quickly how a record has been created/added to X3 tables (source of creation). Take an example of Sales Order or Purchase…
Does anyone know how to join tables through code (with one table being ATABDIV (misc tables))? I am trying to link TSICOD (statistical group ) (dim=0) to the table on the ATABDIV table (it's table 20), but I can't do it through code. Can anyone help me…
Hi Bob,
This is how it runs with the basic stripped down version. As you can see there are a few '0';s that are messing up the query. The field was added as a customized field and added to the index (STO0). I may try using another table and see if…
When scrolling a main window that is table based, the entire section scrolls. On a table that displays more rows than fit vertically within the screen, scrolling scrolls the header/filter row off the top of the screen - requiring the user to scroll up…
