Browse By Tags

Hi, We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations. We have a few questions: Can we use SQL to set up an ODBC connection? …

We are having issues with our Procore Connector so we are trying to troubleshoot the issue. Procore is saying it is a Sage issue but since we can't get any support with this I am trying to rule out everything I can. We did review our Event Log and are…

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…

Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…

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?

Hello, I have Fedex Ship Manager software and I am trying to integrate it with our Sage X3 software using ODBC and SQL. I am only able to see sys tables when trying to link. I even set up a new user in SQL manager with full rights. The Fedex software…

We have an application that wraps around the Sage 100 data base using the Sage 100/Providex 64-bit ODBC driver as a linked server to an instance of MS SQL Server 2014 Express 64-bit. Various views are then defined against the S100 tables in the SQL Server…

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…

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…