I haven’t made a lot of progress, but I did examine the problem in detail for a (potential) client, and the issue is that it is a pretty large project, even ignoring the fact that MAS 90 uses a proprietary data storage system (ProvideX)
Firstly, you need the get the data out of MAS 90 into MySQL, and In-Synch by ROI-Consulting is the perfect tool to do this automatically. (full disclosure, I’m the original co-developer of In-Synch, but I no longer own part of the product) Or you could use visual integrator or even crystal reports to do it manually, but in the long run those are time consuming options if you are doing a full integration.
Note that this (MAS 90’s proprietary data storage system) isn’t necessarily a bad thing - a nice, well defined interface between the accounting database and the e-commerce application that is under control of the accounting app is, IMO, a good thing.
Once you have your data in a SQL database, then you need to write a number of custom modules, assuming that you want to ensure that an order entered from Magento will have the same prices, etc as one entered in MAS 90, and assuming that you want to display open orders, shipping history, etc. In-Synch can replicate all the required data to the MySQL database, including the IMB_PriceCode table, for pricing, IM2_InventoryItemWhseDetl for inventory quantities, and all the invoice history, sales order (open and historical), AR_Customer, ship-to addresses, etc.
Firstly the data from MAS 90 tables such as Customer that have existing counterparts in Magento needs to be reconciled and the Magento modules need to be modified to work with this additional information.
Enhancements to show the user their open invoices, payment history, shipping history, etc need to be made
A custom pricing module needs to be created that uses customer price level information and information in the inventory master table and the IMB_PriceCode table to calculate customer specific pricing (this is probably the biggest one)
...and a bunch of other stuff
On the face of it it looked to me that to do a full integration correctly was in excess of a 100 hour project. I’m interested in discussing this with someone if we could figure out a way to fund it. I’ve been modifying and implementing MAS 90 for over 20 years and I do a lot of PHP / MySQL development.
If anyone is interested in discussing this further, send me an e-mail at , maybe we can get something going.