Browse By Tags

V2024 logged Sage 300 as Administrator, when run any reports, we get above error, even when firewall is off. Everything else in Sage in fine. Please help.

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 …

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…

I am attempting to create an On-Time Shipping Report. I want to add a parameter to only show items shipped during a certain date range. I am using the same logic as the OE Sales Report, but my parameters are being ignored and I see all records. Any…

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…

When using Sage 300 webscreens, is there a way to run Intelligence reporting with installing Sage 300 desktop version.

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…

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?

I am trying to create a SQL stored procedure with a date range parameter to be used in a Sage Intelligence report. One old procedure uses the following: CREATE PROCEDURE [dbo].[TJWEEK] -- Add the parameters for the stored procedure here @S_Date…

I currently use @GLActual and @GLBudget formulas to pull financial data by GL accounts. Is there a way to add another layer and pull this same type of info for specific job numbers (customers)? Right now it looks like the 3 dimensions the formulas use…

I am new to Sage300 so i'll apologies in advance. I am trying 2 things to work on sage300 (2021). 1) I am trying to get department name on FR View dynamically. I have tried following but did not work for me. =IF(ISNA(IF(FR("ReportAs")="Separate",FRSDESC…

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…

We have a person that just started learning Sage 50 US Intelligence Reporting recently. We purchased the connector a month ago but have not installed it because we aren't on the newest software version. We got the email notice that it is being retired…

On our Sage 50 2022 we are receiving a notification about Sage 50 Intelligence Reporting is being retired. Will this affect the reports that are designed in this tool after the stipulated date?

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

Does a profit and loss report exist in Sage 50? Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage? I would like the report to include income, cost…

We have created a Financial Statements SAGE Intelligence Report Template that has default Distribution Instructions attached to it. For one particular user, it seems that these Distribution Instructions intermittently do not load with the template for…

Hello, I am having trouble with a running a few reports in the Report Manager that I have created data containers for in the Connector Tool. I keep getting a missing resource error like this one: https://imgur.com/a/PlNPghp This occurs right at…

Hi All, I followed the instructions to have the templates for the 2020 1099-NEC, 1099-MISC & 1096 forms added to my Sage account (I do NOT have a payroll subscription, so those are the instructions I followed). When I open Sage, the forms are now…

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.