HI All! We've put together a netcore API hosted on IIS for integrating with other tools we have. All of our services on the API are scoped to give the requests their own instances and dependencies. public static void AppServices(this IServiceCollection…
I have the following code to create a session.
Session s = new Session(); s.Init("", "XY", "XY1000", "67A"); s.Open(User, Password, Company, DateTime.Today, 0);
A client had been using ADMIN/ADMIN for the username and password (don't ask why they…
My apologies if I'm not in the correct forum for this. (It seemed to match the best from the list I was presented with.)
I'm looking for documentation on building modules to run from the Sage 100 desktop. I've taken a number of the courses (including…
We have a customer that just upgraded their Sage 100 product to the 2020 version and are seeing some issues with integrating to our product. They migrating from Sage 2016.
Below is a code snippet of where the issue is coming from. The error is “CI_NOF…
Hi,
I've been working on automatic registration of transactions for Bill of materials.
but I've been encoutering this issue for a couple of days now.
its been throwing me an error that says "Invalid or missing posting date encountered"
I opted…
Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries.
here's what I have coded:
oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI"))
objTransactionRegister =…
Hi,
I've been wondering for a couple of days now. it seems that the Distribution line is adding a bunch of numbers on my Lot.
retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456")
oProduction.oLines.oDistribution.sLastErrorMsg says…
Hi All,
I have a custom module installed in Sage 100, I need to do insert in it using BOI script. Is anyone has any Idea how I can achieve it?
your reply will be Appreciated
Thanks,
SF
Hello Friends,
I am using SAGE 2019.1 SDK for importing invoice in my application. I am getting error at the time of SetShip date "The field you are trying to change or function you are calling is not accessible under current circumstance.". I am getting…
var companyId = GetCompany();
try { // Request authorization from Sage 50 for our third-party application. AuthorizationResult authorizationResult = Session.RequestAccess(companyId);
This line Session.RequestAccess throws a PeachtreeException: FileNotFound…
Years ago our master developer provided us with a copy of Interop.ProvideX.dll for a .net application we have. The file is from 2009, it works with Pvxcom.exe. We are having issues with this version (leaving too many copies running, crashing in the middle…
Hi,
A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having.
We are trying to create POs, Time records, and add Cost Codes to the DB.
Reading…
I am working with an integration that was previously working (nothing was changed in the code).
An order is created in Sage 100, and I then go to set the SalesOrderNo as part of a new Invoice/Shipment in code, and this should load in the line items…
Hi,
I have sage 50 accounting, the data are on a local server (within same network). We have no issue with the performance when using Sage 50 but when using the SDK it's really [:@]tooooooooooooo[:@] slow
Listing companies takes 45 seconds!
Finding…
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…
I have an Application ID and I can start a new session and open our production company, but every time I (or anyone) runs this c# .net app it always says that I have to open Sage and allow access. I open Sage and select 'Always Allow' but we have to do…