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…
I'm trying to create a production entry. It works fine if I add lines but if I don't add any lines I get an error message saying I need at least one line. In the Sage UI you can select a Bill Number and it pre-populates the lines, I'd like to do the same…
Hello, getting an error: Invalid or missing header on the code below- can anyone provide a working example of creating a purchase order in BOI? using (var sySession = new MasSession(homePath))
{
sySession.InitSession(sessionLogon);
CI.ColumnNames…
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…
When attempting to create line items for a Inventory Transaction Receipt batch I'm having issues when I attempt to update the distribution. my code was working on Sage 2018 but they are upgrading to Sage 2021 and it now throws an
System.Runtime.InteropServices…
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,
We are looking for consultant to help in installation of Sage API into our sage 100 2020.
Please check below link for understanding:
www.sagecity.com/.../getting-started-with-the-sage-100cloud-custom-connector-for-the-microsoft-power-…
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…
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…
{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"…
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…