Sage X3

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

Hello All, I have an interesting ask from our User base. We have Word Documents that are required to be printed when ever as a Check sheet each time a user prints a work order. Here's the twist the Word documents are unique to each product or groups of…

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…

We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…

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…

On X3 version 6.5 (and version 5) we installed font IDAutomationHC39M.ttf on client computers to get barcodes to show on crystal reports. With V12 I figured I would have to install the font on the server(s). I installed the font on both the application…

I'm very new to Sage X3. Does anyone know if it's possible to have an image that is attached to a product print on the Job Ticket report maybe as a subreport? I have tried everything I can think of in Crystal Reports but I'm not getting anywhere. Thanks…

Hi, How to email a report without a SERMES entry? Tried to email to myself a report without a local SERMES entry. Report is: LISREL However, I receive nothing. Spam also no new email. Assume no local IIS6 SMTP Relay Server is available for…

Reference: https://www.sagecity.com/za/sage-x3/f/general-discussion/155387/error-cannot-connect-to-server-xx-server-local-1807-error-connect-etimedout---error-code-500 If Print Server was already set in stone for a long time (ref link assumed connectivity…

Hello There, I need help in Sage x3 Aged Balance report (BALAGEGRP), which I need to add more intervals in it. The report already shows the following intervals: 0-30 Days 31-60 Days 61-90 Days +91 Days What I need to do is add 2 more intervals…

Our customer is starting to analyze margin information at product level. It appears that margins for kits are not reporting correctly. Attached screen shot shows example of a sales kit the customer supplies. Because no cost is associated with it, it is…

What are the key differenced analytics wise between Statistical Groups and Dimensions? What kind of reporting can you do using one vs. the other?

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…

After posting payment, the record print option is greyed out only the list button is active. I need help.

If Sage x3 Doesn't have a SOC 1 report than can we get something alternative to this. As SOC1 report is mandate to get the change management authorized.

Is there a limit to the number of rows you can have on the Check Register report when the destination is Excel? Every day, I run the Check Register report for the whole year using the print destination of excel. Today, when I ran it, the file would…

Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB. I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text. This works fine in SQL, but when I try in the SQL Requester…

Hi, I want to run a report for a specific BP/Customer and I would like this report to show a complete list of all transactions for the customers - open and closed, invoices, CMs, DMs. I want to see 2 columns, one showing original amount and one column…

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.

I have run a query, i can see that it has returned 174 lines. no matter what i view, it will only show me 100. besides that, on the page there is no way to go to page 2, and when i download it to excel, it only downloads what is on page 1, and not the…

Hi, This may not be an error as much as a question as the internal workings of Sage X3. I've been setting up reports for our Sales department, but they weren't lining up wtih our Actuals. I realized that I was utilizing SORDER.SHIDAT_0 instead of SDELIVERYD…

I'm trying to automate reporting for my organization. However when utilizing SEI's pivot function, it staggers the groups from the data itself making the data useless upon exporting to Excel. I'm hoping there's some setting where I can have a more traditional…

Is anyone familiar with linking the MACHINES (Installed base) and CONTSERV (Service Contracts) tables? I am trying to create a crystal report to print from the installed base screen with a summary of all the related service contracts. From the installed…

I am using Sage X3 V11 with Crystal 2013 to create a new label. Is it possible to prompt for report parameters when using the Print Stock Labels function? I am hoping to enter values for the label that are not currently stored in Sage as parameters.