Sage 50 US

Good day Fellas :) looking for anyone who can help :), i'am having a problem regarding with our companies' sage 50, my users are trying to generate crystal reports using their workstations but unfortunately it is asking for a database password which…

Hi, We use the sage sdk framework for a tool who works well, but for 90% of installation case, we have a "Sage.sdk.singleton" during the connection process. In local, we can bug fix this by reinstall Sage. but for our clients, that's more complicated…

I have multiple copies of our company loaded on a standalone PC, basically a separate company for every two years (so 2012+2013, and then another company for 2014+2015, etc). I have renamed each company appropriately internally within PT (such as ABC…

I'm trying to create a report that shows any sales invoices or vendor invoices that do not have an attachment (our documentation). I'm looking for the table that stores all attachments (i.e sales invoices, vendor invoices) and the key field for that…

Hi I'm using Windows 8.1. Sage 50 US, installed as client/server but on the same computer. I am the only user, an administrator. I have activated Sage security and added a couple of users: Admin and anotherm on two Sage test companies and can log in…

I have a report I've been running for a few years now and as of August it no longer works and I can't see that anything has changed with my information to cause it to fail. When I try to refresh the report data, a box pops up for the OLE DB Provider.…

I have this error message accesing Sage50 via ODBC. Any know what means?

Can someone provide a general SQL script/statement that I can use to extra basic inventory data from the Sage 50 Accounting (2016) database? All I really need are things like the part number/Item ID, description, Active/Inactive, and price levels (price…

So I have a small bit of code that shows me how to read basic sales order information (bill-to, ship-to, date of order, etc) from Sage 50 Accounting (US edition) using an ODBC connection. I have that part down, but what I need to be able to do now is…

I need to find which tables Item Qty on hand and item cost are . Using Access ODBC, and need to extract Inventory Stock status data for connecting to Power BI. Any help?

I have been finding recently that on certain computers, Crystal Reports will give an error message if I don't uncheck the box “Use indexes or server for speed” in the Report Options. Unchecking this makes the report run much slower. At one client I…

I am following the documentation provided with the SDK download. I have been able to successfully begin a session but all of the factory lists are empty. For example when i am in the Sage 50 accounting interface there are many vendors listed but when…

Client just upgraded to Sage50 2016. We created a new ODBC Connection and all reports work except on. It does not like the Peachtree Additional functions even though they show in Crystal reports. (One is just for the Company name) Even if I remove…

I am looking for some help connecting Sage 50 2013 to SQL Server. Inside SQL Server Management Studio I would think the best way would to make Sage 50 a linked server. The Sage database resides on another physical server from my Management studio. I have…

I've asked a similar question earlier regarding the database layout/design and got a piece of code from someone (which I will paste below). This piece of code gets the Shipping info, the order number, and other info. What I'm looking for is how to get…

Is there a way (and I imagine there is) to read the Ship-To name and address information for a particular sales order from the peachtree database to an external application using the Sage 50 SDK? I will basically be using an ODBC connection to the Peachtree…

Did I lock down the data set? Was trying to trigger launch of End of Year Wizard, it did not launch and I closed program because each time I open program it would prompt to run End of Year Wizard. This is only site I use Peachtree at - all other sites…