Sage 50 US

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…

When I query JRNLHDR for payroll entries, AccountNumber1 - AccountNumber4 look like Base64-encoded values. I tried straight Base64 decoding but that returned gibberish characters. I'm guessing they are encrypted then encoded. Are we supposed to be able…

The COM API has a GetAccountingPeriods function. Is that information available via the ODBC interface?

Hi, Understanding the standard ODBC connection does not allow Write permissions, however i would like to know if there is a possibility of setting/creating a user which would have the permissions to write to the JrnHdr table, specifically the Comments…

While creating and saving invoice to Sage 50 using SDK i occasionally get below error message - " Reference number is not unique for this customer or vendor. Reference number is used by another customer or vendor ." Not sure what this error message…

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…

LoadbyName is the only method I can find in SDK. Can anyone tell me how to get customer details by his Id and then update. ?

Can anyone tell me is there any table where I can query recent activity (Insert, Update) in Sage 50 ?

What is the TimeStamp field format when using MS Access to link to the AUDITTR.DAT (Audit Trail) table? I can’t determine how to convert the TimeStamp field to a usable date/time format. When running the canned Sage report, it shows the date/time correctly…

Greetings, I'm looking for the table/column that holds the reference to the value of the 'Directory' field as seen on screen Maintain > Company Information if anyone can help. Thanks, Scott

Is there a way to import a PO Change Order into Sage 50 via the com sdk? I don't see it on the list that can be passed into the CreateImporter function.

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…

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…

Greetings, Our product allows a user to push invoices from our system in to a Sage 50 system. We use the .NET SDK for integration. We're having problems at a specific customers site. The scenario is as follows. The user "closed" out some books (I…

Hello, Currently, I created a C# project for getting Purchase Order, Sales Order values in sage 100, and used PO_PurchaseOrder_bus, SO_SalesOrder_bus business object interface to get these values. shall I use the same business object interface to…

Hello, Is there a possibility to add/update items in Sage 50 via SDK? I know there is an option to make use of COM API to do this. But, wondering, if this feature is available in latest Sage 50 SDK (Version 2020). Thanks!

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…

We are using COM API to export G/L Trial Balance data from sage. We are getting current balance but we require last year ending balance, so anyone have any idea to fetch last year ending balance through COM API for trail balance.

Hello, I can't seem to find how to set the phase and cost code for a PurchaseOrderLine object with the SDK. I can set the JobReference just fine but I need to be able to set the phase and cost code as well. Am I missing something or is it not possible…

Hello, I would like to search out a sales order with using .NET SDK. I don't know how to search out the sales orders by ship to name or address. Is there any example? I was trying this code, Dim fType As String = "" Dim fString As String = TextBox3…

Is there a way in the SDK to read the pay types along with the custom names associated with them? If not, is there a way in the Sage 50 application to export the pay types? I've searched all of the options, but I can't seem to find it. Thanks.

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

Hi, Sorry if this is the wrong forum but I did not find a better match. I have a client currently using SAGE 50 2018 that is considering upgrading to SAGE cloud, and we need to know if there is a way to import invoices and export customer data from…

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…

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…