Sage 50 US

Long time ERP consultant here, but new to Sage 50. I have years of experience with Actian Zen (fka Pervasive SQL). But at a Sage 50 install, where the heck is Actian Control Center? Where would I go to write a simple SQL statement? Also missing are DDF…

Buenas tardes, disculpen una consulta como puedo conectarme a todas las tablas de sage 50 account, ya que ODBC solo lee los reportes de kristal report atte.

in running the purge data process, how does this affect inventory data view? If I purge 5 years of date, 2010 - 2015, will the inventory history on items still show in the "ALL TRANSACTIONS" view or only the history since 2015? WIll this also change…

The description for Sage 50 says " Desktop accounting software with cloud connectivity". Is my data kept solely on my desktop, or is it in the cloud (or both)??

New to Sage 50 but I have done some Peachtree work years ago, as in 12+ years ago. I am trying to write crystal reports but I would really like to see what is in each table to facilitate this. In my old Macola days, when it used Pervasive (now Actian…

I have a Synology DS220+ which I would like to use as a file server and store the live Sage data files as well. Is it possible to store the company files on a NAS (Network Attach Storage) device and access such files normally from a computer with the…

Survey: Did you already purchase Sage 2023 because of the "third-party database" issue and are disappointed that the 50% off deal only showed up today - seven months after the issue arose? We Did. Unless we missed an email somewhere along the way…

I have a client that purchased a new laptop and installed Sage50 Quantum 2020 on it. When they try to open their data from Sage 50 2016, they get an error that an older version of the Actian Zen database is already running and requires a newer version…

My client is currently using R2019 of Sage 50 US and now the PSQL database engine fails to get activated. I used SageReg.exe to check the license key status but it doesn't show any of them is active. Instead, all it says is the PSQL key expired. The user…

I/O Error in variable length part of record in file LINEITEM.DAT

The test companies that come with the software have completely disappeared since we updated to the new Sage 50 Premium Accounting 2022. How do I get them back? I use these quite often. Lori M

Two days ago, out of nowhere, suddenly both Vendor and Customer records will not save to the pervasive database. The button goes gray and acts like it saved, then when the close button is pressed, it reverts back to the popup message about saving before…

Good morning everyone I would like to know if it is possible to make a connection to the Sage 50 DB, I currently have the US 2018 version. The reason is because I would like to be able to get information with a separate development and if it is possible…

My file sizes are past the quantum limits and I’m starting to get errors, so I’m exploring options. I’m at 300kb quantum recommends 250 max database size 1 Will the Quantum database sizes be expanded anytime soon? Maybe an enhanced version of Quantum…

Dear sirs, hi, good evening to you. We are having a problem with which an error message as above-mentioned appeared ( as per the attached screengrab file #1). I t won't let us click the "OK" option, and move forward. We have to continuously click…

I am hoping for some insight. We have been experiencing slow downs of epic proportions within Sage 50 lately. We have data going all the way back to 2007 and our database is sitting at about 1.6 GB on a network. I decided to create a new "TEST" company…

I get this message, and my system just freezes up. I have to close Sage and restart it, or just restart the Pervasive. This sometimes happens 4, 5, 6 timers a times a day! It's my slow season at work, but when this happens over our busy time, it's going…

I have seen, the item cost, Quantity calculated based on Transaction in Sage DB. And that's why In item master table not contains info. for the same. But i want to retrieve item's cost, Quantity, and sale price from the SO/PO Transaction have you any…

Hi, Can anyone guide me how to extract Supplier Direct Deposit tab information from Sage or in which table it exist in DB. Thanks

1) Which table for storing Sales_Order & Purchase_Order in sage-50 database ? for ex: i believe it's store in jrnlRow & jrnlHdr table. is it right ?

Hello all! I'm hoping someone can help me with a database restoration issue. If you want the fine details... just let me know. I'm going to try to be brief here. My client's laptop that had Simply Accounting installed on it crashed. HDD has mechanical…

I am currently running 2015. Trying to clean up space and have several old data verification files taking up space.

I am trying to download the Database Repair Utility. I select Database Repair Utility (Under the Sage 50 Accounting Option)from the Start menu. It takes me to a page where I should be able to Download the Database Repair Utility 2018. I click on Download…

We have an enormous database (3.6 GB) and are trying to pare that down by purging closed years. However, we've found that each time we purge a year, the file size INCREASES. Thoughts??

So over the weekend the company installed a new wireless router and since then none of of clients are able to communicate with the Pervasive Server. I tried restarting the server computer, remapping the network drive, and reinstalling Sage on the client…