Sage 100

Hello, I am a developer, and we have purchased Sage 100 partner account. We want to integrate it with our app. Where we will fetch products related data to our system. However, I am unable to see any help regarding the REST API or integration tool. I…

Hello Everyone, I am trying to figure out how to know what is the cause of an error that will not let my software create a payment record for an incoming Sales Order. The error I got from the business object is: "Error Creating record from table…

Hi all! I'm working with the new BOI capable PR module and having trouble sorting out how to add detail lines. I seem to have worked out creating a transaction, at least the batch I create does end up with an entry for the employee I am adding to…

I am just starting out on my Sage 100 journey to help our Sage admin automate a few processes. So, please bear with me as my knowledge is limited... We are on Sage 100c Premium 2018 (Version 6.00.3.0) I took the Intro to BOI class in SageU which was…

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.

I'm attempting to post a Transaction using sData to the URL of our Sage 100 server and I keep getting the error: " is not on file.Š". This happens only when I have a valid AccountKey in the transaction details section. If I remove the account key I get…

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!

hi, I am new to sage 100 premium erp. I tried to access the ebusiness web services via soapui. But getting the error " An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB; ". Please advice me.

Hi, I am new in sage ERP 100. I want to access sage webservice through SOAP UI. Please find the below Request and response. Please advise where I missed out!!!!!!!! SOAP REQUEST <soapenv:Envelope xmlns:soapenv=" schemas.xmlsoap.org/.../" xmlns…

Hello- I have created some VI export jobs for exporting text files to export Vendors but I notice it only returns vendors for the company the job is being ran under? Is there a way to run one job and get all vendors for all companies? The best thing…

I posted another question some time ago regarding the creation of shipments using BOI, as can be seen here: http://sagecity.na.sage.com/support_communities/sage100_erp/f/100/p/101987/284231#284231 I got this solution to work wonderfully, however I…

I would like to get a list of of AP invoices and their remaining balance. I am using "AP_OpenInvoice_bus" but the amounts do not seem to be returned when using GetResultSets. Below is the column string I am using. Any ideas or perhaps I am using the wrong…

We are attempting to create a shipment for a sales order in Sage100 4.5 using the business object interface, however the "shipping_bus" object does not seem to have any meaningful methods associated with it. There are no articles in the knowledgebase…

Hello, I am using Sage ERP 100 Version 2015 and using BOI to update QuantityBackOrdered on an existing sales order line item. The QuantityBackOrdered is not getting updated in MAS. I am able to change it from the UI. liStatus = gpSalesOrderHeader…

I get an error that says "Cannot communicate with Sage Exchange Desktop 2.0" when initializing AR_CustomerCreditCard_Bus in VB.Net as a Windows Service. I have the sample code attached and the credentials to Sage are hard coded in the Sage100Connection…

I am getting an error when trying to create a sales order with eBWS. I am adding the credit card to the vault using the AddCreditCardToVault method. But when I try to create the sales order I am getting this error message. "Could not set SO_SalesOrderPayment_bus…

Hi, I got this "The Records is not in editable state" Error while delete contact from Ar_CustomerContact_bus object. Please anyone give hint to solve this issue. Thanks.

Hello, I'm inserting invoices for a client and they have requested that they all go into the same batch. I can't figure out how to create a new batch and keep using it. The best I can come up with is creating a new batch for each invoice. I pull…

I'm new to the sage BOI and trying to learn it - I've found the file layouts and object reference in the help. However everyone in these blog posts indicates that it is extremely useful to take the BOI class at Sage University. However the BOI class…

We have a client who recently upgraded from Sage 100 2013 to Sage 100 2016 on the same server. When we call a NewObject using software that we had written in VB.NET on the server, we will get an RPC error at random times throughout the day. I've also…

Hi All, Anyone have an example of this? I need to run/update the AR DTR via BOI and haven not done this before. It looks like there is only one DTR object available (under GL) - I'm assuming one or more arguments needs to be sent during the call to…

We moved a client's Sage over to a new server - They are now using Sage 2015 Advanced. We had a program in place that utilizes BOI and have had a problem since the move. The program uses BOI through BOTH DCOM and 'traditional' - we are ONLY experiencing…

Sage 100 ERP Version 5.00.8.0 The following code fails at the call to nProcessReport returning 0 and LastErrorMessage is blank. using (DispatchObject pvx = new DispatchObject("ProvideX.Script")) { pvx.InvokeMethod("Init", @"C:\Sage\Sage 100 Advanced…

I just spent a few hours troubleshooting something and figured that someone else might benefit from my experience. We have a receipt of goods integration that runs from AP invoices in our ECM system and creates a receipt of goods entry in Sage 100 ERP…

We are on 100 Advanced 2013, and have some automated processes that import sales orders through the BOI. We have a number of repeat customers who have been customers for years, and occasionally they use a card that they have been using for several years…