Browse By Tags

  • System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at AccpacCOMAPI.IAccpacSession.GetPrintSetup(String menuID, String ProgramID)

    accpacSession = new AccpacSession(); accpacSession.Init("", "XY", "XY1000", "67A"); if (!accpacSession.IsOpened) { Console.WriteLine("open"); accpacSession.Open("ADMIN", "ADMIN", "SAMINC", DateTime.Today, 0, ""); } if (accpacSession.IsOpened) { Console…
  • Integration With Sage 50 US . SDK .NET vs COM

    Hello, What are the options for integrating with the Non -Cloud , Desktop Version of Sage 50 ( US Edition ) ? I was able to download the Sage SDK which has .NET and COM samples. The .NET version does not support a number of transactions/ entities…
  • Import Unit Cost for Inventory Adjustments with the COM API

    I'm trying to import the Unit Cost field among others for Inventory adjustments via the COM Interface. For some reason this one field likes to remain at 0.00 even when making a positive adjustment with a value greater than 0.00. Here is an example of…
  • RPC_E_SERVERFAULT

    Hi , I am getting RPC_E_SERVERFAULT error while I am trying to exporting the data using COM API C# code. I am able to login into Sage using APIs,I can delete the transaction but the Specifically I can not do the export and getting this error. …
  • GL Source Codes

    Hello Everyone, How we can get the data from Sage 50 US ( Accountant Edition 2019) ) for GL Source Codes, Hierarchy of Account Segments using COM API or .Net API?
  • Cleansing data submitted by users in the COM API

    Securing web applications can be tricky. One surefire way securing the system is to lock it in a box, where no-one can switch it on, much less enter data into it. Unfortunately, this is not the making of a useful CRM system. In Sage CRM there is a feature…
  • Viewing the Sysadmin screen within a CRM session

    One request we receive on occasion is how to view the Sysadmin screen when you're not logged on to the CRM server. The sysadmin screen retrieves a list of currently logged-on users from the eWare DLL (as opposed to the Activity table), and also gives…
  • Working with Default Company Addresses

    If you need to list company default/main addresses you can link from the Company to the Address table. You don't need to link to the address_link table. The address link table is used to keep details about the alternative addresses that might be stored…
  • Update invoice using COM APIs Code.

    Hi All, I am trying to update invoice in Sage 50 US using COM APIs PeachWServer DLL. but it won't getting update, Can anyone help on this or give me comment or hint to resolve it? Thansk, SF
  • What is the Filed for Expense account for Vendor on Export when using the COM API

    Using the COM API, I was able to export VendorId, VendorName. But when it tried to import Expense account, I was not able to distinguish which peachwIEObjVendorListField to use. So, I tried to use Exporter.AddToExportFieldList((short)PeachwIEObjVendorListField…
  • How to overwrite the sales tax using sdk

    We want to be able to write the Sales tax of a document back to sage using a third party application. From the .net dll, we have understood that the sales tax can only be calculated but not written to. But we want to know if there is any way we can edit…
  • My COM User ID and Password do not work

    I'm trying to use the sample COM project CSSDK and am having trouble logging in, I'm trying to log in with the User ID and Password I was sent by sage support to access the COM interface but I get the "Access is denied." message. What am I doing wrong…
  • 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…
  • Importing purchase, additional line items

    I am writing an application which interacts with Sage50 2016. I have full access to both the .NET and COM APIs. My current task is to import purchases (PurchaseInvoice in the .NET API, PurchaseJournal in the COM API). Since the .NET API seems to be…