• System.IO.IOException: The process cannot access the file c:\sage\peachtree\company\~PVSW~.LOC because its being used by another process

    I am having an issue even beginning an api session from the code below I get the above exception. The Actian Zen workgroup Engine has a lock on the file. // the main session into the Sage 50 application PeachtreeSession apiSession = new PeachtreeSession…
  • Marking Jobs as inactive

    Hello, I have several (over 1000) jobs that I have to mark as inactive soon and can't seem to find a way to do this using the SDK. Unfortunately this is not a feature built into Sage 50 at the moment and marking jobs as inactive one by one takes a long…
  • I/O Error on API call after server migration

    Recently, we had a client's Sage 50 server migrated. A full backup of the company file was taken, moved to the new server, and then the backup restored overwriting the company directory on the new server. We are able to log into the Sage 50 company on…
  • How can I get the last date the item was updated in the inventory?

    Hi Expert, Currently, I need to get last date and time the item was updated in the inventory and date and time when the item was created ,I did not find the field related from the method which can get the inventory information supported in the Sage…
  • COM API - switch company without open UI

    Hi, there, I am trying to see if we can using COM API to switch company without open Sage UI. The APIs we're looking are: OpenCompany and OpenCompanySecure Anything will help! Thanks
  • 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…
  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
  • 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…