Browse By Tags

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…

I thought I read a post about this, but now I cannot locate one. When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not: Of course we get this message, which…

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 fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…

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…

There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …

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 community, I am in desperate need of HELP ! We use Sage Business Vision for small business version 2023. We installed it on 1 new computer with Windows 11 operating system in November 2022. Originally, there was an immediate C++ runtime error…

Utilizing Sage 300 2023.1 to access Sage300. How can the print destination be modified using Web screens? Currently, whenever we print any report, a new tab is opened with a file format menu [PDF, Excel, Word, etc.]. In addition, how email functionality…

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…

Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…

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

Using OEINVD and OECOINI tables for report and trying to get item/miscellaneous comments. Somehow I am not able to get comments to match. Any tips?

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…

When I print the purchase order it does not show the item description on the purchase order. How do I fix it to show the description on the purchase order? Thanks