I need to write back to a Sage 50/Peachtree sales order database written in MYSQL. We have a product that reads from Sage 50 ALL order information including Ship-to address and Line Items. Our system then generates shipping labels for UPS, FedEx, US Postal. Currently we can not write back the tracking # and price to Sage 50/Peachtree using the SDK because the SDK does not allow it without deleting the entire order and recreating it. So, I need a programmer that can show us how to access the Sage 50 MYSQL database and update the sales order header with Freight amount and post the UPS/FedEx tracking #'s to the notes field. Programmer can provide samples and explain how to update Sage 50 MYSQL existing orders.
NOTE: Sage 50 MYSQL database is locked and I don't know how to access it directly. This will need to be explained to me.
Hello Sir, I have worked with Sage 50 integration in past and can certainly help you in this regard. I worked on a product called BatchMaster which is an ERP system that integrates with Sage. Thx Aanvik