Sage 100

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/.../

Hi, I have a script to add manualChecks to Sage100. It works. I want to register the checks through in the code. I tried to do it with the code I used to register invoices: invoice.nSelectBatch(batch); invoice.nSetPostingDate("20270531"); invoice…

Hi the team, I am a developer and we use SAGE 100C in my company. I want to learn how to use BOI for some scripting tasks and integration. After strugling in searching on the web. I have found this forum. Can someone help me to find either an online…

hi, Greetings !!! I want c # sample code through which i can create invoice entry through object matrix dll for sage 100

I have a UDF on SO_Detail table I'm attempting to populate with a BOI script (written in C#). This field is set to datetime type, the data I'm sending is being parsed from string to datetime format in the script. I'm sending the SalesOrderNo, user credentials…

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 have the code below for automatic registration/update of the production transactions. I've been getting an error on the UpdateInit method. oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister = oScript2.NewObject…

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 there's a way to get the latest revision number from A Bill of Materials. I've tried to get the value by uising oProduction.nGetValue("Revision$", strRevisionNo) but im still getting the "000" revision number. Thanks…

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 =…

What is the best way to pull CustomerShipToTaxExemptions from Sage 100 using C#? Below is my code to create a session and pull the dispatch object using ui and bus but it throws this error- **** From ProvideX: Lookup program failed. The task id "000000000…

Hi, I've been wondering for a couple of days now. it seems that the Distribution line is adding a bunch of numbers on my Lot. retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") oProduction.oLines.oDistribution.sLastErrorMsg says…

Hi, So i've been trying to put an entry on BOM Produciton entry, it seems to be having an error with the Distribution part. (im using an item with Lot Valuation) retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") retVal = oProduction…

Hello, I have used many of the BOI objects without any issues, but when retrieving inventory value with IM_ItemWarehouse_bus, none of the quantity is fetching correctly. It always returns 0 value, I am using ItemCode/WarehouseCode combination to set…

Hello, We have an eCommerce web application built-in in Ruby on Rails. And, we need to integrate Sage ERP with our ruby server, Which will fetch products data from Sage ERP and writes orders data to Sage ERP? We have installed Sage ERP on our windows…

Hello Everyone I am New to the sage and looking for the C# integration with sage to read inventory data for the client. Our client have the SAGE 100 ERP software . Can anyone help me this and provide the some links for the same.

Hi, I got this "The Records is not in editable state" Error while delete details from SO_SalesOrderDetail_bus object. Please anyone give hint to solve this issue. Given below is my code int TaskID = (int)oSS.GetType().InvokeMember("nLookupTask…

Hi ALL, I want to get the order item's linekeyno using BOI script, is anyone has idea? How I will achieve it? Thanks, SF

I recently took the BOI course on SageU and have been educating myself in how to use the BOI COM interface. I'm finding that there seems to be a real need for a .NET (or CLR) library that abstracts away the COM implementation so that we can just work…

Hey all, I’d like to look up a Sale Order using C#, any clues would be greatly appreciated. Thanks!

We have an external program writing to Sales Order entry using BOI, The order gets written correctly but it doesn't update the next sales order number. oPvx = CreateObject("Providex.Script") oPvx.Init("\\MAS\Sage Software\2014\MAS90\Home") oSS = oPvx…

I am trying to import a sales order with payment details. The credit card is already authorized in 3rd party system (eCommerce), i want to save the Authorization code and Transaction Id in Sage so that while invocing we can capture the amount. But payment…

Hi All, I am working on a task where I need to transfer stock from one warehouse to other warehouse using BOI interface script but I am getting the error "ŠA valid warehouse must be entered at the Transfer To Warehouse field". Is anybody has any idea…