Browse By Tags

  • Failed to Import the ActiveX Control

    Over the last couple of years, some partners have had an issue where they were not able to add a VB OCX to a WinForms screen as they would receive a message from Visual Studio stating : "Failed to import the ActiveX control. Please ensure it is registered…

  • 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…

  • Writing /C comment to sales order

    Is it possible to write a "/C" comment line item to a sales order using BOI? If so how? The VB code I am currently using is more or less this modulo checking response codes and logging: Dim oSOrder As Object Dim sItemCode As String Dim sQuantityOrdered…

  • 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…

  • If anybody meet the same problem?

    I meet a wired problem when I am upgrading export interface for Sage 50 2016. I am not sure what is the exactly reason cause the problem even I seemed find a solution. I just public some codes here, could anyone take a look and give me any advice? I modified…

  • Where stored the data returned by the function wSDBFetchRecord ?

    I'm trying to extract data from tables in the database Sage 50 CA 2016, with a Visual Basic application that uses the SDK Sage 50 CA (Simply.ConnectionManagerService.dll). I'm using the function "wSDBSelectRecords" to extract the data And then I 'm…

  • How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

    I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax: Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True) But I do not know how to capture the data you are going to select in a DataTable. I´m Working…

  • Error: The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

    I developed a console program using COM to connect to Sage 50 and import several data files. I tested the program in two machines (a desktop: Windows 7 & 64bit / a terminal server=Windows 2012 & 64 bit), and it worked fine in both machines. Now I tested…

  • BOI for Volume Pricing Check

    Hello All, I'm using the code below to determine whether volume pricing exists for an item, but I'm getting a retval of 0 when I know there is pricing configured. My code and the record from Data File Display and Maintenance are below. Also, I have…

  • Sage 50 2014 COM

    I developed an windows application using VS 2005 in XP with COM, and it has been working fine, but when I try to develop the same functionality in an windows application using VS 2010 in Windows 7, COM reference "PeachTree Accounting 21.0 Type Library…

  • Code For Sales Order CRUD Using Business Object

    This BOI is driving me nuts. You just cant tell why something is not working. Would someone be willing to post full code examples for Sales Order CRUD Operations? What I need to do is: Create the original Sales Order Update the Sales Order Add…

  • Sage 50 SDK

    I am trying to figure out how to use the Sage50 SDK with either VB or VFP. So far haven't been able to get it to work. Any help would be appreciated.

*Community Hub is the new name for Sage City