Sage 300

Anyone Please share the process to Integrate Custom made filter Based Crystal Report / exe in Sage 300 Web Screen.

I am trying to print an invoice, in retail POS, but I am getting the error above.

Does Sage 300 offer SOC 1 Type 2 Report?

Is there a standard report that will show me POs received but for which an AP Vendor Invoice has not been entered into the system?

Any ideas how to fix? Partially fixed with backing down Crystal Reports to 32-bit after an upgrade to 64-bit got through, but still having problems.

Using MyAssistant, I am trying to create an excel doc that contains the "Current Month" in the top row. If I go into JC and select File > Company Settings > JC Settings, I can see in the Accounting Date section the Current Month is "September" (even though…

Hey Everyone, I am new to Sage 300 and crystal reports but have a decent handle on both. We recently implemented a yes/no optional field for PO line details, everything tested fine for a few days but now it seems like the value remains as 1 no matter…

Hello, I am using SAGE/ACCPAC on a local computer and trying to run a "A/R Aged Trial Balance Report" but I am getting the following error after clicking the print button. A window with the heading " Crystal REports Windows Forms Viewer" with the…

Hi everyone, A customer change its PC - we have all programs ate server and we run workstation setup - and suddenly a custom crystal report we create from scratch doesn't work !!!! Error...."The remaining text doesn't not appear to be part of formula…

Hi All We have Sage Line 500 Ver. 5.5 installed as xERP System for our company, and we have been requested to extract some reports for old data. I have created a new VMWare hosting Sage Line 500 Server and Client as well with MS SQL 2003. And since…

Client is having an issue where a report inside of Sage 300 will not run. The screen below appears. The report was built using a DSN file. It worked before but this is a new workstation. Entering the password does not work and it complains the user…

Does anyone know if there is a report I can run for the total amount paid per year for a specific cost code? I do not need it broken down by job. Just need a sum for all jobs combined for that year.

Hi - how do I find this in crystal reports to add it in: So, where do I find that "Item" in the field explorer in crystal reports so I can map it to the invoice Thanks! Dan

We have multiple users across our branch network who can run different reports but I want to be able to limit their access based on "allowed" locations. For example, I want to limit a reorder report for a user so they can only run for their location and…

Using Sage 300 2014. After we post a PO Receipt, we select Print. All forms PORCP01.RPT, PORCP02.RPT, PORCP03.RPT, PORCP04.RPT just show an empty grey window in the SAP Crystal Reports preview.

Hi, A customer has a custom report we create from scratch for AP transactions a long time ago. After they update workstations to Windows 10 in some of them that custom report doesn't work but in others its OK. So not sure what's the issue to fix. They…

Hi I would like some clear direction on where Sage 300 is headed for reporting for the Web screens. 1 GL Financial Reporter - Financial Reporter for Web UI - possibly on road map for August 22? Whereas previously this had been ruled out? 2 Sage…

I have a client that was using version 5.6 and now upgrading to the latest version of Sage, Printboss was set up years ago and has worked for year using umlaut/accents for the French/German characters for the file names, eg was sending invoices that were…

Using Sage 2021, seems the ODBC driver for excel only support .xls files. When attempting to connect to a .xlsx, get SqlState error S1000 that the table is not in the expected format Any way to use the driver with xlsx?

We just put the Tax updates for January on our system December 31. We are on version 2021, UP73 product update 30. When we enter all of the parameters on the screen for the Payroll Employee Information Report and hit print, it crashes. By crashes I mean…

2020 year's sales tax was easy. I just ran the tax tracking report for the relevant fiscal periods and sort by tax class, which for us is 1 for taxable items and 2 for non-taxable. But this year, the same report for both this year and last double counts…

I am currently using Sage 300 Premium 2021. I have users accessing Sage via a published remote app. Until just recently, they were able to successfully print reports from the published app to our network printers. Now, they are able to preview the report…

Good Day All, How can i get a report on Sage 300 Customers and Suppliers Daily Report With Opening Balances for any given date

Need recommendation for ODBC consultant.

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…