Sage 50 US

I work for an organization that makes a restaurant Point of Sale. We have a customer with Peachtree 2011 and they've sent us information from the help files about importing into that version. We want to import sales information into the G/L but I'm not…

We recently purchased Sage software to manage inventory items. I have a few questions, 1) is a way to upload inventory items from an excel spreadsheet? If yes, could you please send me instructions? Or do we have an email for support? 2) If we are only…

Currently in order to do an automatic backup in Sage you must use the Automatic backup tool which uses Windows Task Scheduler in order to do the local backups. This has proved to be very inconsistent and not as reliable as the manual backups of course…

One of my bookkeepers reports that she had her client crash with null pointer error. Looking at the server, found a 0xC0000005 error for the zenengrsvr32.exe . She couldn't quit Sage or navigate off the page she was on. Rebooted her workstation couldn…

Dear All, I have a question on the following, one of our sega client can not start the sage application, and the database is hosted on other computer in the network, have ran the diagonsis tool, i found the following issue, but the sage client can access…

My excel version is Office 2016. When I export data from Sage 50 to excel, there are different date format in the date column (as below image, different date format for 12/4/2022 and 14-4-2022). It is difficult to use Excel Power Query to do some analysis…

Is there a way to specify a relative path for imports/exports? If not, there should be, it would make it much easier for multiple users to use the same import task.

Hello everyone I am a new IT person to involve with sage50 I want connect to database by using 3rd party application such as Excel, Access, Power bi through ODBC to create real time and interactive report by power BI, I following this article https…

Is there a way to upload an Inventory List into Sage 50? I have around 70 items that would be a million times easier to upload once, in lieu of keying them in individually. I have searched the Sage Knowledge Database, but cannot find any articles…

We are trying to retrieve Invoice line item data through the ODBC connection. We can connect to Sage and retrieve the Customers tables (and other tables) just fine. I do not see INVOICE or INVOICE_ITEM table in the list of tables. Trying to pull into…

A pdb from a 2019 backup has been restored in a one-off location separate from current, live data. I have installed Sage50 2019 on a separate machine. I tried installing without and with pointing to the restored data but neither worked. I tried having…

I have a Sage 50 Drive company that I'm trying to open. it shows another user has it paused but that user is unable to reshare and stop share. Any ideas how we can restore the file from my local computer?

Ever since upgrading to the latest version of Sage we are unable to use the automatic backups (error attached) I've submitted a support request and was told to post here. this is going on several weeks and would like to get it resolved. any help?…

Is there a way to restore an Archive file and set it up as a new company file? Our original backup file was corrupted. Thank you.

We have noticed over the last few months that we will enter sales order or invoices, print a paper copy, open it again and email a confirmation to the client, than days later the record is missing. This doesn't happen every day but it does happen a few…

How do I assignment accounts to imported bank transactions?

Hello everyone, I have started using time ticket imports, and had a question concerning annual and sick time. We are using the, "Duration," field to keep track of employee's time, but at the moment, I am having to manually go through and look up their…

We are certain that it wasn't a duplicate entry as it's not showing anywhere else in Sage, only on the original invoice as a negative credit. The erroneous negative Other Credit showing on invoice and not a duplicate payment or journal entry. Cannot delete…

Hello I have a client of my MSP, and just realized they are doing daily manual backups of their company file and have years of ptb files, one for every weekday. DO they need to retain each of these or can they be removed, retaining only the most recent…

Hi, our small company is using sage 50 with its data in a SageDB. Currently the table 'sg_auf_drudef_history' us about 17GB in size (with overall size of around 18 GB) What is this sg_auf_drudef_history? Can I purge it in any way? Backups are…

Are there any issues with loading previously saved Sage 50 / Peachtree data from Prevasive SQL database into the newer 2020 Actian Zen database?

We are returning to Sage 50 after not using the program for a couple years. We had a lot of corruption in our old Company file so we started from scratch on the new one. My question is if I have customers and vendors lists in CVS format, if those lists…

I recently purchased a company running Sage 50 and I want to copy the company data and rename it with new business name. The issue is that I want to copy only the data starting July 1st. Is it possible to copy, backup or restore with only a specific starting…

My old computers screen broke. So I bought a new laptop and loaded the same 2017 premium accounting on the new computer. None of my ptb files will restore. Just says invalid file format. These files work just fine on the old computer, so i know the file…

The current situation : We are using ODBC to pull data from the Sage 50 database to Excel. For example, if we pull the table taccount from the database we get the table with the GL accounts list and the amount at the present time. It produces a trial…