Sage X3

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

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…

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…

The problem: When printing PDF files generated through X3 V12 to ActiveFax with the goal of automating email & print jobs; ActiveFax cannot read the codes despite having the font successfully installed on the server, pointing to the font in the crystal…

Hello, everyone! We are in the process of selecting barcode printers compatible with the X3 for our shop floor. We have 2 options so far: ZEBRA ZD421, DIRECT THERMAL, 203 DPI, USB, USB HOST, ETHERNET, BTLE5, EZPL TSC TX210, LCD, WIFI READY,…

I need to produce a Multi-level BOM report with costing details and totals. The "Print BOMs" report under common data gives the correct BOM structure, but I'd like this with Material, Labour, Overhead costs - and totals... Does anyone know of such…

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…

I just want a way to reprint the remittance. I can't find a report or screen to show me all the invoice numbers on a check, just a listing of the PINs that I can drill back to. Any suggestions?

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…

What could be causing the Fixed Asset register to not balance to the general ledger.

Please assist. The Carry Forward entry (Opening balance) for accumulated depreciation does not agree to the closing balance at year end on the Fixed Asset register. I am not sure what the issue is. The Fixed Asset register appears to have processed…

Good day It appears that when I select to print multiple copies of an invoice from the enter parameter screen it will multiply the net invoice amount based on the number of copies you select to print. Can anyone please assist?

Howdy It looks like when I print directly from X3 to the printer I'm not getting my net invoice amount, it appears as #########, but if I do a .pdf preview it is there. Any suggestions?

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.

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…

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…

Hello All, I'm experiencing the below error message whenever I'm trying to download large data from Sage X3, mostly Financial Entry inquiry. Your advise will be appreciated. Sage X3 version: V11 Patch: 16 SQL Server: 2014 Error Message…

Hello Guys, The available stock for a particular product in particular Site as of 31st August 2020 is 69 119.160Ltr. positive while the average and total cost is showing negative in Stock Valuation report. Average Cost: -2.40 and Total Cost: 165…

Does Sage has standard Accounting Code for product which we can refer as guidelines. For example the product code for Asset (if you have multiple asset Gl code - machine, computer, etc), should you have different product code for each asset according…

Hello, I have created a SQL query to show the top ten customers using SINVOICE table. Under Characteristics, Representation set to "Character and Graph". When it validates and run it shows the List and the graphs properly. But when it adds do dashboard…

Hi Everybody IS there the possibility of adding a certificate when generating a pdf invoice, and automatically sendind it by email? Right now we send pdf invoices by email, but I don't know if can add a certificate to pdf before. Has anyone encountered…

Hello, I need to get a check register from Sage X3 but the report I am getting is incomplete, as it is not pulling all the checks that have been issued. Reports->Reports->CHKREG-> I am selecting the right bank account, the right status, without…