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…

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…

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…

Group, A question from a co worker was asked of me a couple weeks back, and I'm late asking this question. Does Sage have report cards, vendor grading capabilities? Doesn't have to be anything too complicated. The basics would be a great start. I really…

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…

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

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

Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…

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…

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…

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…

The online help says.... Query, Detail, Edit, Lookup, Summary These columns represent the different facets in which the property can be used. When one of these columns is selected, the property is present in the corresponding facet. Otherwise, it…

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.

Hi All, As per the requirement we are working on the translation(to traditional Chinese-Taiwan language) and were able to translate the most of the text, screens, windows. We are now working on the translation of all reports. We would like to know…

I'm looking for ideas as to the best way to consume packaging in work orders. We sell products in various packaging....totes, drums, pails, etc. Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…