Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Sage 100 Code: CI_ValGrpPORequired,
Message: A purchase order number is required. when calling nSetValue with parameters InvoiceNo$, {InvoiceNumber}
Could anyone please help me with the meaning of the error code CI_ValGrpPORequired. I have made…
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…
I've been working with the Sage 100 BOI for some time now and have done a lot of C# applications that interact with the BOI for all sorts of Sage 100 integrations. As we all know the "API" is pretty clunky. I thought about creating a class Library that…
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…
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…
Is there anyone that can help with providing an example of creating an AR Invoice with lines/details in C# using either BOI or the nuget package www.nuget.org/.../
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…
Looking for a Microsoft Power App expert who can develop a power app application that will fetch data from the SQL database in bulk and then send that data to Sage 100 ERP via Sage 100 API connector which is already installed. Data to be picked and sent…
We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
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 working on an integration for a client and am trying to create PO Receipts using c# and Sage 100's BOI. The end result shows the vendor when I look at all PO Receipts, but the receipt is empty when I view the full receipt
Here are the current…
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…
Hi
I am trying to create an order using C# but I get an error with the "invoke" as below
An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll Exception has been thrown by the target of an invocation…
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…
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.…
Hi,
I've been encountering the error "ProvideX object has been released" on posting production entries.
Im using BM_Production_bus and BM_Bill_bus, and dropping those objects if there's any error/component mismatch on the BOM.
Thanks!
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 wondering if someone else encountered or might have a solution for this.
Im getting the error "The register must be printed prior to posting"
oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI"))
objTransactionRegister…
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 =…