• Accessing customer aging information

    I am looking for the correct way to access aging info for each customer in my instance of Sage 50. I currently run a query that pulls info from the customer table (odbc), and am wondering if the aging information is in a separate table, and how to go…
  • Table for Recent activity Log

    Can anyone tell me is there any table where I can query recent activity (Insert, Update) in Sage 50 ?
  • How to set date range for customer export? sage50 api question.

    Im exporting sage50 customer details in this code. Please let me know how can I set date range to the exporter object so that will pull only contact updates within certain dates. Code- exporter = (Export)ptApp.CreateExporter(PeachwIEObj.peachwIEObjContactsList…
  • Sage 50 2019 SDK Release Date

    FormerMember
    FormerMember
    Hey there. We recently updated our Sage 50 Accounting software from 2018 to 2019. Naturally, the software we use that integrates with Sage is now unable to connect and sync data. Is there a current release date for the Sage 2019 SDK or is there a…
  • SDK and Updating Employees

    FormerMember
    FormerMember
    When we hire new employees where I work, we have to create accounts in all kinds of different programs. Plus create windows accounts and email accounts. I wrote a Information Management Program that I have connectors to all our programs (all Microsoft…
  • Getting PeachTree API exception - Entity is read-only

    FormerMember
    FormerMember
    The company account is accessible through the desktop Sage 50 US Edition just fine. When we try to access through our app that uses Sage API to access it gives the following message. ANyone knows what the issue is? WIndows 2012 Server R2 Sage 50…
  • Sage sdk singleton error

    FormerMember
    FormerMember
    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…
  • Sage 50 Accounting database table layout?

    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…