Sage X3

Looking for any insight. As far as I can tell there is not direct report that links COGs to deliveries. I've created a quick SQL query that provides me the necessary details from GACCENTRYD based on the TYP = stock. This works for a very base understanding…

HI All Please assist on how to resolve this error. It appears when trying to print any report in the system. The print server is configured and the service is running. Job 2 - ERR 262 coming from the edition server : Connection to the X3 file server…

Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…

Hello Everyone, We are trying to setup ZPL printer on Sage X3 but the problem we are facing is: a. ZPL printer is on a private (LAN) network - not accessible outside b. Sage X3 is on the cloud (Accessible only by a secured SSL URL) c. Sage X3…

I'm having trouble adding a new report I've created to the AP/AR Accounting>BP Supplier Invoice record print list. I've looked all over the Setup>Destination>Print Codes list and cannot find a place I can add this report in order for it to show up as…

Hello, I need help, i'm creating a PAT file using openo and wrseq with some ZPL code, that file is then called by a Report wich has been created using a ZPL list. The PAT file is created without any problem, but when i call the report the .DATA is generated…

Hello, When i run the aged trial balance it shows fully applied invoices and payments. It is matched already and customer wants to see only outstanding documents. Are there any way to remove all applied documents from aging reports. Eranda

Hi, my company is in the middle of a migration from SAGE X3V5 to SAGE X3V12. R093.001.00019 When running a report in X3V12, the querying part (Job Started Phase with the green bars) takes an extra 1-3 minutes on average than it did in X3V5. In X3V5…

I'm trying to create a report so that the maintenance team can see how many "variations" they have scheduled across multiple work centers. the table CAPVAR is not at all structured like the grid in the work center page. Does anyone have a report already…

When trying to generate the positive pay file - we experience the following error - file return error - no checks selected. There are checks generated and printed.

Hello, As the title suggests, my business' reports are now being sent out an hour earlier than they should due to DST. When looking at the admin guide in SEI, it suggests I set a Time Zone for the scheduled job. However, as you can see below the option…

Using SEI 8.2.0.38. I can email a worksheet, report etc. when I share it from the Command Center (Sharing>Email). When I schedule the same worksheet, report to email out, I don't receive an email. The Scheduler console shows that it ran and was Successful…

so, we want to output some of our customer data into another system but only as the delivery documents are printed. on V11, is it possible to tag something on the bottom of the report code that will output a CSV to a given location. eg: user prints…

I got a problem regarding the sales order report printing , it keeps on loading but it never print . I'm just asking why was this happen . It only happen with this particular SO number.

Some fields in our X3 db were renamed. SEI process currently refers to old field names. Is it possible to remap field references in process? I was hoping to be able to update references in the relevant process files in CentralPoint. But this hasn…

I am trying to report on the invoice inquiry screen. The fields are exactly what i need. Anyone has an idea what those tables are that are running?

I'm trying to track the health of our shipping department and I just want to ensure I fully understand the create date in the StoJou table. does that mean when the delivered qty is taken out of stock ? and if yes, does that also mean when the shipment…

The budget analysis is only including reporting debit code 1 dimension for actual amounts. How do I include a reporting credit cod 1 dimension into this SEI budget analysis?

Hello, I keep getting this error message when attempting to e-mail myself a BI report created on our system. I'm not sure what the issue is but it appears to be generating based on the FROM send address. Perhaps it is a email server authentication issue…