I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table).
Here is the information that…
I'm working on the integration of Sage 50 CA with a third party application with .NET. And price levels are within the required information extracted from the database Sage 50 CA, but so far I have not found any information to verify the existence of…
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…
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…
Hi All,
I am getting the message Strong-name signed assemblies must specify a public key in their InternalsVisibleTo declarations. when I am calling OpenSalesJournal in the 2015.3 SDK. The call stack is:
System.MethodAccessException: [F:\Development…
Hi,
I tried to connect to Sage 50 2016 but It is impossible, when I compile my code, I get this error:
Error 4 The type or namespace name 'Sage' could not be found (are you missing a using directive or an assembly reference?)
It is a little weird…
I am creating an automated import of Purchase Invoices for a client who is using Peachtree 2008 Premier, and I've downloaded Sage 50 2016.0 SDK.
I'm using the credentials that were provided when I downloaded the SDK and the function returns NULL. When…
I'm writing an application in VB.NET to run custom queries against the Sage 50 database. I've gone through the SDK manuals, but have some additional questions while walking through the sample code. We run the connection manager on the server and install…
I have a program that uses the COM SDK to import (Update) the Employee list with Hours and Payrate. We converted from 2012 to 2015. I updated the program to use the 2015.2 SDK. But I get an error when trying to Import:
EmpEE Fld2-Calc Name
I don't…
Hi,
I have a problem about getting the data of the "Contact" filed on Maintain Vendors window of the software through the .Net SDK. I have searched the attribute values under the vendor object, and cannot find the right value for this attribute shown…
Currently i am working on a program meant to create purchase orders using excel files to import some data into said order. So far the only problem i seem to keep having is that certain things, such as the Term and Address fields have a "Character limit…
I am a senior developer who is VERY new to Sage. I haven't ever used it or even seen it. A client wants me to use the SDK to get some very basic invoice and payment information out of Sage 50, but even the "Getting Started" info around here seems a little…
Hi,
What is the recommended way to set the ReferenceNumber when creating a new SalesOrder. Currently I'm doing this:
var invoiceList = sageCompany.Factories.SalesOrderFactory.List(); invoiceList.Load(); var top1 = invoiceList.OrderByDescending(x …
Greetings all,
We're using the .NET SDK to create Sales Invoices programmatically. I see that within Sage 50, the Sales Invoice itself has a Ship Date, but it's not a field I can appear to set via the .NET SDK. (It's not a parameter within the Sage…
Hi,
A client need to create an automatic service to create a file with all the invoices in a time range.
I tried the ODBC connection but can´t see any table with the invoices information.
Is that possbile with the .net Api or the SDK? and where…
Hi, I am developing an application to enter an invoice to Peachtree using the API .NET SDK for Sage 50 2013 , and I want to set the date due into the invoice object ( I noted that the property is visible and it can accept a nulleable value) but when I…
Just curious what happened in the 2014 .NET SDK for accessing the identifier for an address?
Now it appears you can only access the Contact identifier....
It seems odd that Sage would completely remove that unless I'm missing something. The latest…
The company that creates the interface between our hotel property management system software and Sage 50 (Peachtree) has their interface developed in .Net 2.0.
Is there an SDK for Sage 50 Premium that will work with .Net 2.0?
We want to upgrade to…
Hello,
I was prompted to perform the upgrade to 2014 Sage-50 US Edition. Was prompted to convert database. Afterward, when I attempted to use the Sage .NET API to talk to it, I ran into errors...
Sage.Peachtree.API.Exceptions.UntranslatedException…
Hello,
Am using the .NET API to create sales invoices in Sage. However, am getting the following error when I validate() or save() the sales inventory:
Sage.Peachtree.API.Exceptions.ValidationException was unhandled by user code HResult=-2146232832…
Hello,
I recently subscribed to the Sage Silver Partner program. I have installed the Sage-50-US 2014 app that came with the program. I have also opened the sample app CSSDK that utilizes the COM interface SDK (because I want to create/import Purchase…
Hi,
On a Sage 50 2013 installation I cannot get the "allow access" dialog to display for a given company file. I tried the same on one of the sample companies and got the dialog as expected.
I found a post http://sagecity.na.sage.com/support_communities…
We installed the sage50 and SDK in 5 machines now, we are trying to make a VS2010 web project to work with the sage50 sdk. Of the 5 machines 2 are w7 32-bit and the proyect works fine, on the other 3 w7 64-bit we are getting a " Unable to load DLL 'w3dbav90…
Hi, I am new to Sage Peachtree SDK, and I am trying to develop a tool that export data from Peachtree to other system.
I have a list of InventoryItem and I want to know where do we get the U/M value for a single InventoryItem. For example: 'Each', …
