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.
Good Day,
I hope this message finds you well. I am currently facing an issue with a control I've created in MS Access that interacts with Sage100 (Standard 2020 v6.20.4). I'm reaching out to seek your assistance in resolving this matter.
The control…
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…
Hi Team, Please, help me with this scenario.
Scenario:
Order is already created in the ERP
Using BOI, write an Invoice to ERP that Integrates into an Order (The invoice will contain the Order document number(DO_Piece)). a) This invoice can also…
I am writing an API in C#.net, that POSTs sales order entries to Sage 100, using BOI. I am using much of the same code that I've used for other integration projects with success. The client for this project is upgrading to Sage 100 2022 Premium- and testing…
We are encountering an issue where CIM Cloud web orders are successfully pushing to the ERP Driver but is failing to create a BOI session. Any suggestions on what other pieces we can troubleshoot before reinstalling the ERP Driver?
What we have tried…
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…
Hello,
We just recently upgraded to Sage 2018 to 2021 and our third-party web service(Deposco) sale order imports are now having issues after migration.
Error response: FAILED : Exception: Error trying to set property BillToZipCode$ with value 46550…
I am new to this so please bear with me. I have the following script ( i can only post a portion of the code. The SPAM blocker flagged it as malicious) that is used to update two UDF fields from a .csv file. It is called via a custom application. I am…
We have no issues creating AR invoices in the ProvideX library with Sage 100 Advanced. We have several clients using our integration (all with Advanced). We were told our code would not need to change to support Premium (SQL). After setting up Premium…
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/.../
We have a python (3.10) application that we want to use to create a sales order in Sage 100.
I have installed pywin32 so the python script can access win32/COM.
This code works up to the point where I try to call a method on the SY_Session object…
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…
Is there a way to get a list of all the business object names for a table from the Sage 100 BOI? The SY_File object from the FileObj property on the session object seems to have methods to get a list of all the table names. Looking to expand on that where…
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…
Hi all, I'm in need of some guidance and help as I'm stuck in my process of inserting an SO Invoice using SO_Invoice_Bus that includes non inventory (like misc or charges item)
these items are in sales order with 0 quantity and need to be in the invoice…
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-…
I created a receipt of invoice, applied PO to it, changed some info- and in the end I called
record.nWrite();
where record is the pvxDynamic representing PO_Receipt_bus. I know that after the write, I have a new receipt in Sage and it's valid
…
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…