• Non-existent items

    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…
  • BOI Update Receipt of Goods Register Sage 100 Premium 2022 BOI

    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…
  • C# Create Sales Invoice From Sales Order; nSetKey() fails, sLastErrorMsg = "The [InvoiceNo] is invalid"

    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…
  • Cleanup() returns null

    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…
  • Looping a table while batches enabled

    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…
  • Access PO_ReceiptReturnMatRqByPO

    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…
  • AP_OpenInvoice with balance 0

    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…
  • creating a receipt of invoice with BOI

    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…
  • Creating PO via BOI Write Issue

    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…
  • Missing record to calculate taxes, Sales Order Invoice.

    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…
  • Logging to find cause of "The column is not in the IOList."

    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…
  • Documented needed to help create new modules

    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…
  • Trying to set pricing, "The Price Code Record is Required" (even though it's set)

    {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"…
  • Exception on nWrite in CI_Item in C#

    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…
  • DCOM permissions and BOI

    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…
  • sage .NET libraries for c#

    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…
  • Set Sage field equal to UDF (user script?)

    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.…
  • Unable to newObject the AR_Customer_bus

    Hi all, I'm experiencing issues trying to new up a AR_Customer_bus object, my eventual aim is to be able to create a new customer using the BOI. The error I'm getting is a 200 error. This is my code so far, also note that I've written this off the…
  • Sage 100 Export Sales Order to File BOI

    Hello, I am having difficulty getting some code to work. I have found examples, but translating it to C# is making it harder to solve the problem. I am trying to export a sales order through the SO_SalesOrderPrinting_UI BOI. the following settings…
  • Ar Cash Receipts using BOI

    Hi community! I need some help. I have an almost perfect code here in C# posting a payment in cash receipts. The only problem is that the batch amount is duplicated. The batch total is $520.00 instead of $260.00. What am I doing wrong? Here…
  • Collaboration sought for Import of SO Invoices from XML file with BOI

    I am hoping there is someone out there with an ability and willingness to help me. As a Master Developer with have not really had much need to develop things using BOI since we can always modify the code if needed. We have taken the class and we are…
  • Create a Credit Card Sales Order in Sage 100 ProvideX, C# using SO_SalesOrderPayment_bus business object?

    I have recently found how to add a new credit card to Sage100 and the exchange vault without using the exchange vault’s extra UI, screen. I insert new cards into the system behind the scenes using my own custom windows software written in C#. I now need…
  • 3rd party integration with sage 100

    Hello Everyone, I am trying to build a 3rd party C# application for my client on sage 100, i read several things but was not able to achieve this, i have been trying few sample codes to connect with sage using BOI but i am not able to read data from…
  • Providex OLE Server Assistance

    I need assistance setting up the Providex OLE Server. Is there a support number I can call to speak with a developer to help my make sure everything is setup properly. I'm trying to do some integration work for a Sage 100 instance hosted on a cloud…
  • BOI access of Sage 100 instance hosted on cloud server

    Looking at the C# example provided with the Object Interface course there is a portion of code that points to the MAS90\Home folder, pvx.InvokeMethod("Init", @"C:\_WORKING\90W420-0607\MAS90\Home"); how would I accomplish this if my Sage 100 instance…