Browse By Tags

Failed to retrieve data from the database error is received from Sage user interface when running a custom report created when client bought sage. Report works on sage 2014, 2019, 2020 and 2022 environments but doesnt on 2023 version. At crystal level…

Our client has the issue when trying to print their financial statements to file using the Print Financial Statements Icon (Sage 300 2023.4) The report generates no problem to Preview. We have Checked there are no other excel add-ins ticked…

While working on the Bank reconciliation of previously January 2024 and lately February 2024, I am facing issues in the Sage Intelligence Reporting module. The bank statement figures do not match at all with the A/R and A/P entries. The Income statement…

I had a customer that wanted to email out invoice in Sage 300 but before she selected the range of invoices, she selected delivery method of customer and clicked print. OOOHHH NNNOOO!! Panic!!. over 4000 invoices were going to either be printed or emailed…

Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?

I've been working with Sage 300 Canadian Payroll for over a decade and this is the first I have seen this. When generating ROE for a particular employee, usually it will auto populate Box 15C with all their pay periods starting at the most recent one…

Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023. I am in January 2024 and I am unable to go back to that specific date (November 31, 2023) Is there an alternative way to retrieve this report? My error…

Hi Is it possible to get a list of Open AR Invoice Batches via WEB API\ Or provide an endpoint through which we can query to find list of open AR Invoices batches in Sage 300 Regards

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…

It was my understanding that the Print 1099 screen went away and Sage is to use Aatrix now for 1099 processing. We have two sage servers for two different clients. The 2021 version uses Aatrix. We upgraded the other one to 2023 (previous version was pre…

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…

ActiveX component can't create object

Hello everyone, I need a crystal report programmer to assist with designing a AR customer statement with following output: 1. Opening balance on account at every point in time the report is printed ie yearly or monthly, 2. outstanding invoices unpaid…

When I try printing I get this error. Error Code: -2147467259 Method '~' of object '~' failed

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 …

Good Day Sage 300 PU4 Client recently upgraded to above. The FR report runs successfully but is no longer suppressing zero value lines even though this is defined in column c. I have tested on 32bit Excel and it works correctly. The client uses 64bit…

The full story is that our client of over 20 years has had to move their system from their local server to an Azur server at short notice. Everything is working fine except when they print the AR invoice form, both the customized form and the default…

Sage300 v6.0 using RDP. only one user has problem. FR Preview is normal. When generate report by print destination as file. a blank error message open. the file select screen's capture is adnormal If ok, it will hanged. Any hints?

Hi, I have just set the Sage 300 2024 up and using SAMINC we are testing new features for suitability for a client upgrade. When testing I am getting errors when running via the FR Web, the FR on the desktop however is working fine. Sage 300 2024…

Sage 300 with RDP session to server. User cannot add report object. Select Object > New or R-Click > New, and it stops there. All option including Report are greyed out. No problem with ADMIN or other users.

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

Hello, I want to ask about a custom report that I made using crystal report. So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300…

As part of a user access review, Support have asked if we can provide a “last signed on” field either with the user details or in a separate report. Is this data available?