Setup:
C# Framework: .NET Framework 4.8
SDK: ACCPAC.Advantage
Code Context:
OpenView just initializes a session to the DB, there would be no issues behind this - it works just fine with everything.
Important: No errors appear what so ever…
We're currently using the Sage100 C# NuGet package noted below.
We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…
Wrote simple app to simulate login into Sage 300 in C#
i can query the company names... but when i try to actually use a password and login user it gives me Invalid Signon Information error message, anyone know what i'm doing wrong?
session =…
Hi All,
I am having an issue running PO_ReceiptRegister_upd. I am trying to run the Receipt of Goods Register from BOI.
oSS.InvokeMethod("nSetDate", "P/O", date);
oSS.InvokeMethod("nSetModule", "P/O");
//DispatchObject security = new DispatchObject…
I am on Sage 100c Standard 2016 (Version 5.30.5.0) (yes, I know it is very old, and have plans to upgrade to a supported version). I am attempting to create a program in C# that creates a sales invoice from a sales order.
When my program executes the…
I have a C# code that integrates with Sage 100 2021 Standard.
After performing some action I want to clean and close the session I opened. for this I'm using:
session.nCleanup();
session.DropObject();
for some reason the nCleanup() returns null…
Hi,
I want to loop through all my not-registered invoices.
What I do (in general) is:
dynamic obj = pvx.NewObject("AP_ManualCheck_bus", oSession);
obj.nMoveFirst(); //To get to the first record
//Rest of code
The problem is that I have…
How can I access the table object PO_ReceiptReturnMatRqByPO? I need to delete a record from this table which refers to a ghost receipt and locks my PO.
There isn't a file with _bus or _svc, so using NewObject returns "NewObject Error 90".
When I…
I feel like there's something I'm missing.
I can successfully create a Sales Order and a Purchase Order with line items in Sage50 using the .NET API (not ODBC). The issue I'm having is that while the correct vendor/customer are set, the address for…
Hi,
I'm trying to write a code that gets all the invoices which were fully paid. My idea was to take all the invoice and remove all the open invoices from "AP_OpenInvoice".
But, I see invoices in that tables that have 0 balance. So probsbly it doesn…
Hi, I'm trying to write a code to create a new invoice from PO
set the key ReceiptType$
set the key ReceiptNo$
call setKey()
set PurchaseOrderNo$
set InvoiceNo$
Now i want to add the lines of the po to the receipt. In addition, i want…
Hello All! I have an issue with creating a PO via BOI that I was hoping someone can help me with. We're using Sage 100cloud Premium 2019 Version 6.10.4.0. Here's my code:
using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject…
I'm getting this error if I leave off the sales order number. I want to be able to enter the sales order invoice without a preexisting sales order. All the code seems to work and the data is being input into Sage, however the tax fields never populate…
Hello, I have taken over an existing installation that does not have any documentation or support on it. Our website uses a custom sync tool to push orders into Sage. Everyone once in awhile (10% of orders or so), I will see an error, "The column is not…
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…
{solved}
The error was in my KeySet() line. Instead of:
var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey", ""), pcObject).ReturnCode; It should have been:
var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey"…
Experts,
I have a small app that writes to CI_Item. It has been working with no issues in Sage 100 v2017 Premium for my client in a Sage Server / Terminal Server setting. Now they are on v2020 Premium in the same setup (new servers), but we are running…
Environment: IIS, .net CORE ASP.net web API, ProvideX.Script COM object (Sage 100/ MAS90 2018 v4.5), Server 2012 R2.
Starting with the workaround first: so far my workaround has been to allow my IIS identity pool ID full access to the DCOM computer…
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…
Hello,
We have encountered an issue when validating addresses where the FOB and ship method are automatically changed after validation is complete. Is there a way to prevent the FOB & Ship Method from being restored to default?
Thank you for your…
I see some older threads discussing some in-progress ideas people were working with, as well as some libraries on the nuget packages out there - but there is no documentation on them that I can see. Does anyone have a recommended usage for them? Have…
Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…
Has anyone used a software package that integrated with Sage 500 ERP for creating Requisitions outside of Sage and then generating Purchase Orders in Sage? What software did you use? How did that process go? Any recommendations or precautions?
Hi
I have written a windows service that speaks to Sage 50. It runs on three computers. On only one computer, I see this in the logs:
2020-07-09 11:01:27.277 -04:00
[DBG] Could not load file or assembly 'Sage.Peachtree.Domain,
Version=2020.2.0.219…