Hi Experts,
I created an integration that pulls CSV files with AP Bills from an FTP server and imports those into Sage 100. Every time the script runs it imports 20 to 50 AP Bills. The bills are often for different company codes, so the integration…
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 working Receipt of Goods Visual Studio VB console app. It's an integration project. I have a textfile that has the receiving data. It's easy enough to MoveFirst and MoveNext and match the text data to the PO Line using LineKey (or I could use…
{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"…
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…
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…
I'm using Business Objects to import sales orders from our point-of-sale system. I have worked all of that out except sometimes the price at the cash registers has been modified from the item price so I need to specify a price per line rather than getting…
I thought this would be easy but could use some insight to get this working. I have *.bat file that launches an external process related to AR Invoice History data. I'd like for the bat file to launch when SO Invoices post. I found some previous comments…
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…
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…
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…
