Browse By Tags

Hello everyone, I have an issue that I haven't been able to find a good fix for. Users in the office access Sage that is installed on one of our servers with an RDP connection into the Information Assistant app to pull reports, particularly Job Cost…

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 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…

Hi Everyone, We seem to be having an issue with our A/P Vendor Reports. One of our users was able to run a T5018 form from the "Print T5018 (CPRS) Forms" icon on Feb 10th. Now when she goes to run the report the icon is no longer shown, along with the…

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…

Has anyone changed the Reorder report to use the Preferred vendor instead of the report just using Vendor Type 1. I realize the report is using a DataPipe and the prevendty isn't given under ICITEM for this report so it looks like I will have to build…

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 need to retrieve Purchase Order details to include the PO # and "Ship to" name. Can this be done with canned reports in Sage 300? My searches have come up empty. We have intelligence but not Connector. The Purchases Master report doesn't appear to…

We are using Sage300c 2020 web screen, when we print a report we are able to see it on-screen {Preview}. But, unable to print to printer or export

We have a Sage 300 2020 PU2 installation that works on most workstations, but one virtual machine running windows 10 Pro 64bit does not work. The issue is that when we print a report - any report, it runs the database record select and then stops…

Hi All, Problems found when we had started doing new forms/reports for Sage 300 2019. Recently we found out that when using View Table as Data Source, the reports are unable to generate any results in Sage 300 2019, while Sage 300 2018 or earlier…

I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium …

I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…

For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…

Hi, One of the workstation, the print preview of any reports, the screen is printing at the center in a very small pages. Attachment is here. Thanks in advance.

Before upgrade: Sage 300 v.2012; 2 pc with 2 printer (same model), User share the same OE invoice & cn/dn Pre-printed forms on dot matrix, no problem with alignment.. After upgrade to V.2018 – Alignment is wrong for both pc. I changed the alignment…

When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines. Appreciate if anyone has seen this before and has a solution…

Where do I find stock crystal report forms? I'm using 300 v2017 and looking for the most up to date version of oeinv.rpt

I'm wondering if Sage 300 16.1 keeps track of the most recent time a report was used. The last guy who managed them never deleted anything so we have reports that are as old as dirt. I was wondering, instead of asking every person individually what they…

I find it cannot print out or preview the built-in standard sage 300 crystal reports with windows 2003 at the c/s workstation level.Everything else is normal. Is it incompatible with windows 2003 and winxp used by sage 300 2016 c/s workstation Level…

Dear Friend, My company are using a several-section numbering for GL code and i would like to know how to wildcard the first part of GL code? For example, GL code, 100-02-03,101-02-04,102-02-05, 102-03-01 etc. if i like to use wildcard in the first…

Crystal report datapipe connector fix from years ago does not work for Sage 300 2016. Will Sage release another fix?

It there a way to not show the discount date and discount amount when the discount amount is zero?

We have been looking for a report that will show the total job cost including labor cost at the marked up rate and contractor's fee for bid and time & materials jobs. Is there a report that will show those numbers? The only ones I have been able to find…

Datapipe report runs well in Crystal Reports preview, but when placed on desktop this error is received "..\a4wdp.c line 372". Copied datapipe.ini file for ICSLOW and commented out stock report and entered my report name and parameter. Copied same…