Sage X3

how to extract data from purchase invoices from sage x3 sql query pinvoice table and pinvoiced table

Good morning, We've got a custom entry transaction for sales orders called ZSTD. It looks like the following fields have been hidden from the line entry, and as a result, when you tab after Cost Price over to Product source, there is a considerable…

We have a need to set the values in certain fields to certain defaults based on other data that has been plugged into the screen. In our specific case, we have a custom field we want to change the value of on our sales order entry screen when a certain…

Hello, We are having an issue where using the "select all" checkbox in the left-list selection does not select all records, as there is more hidden behind a second page. How can they be displayed on the first page so that the "select-all" checkbox works…

Hello, The Pay approval menu cannot be changed in this screen after the document has been created. The cursor immediately enters the Analytical dimension box when you try to click it. The document is not posted or paid. Is this a bug? Sage X3…

Hello, I've added this button in OPIH, code 3B, but SETBOUT is not called in SPEPIH at all. Is there a workaround, how I can get it to be activated? Thank you,

Hello, Our bank 3 which we use for USD has a wildly inaccurate balance. We've noticed that several GENAJ journal entries showing withdrawal from bank 1 (CAD) and deposit into bank 3 (USD) is missing a mark number on the bank 3 line, and when we try…

Hello, We have an import template that imports payments from a server location [YIMPORT]. It works correctly when run manually, but when run in a recurring task, it gets cancelled with the error "Query Interrupted (reason unknown)" and the file on the…

Hello, Unfortuantely, I've written a large SQL query with 57 columns on the server, and when I tried to translate it to the SQL query tool, I found that Sage's maximum columns for the tool is set to 50 (this box): Is there any way to extend this…

I hereby request your assistance with a technical problem that we are encountering in our SAGE X3 V11 environment. In fact, our users cannot create or validate documents. In large parts, these are most often documents of the type: Sales purchase…

Hello, One of our summary billing reports is showing a charge which does not appear anywhere in Sage that our finance team could find. However, I found on the database it exists in GACCDUDATE as part of a "NEWPR" type of document. What is that and where…

Bonjour, I have a message that appears each time which blocks the proper functioning of the X3, here is the message ( For an unknown reason , the server has refused to etablish a new session ) Thanks for your help. Sincerely

Hello everyone, Can anyone help me understand why my stock is showing different quantities in these two tables: STOLOTFCY_QTY and STOJOU_QTY? We have several reports mapped to the STOJOU_QTY table, but due to discrepancies, our reports display different…

I have created a calendar view based on X3 query. I used Dictionary of view for building the X3 query, and the query itself runs fine, however, when converted into a calendar view, it's missing the record with a value of larger than 17 almost. I have…

Hello, While creating intersite transfer, I selected a doctype (GMI), but the generated entry number doesn't match the sequence number format set up for the doctype; instead, it follows the sequence for another doctype (INT). Oddly, when I choose a…

we have two site one site already have one supplier in same supplier to add in another site getting error Already Exist,Please Try Another GST Number.

Does anyone know where or how a cash requirement table TMPCSRQ gets populated? The report code that is used is NA-CSHREQ.

Hi there, We'd like to add administrative screens such as Users and Batch Server as links in a process map, but directly copying the link or using a relative link such as /sdata/syracuse/collaboration/syracuse/batchServers?representation=batchServer…

Would like to know if its possible to have a company with sites that have different currencies. For example. Parent company is Germany but has sites in the US. Germany company defaults to EURO but the US sites need to be in USD. Can this be done…

Hi, I'm getting this error(below) while trying to make a save request to webservice. Name of webservice is ZSOH. SOAP-ERROR: Parsing WSDL: Couldn't load from 'http:// myprivateurl /soap-wsdl/syracuse/collaboration/syracuse/CAdxWebServiceXmlCC?wsdl…

Hello, Whenever we run a preparation plan that takes 10-20+ minutes, it always fails with "error following rollback in transaction". Only a third or so of the pick tickets get generated, and we have to delete the prep lines with no tickets and re-generate…

Hello, One of our user groups randomly started experiencing this warning upon logging in. Does anyone know a fix? Thank you, Zoey

Hello, When launching the function (FUNWIPMFC) calculation of the manufacturing cost price WO, I encounter the following error message:"The value of the activity code 'NMM' is not sufficient" I changed the screen dimension without result, for the…

Hello! I've added a field, ZMNSTA, to the CLE2 (Close & Reopen Purchase Orders) screen, in order to display a custom field from ITMMASTER for each product. However, upon entering my code into SPECLE2, it seems that no actions are being called at all…

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…