Sage X3

hello im looking for the flag to tell of a PO is open or closed, i am looking at ones that are open and closed and i can't find it.. im thinking its like my other post and its on a different table. thanks in advance

I'm a relatively new user at StackOverflow, so my apologies if I violated any rules in my post. Here's some quick background to set the context for my question. I work as a quality analyst for a manufacturing company that stores all pertinent information…

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

Is there a 'definitive guide' to using this with X3? Can one pull data from the database with that tool?

I'm hoping someone can guide me with this issue. I cannot seem to view my VIEWS when I open my ODBC connection in crystal report. Crystal has the Tables and Views options checked but I believe the issue lies with the connection . I have created a new…

I was wondering if a sales order is locked by a user, is there a field on the database that will show that this order is locked?

When you open up script dictionary, and open up the fields tab. For the description column, what table are those values being stored in? Thanks, Chris

What table is the invoicing element dimensions on the delivery screen being stored in? Thanks, Chris

Hi, I am not able to open any of the Sage X3 fixed asset screens. I am getting below mentioned error:: Table Access Error D:\Sage\X3V11\folders\X3\tmp\sqltrt1489.log Temporary files : D:\Sage\X3V11\folders\X3\tmp\sqltrt1489.sql D:\Sage\X3V11…

I hope someone can help. I am currently looking for the table that holds the following fields CNONIP INV These are the fields from the Financial Risk section of the BP Customer Situation Screen. Regards Paul Moss

Hello, I am receiving this message upon trying to run an SQL query from the local client workstation. I have search this in forums, but can't seem to find the resolution. Apparently there is a setting in the ODBC driver that allows multiple commands…

Does anybody have any information or examples of calling an X3 object from another process within X3? I don't want to display the object window, I want to open the object in code, populate the screen values dynamically in the code, and then call the CREATE…

Hello, I've just discovered this following fact about our data and was wondering if anyone here had any knowledge of this situation. In our SINVOICE table we have records populated by two sources; Sales (ORIMOD_0 = 5) and A/P-A/R Accounting (ORIMOD_0…