Connect to MAS 90 from ASP
Sage MAS 90 ERP and Sage MAS 200 ERP have an e-Business application for users who wish to have an internet store for customers (B2B) and consumers (B2C). These are great, out of the box, applications if you want to keep your site simple and to the point. Most everything is configured through the accounting interface. HTML can be added in the descriptions to give the site a custom look without having to have a programmer develop your shopping cart. During the check out process it will charge the credit card with Sage payment services or PcCharge and all the transactions flow through the accounting system No import or export. It is really a great application but like I stated before it is a very basic, out of the box, solution. It lacks in Search Engine Optimization (SEO), Suggestive Selling, Social Media Links, Tell a Friend/E-Mail info, PDF of page, Human Readable URLs, and many other features and functions that most of today’s commerce websites have.
Due to this limitation of the basic out of the box solution, customers have:
- Modified the built in e-business templates with HTML code to create some of these functions.
- Export to SQL or Access and develop a website accessing the data from those applications and importing into sales orders.
- Customize the ProvideX code that the application is written in.
- Wrap e-business within another site.
- Create a site using ASP to read ODBC direct from the application. Then importing or filling in the shopping cart for the user to check out using built in function.
There might be combinations of the above list or others that I have not listed. MBA was working with a client trying to create the ASP read from ODBC and we realized that there were a few people out there trying to figure out how to do this. This blog will document a few key elements needed to read from the ODBC driver using ASP. This is for version 4.x or greater. Hopefully this will help others trying to do the same thing. This is not meant to be the only way to do it nor the correct way to do it. It is just one way that we did it and it worked.
Links: MBA Business Software – ASP Web Applications accessing MAS 90
© 2009 – 2010, Todd Martin. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.
« Business Insights Explorer (BIE) | Home | “Data Entry in Progress” During MAS90/MAS200 Period End Processing »
Leave a Comment
You must be logged in to post a comment.