Sage X3

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

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…

Hello, I'm trying to find the directory where printed reports are, and call it in the context of an ASYRMAIL attachment, however, I can't seem to get the code right. I am passing GFILPATH through a workflow, which returns the exact name of the report…

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.

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.

Hello, Sage prints directly to our label printer in our manufacturing plant. Sometimes the user printing stock labels will accidentally forget to change the 'quantity' of labels. The Zebra label printer will then print thousands of labels if the…

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…

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…

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…

In the standard report - BALAGEHIST and normal BALAGEGRP - the detail aged balance is showing currency revaluation as a separate line. Can this revaluation entry show at individual invoice instead as for audit purpose - it will not be transparent to show…

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…

Hello, I want to use the report "Bank Account in Ledgers Report" for petty cash accounts as well. While printing the report under parameter section, i can see the petty cash accounts but when i click on bank selection it says record does not exists…