Browse By Tags

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…

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 …

Running 13-6-21 is a listing of all reports in Sage. Some reports are showing "Apex Format". Never seen that before. What is this?

I need to provide a Year to Date Profit & Loss Report to my bank. I use Sage 50 software. Which report would that be?

I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.

Custom reports and report forms in Sage 100 Contractor have been "infected" with this "field" rptclc^clc001, 002, etc. I have seen this before but not to this extent. It is massive. Has anyone else seen this before? Or know what causes this…

Hi, We use a report to create a label for quality control, printing the report some fields are automatically filled to save time like QC Number / Product Code as unique in the Quality control. Is it possible when several data are possible to select…

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…

Hi all, can Sage 300 do something like this? when user preview the report, to auto save the report as pdf to specific folder based on the year, month, date generated, and customer. thank you

Everything works on the script except for the line that calls for the print oRpt.Printout (I tried oRpt.Printout(FALSE) but then nothing happens at all) The line actually technically works, but instead of just printing the the default printer, the…

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…

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…

Hello, When i try to print a report via PDF, the font is smaller than if i do it directly to a printer. I don't know why this happens, the report is the same for the 2 options. Shouldn't the final document be the same for the 2 options? Thanks in…

Anyone built a report that shows upcoming pending leave from ESS? Looking for solutions thanks

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 all, my customer is generating financial report from Sage 300 web app as excel file and open it on Microsoft 365. However, the alignment is wrong. All the debit values in red color appears in Credit column. When opening it on old version of Office…

Hi, Since this past Friday Dec 17 2021 we have started to experience a weird behaviour where for some users the SBONFACP Report generated via printing on (Sales >> Sales Invoice) does not print out to PDF, it remains showing the progress bar moving…

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 caused, or how can I prevent, the gray box (report detail area) in the report form from duplicating itself (ghosting), usually in the bottom right side of the report when the report is run. First thought is there is another gray box, even just a…

Hi all, Our client uses the Calculate Expected cost function (Manufacturing) That prints the Expected cost type report without the actual and expected costs for these workcenters. I've attached reports how it is blank in the first image. However a few…