Sage 100

I need to get customer data from sage100 using .Net code. I went through https://help-sage100.na.sage.com/2018/FLOR/index.htm but could not understand the functions as there was no clear instructions. I managed to get data from two columns using a sample…

Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…

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…

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

We have a customer that just upgraded their Sage 100 product to the 2020 version and are seeing some issues with integrating to our product. They migrating from Sage 2016. Below is a code snippet of where the issue is coming from. The error is “CI_NOF…

Hello, I already made some vbscripts, I'm trying to build a c# .net application, on examples I saw "STAThread", is there a specific configuration to use this or COM? 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 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 =…

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 All, I have a custom module installed in Sage 100, I need to do insert in it using BOI script. Is anyone has any Idea how I can achieve it? your reply will be Appreciated Thanks, SF

Hello, I have tried looking though out the forums for a way to select a batch number to use when trying to import invoices into Sage 100. What I have found was to use SelectBatch and pass the batch number I want to use as the parameter, but when I do…

Did they drop the prerequisite for .net 3.5 and 4.x in Sage 100 2018? Was just looking at the supported platform matrix and noticed there doesn't appear to be a reference to it anymore? Or is this an oversight in the documentation?

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.

Verify the application is installed and running. Contact Sage 100 Customer Support if the problem persists Has anyone seen this error before? It is happening when I try to write a sales order with SO_SalesOrder. It happens on the nWrite. It actually…

Hello, A client of mine owns SAGE 100 i7 and I wonder whether it's possible or not to access his data from outside (from a webserver hosted in Azure) like the bank transactions... Any idea? Thanks in advance for any help. Best regards…

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!

I am new to BOI. I have figured out how to pull customer data using AR_Customer_svc. Where do I find a list of services for other tables such as Terms, Salespersons, and Tax Schedules? Thanks in advance!

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…

Years ago our master developer provided us with a copy of Interop.ProvideX.dll for a .net application we have. The file is from 2009, it works with Pvxcom.exe. We are having issues with this version (leaving too many copies running, crashing in the middle…

I have an external program linked to Repetitive invoicing. I need to associate the program to repetitive invoicing by passing parameters. How to pass the Customer Number listed in the data reference as parameter to a command script ?

I am working with an integration that was previously working (nothing was changed in the code). An order is created in Sage 100, and I then go to set the SalesOrderNo as part of a new Invoice/Shipment in code, and this should load in the line items…

I am trying to create a new batch and use the SO_Shipping_BUS object to process a sales order automatically through Shipping Data Entry. The code works if I use SO_Invoice_BUS, but not for SO_Shipping_BUS. When I try to set the invoiceNo key, I get…