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…
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…
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…
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…
{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"…
Hello,
We have encountered an issue when validating addresses where the FOB and ship method are automatically changed after validation is complete. Is there a way to prevent the FOB & Ship Method from being restored to default?
Thank you for your…
Has anyone used a software package that integrated with Sage 500 ERP for creating Requisitions outside of Sage and then generating Purchase Orders in Sage? What software did you use? How did that process go? Any recommendations or precautions?
Experts,
I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…
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…
I'm trying to set invoice object to a single record and not having much luck. What I'm trying:
oSS.nSetProgram(oSS.nLookupTask("AR_InvoiceHistoryInquiry_ui"))
Dim oInvoices As Object = oScript.NewObject("AR_InvoiceHistoryInquiry_svc", oSS)
oInvoices…
I am new to Sage and we are looking for Sage500 API documentation because we need to pull data from Sage into a different receivables application. I have been looking around on the website and cannot find anything and I have made 10 calls to 10 different…
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…
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…
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…
Trying to integrate Sage 500 A/P with a third party application that drips a batch file into FTP. Sage 500 processing is already automated to process the batch, but it needs something to allow it to automatically retrieve the file from the FTP server…
i am trying to integrate sage 500 with my application , but i am unable to find from where i can download sage 500 sdk ....can any one help me out ?
thank you
I need to start programming in sage 300. Typically programs that import etc. What software do I need and where can I get a good tutorial on this? I have no starting point.
Hi,
Does anyone have any recommendations for Online Portal and/or Ecommerce Integration with Sage 300?
Requirements:
1. It must integrate with Sage 300.
2. Integrate with Ariba and Ariett
3. Be able to take Credit Card Payments
4. Be able…
I have been trying to create a customer in Sage 500 by means of sage provided stored procedures. To start with, I have my own stored procedure which creates a record in staging table, ie. stgCustomer. Thereafter, I invoke a stored procedure(api by Sage…
We have an existing payment engine that processes credit card and checking. I have created the ability to lookup invoices with a balance, "grab" all the details and offer customer payment through other means. Now I need to bring the payment information…
I recently started working with sage 500 api which is really a set of stored procedures. At this stage, I want to create/update a customer as well as the corresponding contact. Does anyone have any idea of what stored procedures to use for this purpose…
Hello,
We are a distribution company that is looking to implement a WMS that can integrate with Sage 100. Preferably one that can stand alone as well. We are going through some growing pains and may also be looking to a new ERP in years to come. May…
Hi All,
I've used the BOI extensively a couple of years back to create Sales Orders, Invoices and Customers in the AR module. I thought that Sage had upgraded ALL the modules to the 4.x format and would be supported by the BOI but I just sat down to…
Community,
We are a mid-west manufacturing company and are looking to implement the JobOps product with barcoding using JOScan. We are hoping to find another company presently using JobOps with Sage 100 ERP that might be willing to share their experience…