We have a Warehouse Management System (WMS) that is a Saas Web Application (not an intranet hosted web app) that is external to our company's network and firewall.
We want to integrate it with a local Sage 50 instance.
Our thought was that we needed a "go between" desktop app that would call the web wms web services to push and pull data from the cloud WMS and then communicate locally with Sage 50. This is how Quickbooks architecture is when you want to integrate it's desktop app to a web service...except they provide that go between application (Quickbooks Web Connector). I believe Sage does not, so we'd have to write it. Thoughts on this architecture...are we on the right track or is there a Sage solution that will act as this "go between" middleman app?
Next hurdle: Inventory Adjustments
The .Net API shows that it doesn't support inventory adjustments.
Thinking we could handle most inventory adjustments like posting receipts to increase inventory from purchasing and posting Sales Invoices to decrement inventory from sales like the below high level process flows
Inventory Increments from Purchasing:
- Create PO in Sage
- Import PO into WMS from Sage
- Create Receipt in WMS
- Post Receipt against PO to Sage (increments inventory)
Decrementing Inventory from Sales Orders:
- Create Sale Order in Sage
- Import Sales Order into WMS from Sage
- Perform pick, ship operations in WMS
- Post Sales Invoice to reflect actual shipped items (decrements inventory)
How does that sound so far?
Next...generic inventory adjustments as a result of damaged goods, cycle counting, etc. Any ideas on how to handle these types of adjustments via the .Net API? A bit hacky, but maybe having a blanket PO and Sales Order to post to for increments and decrements?
This next question will show I'm primarily a web app developer...so sorry if it is rudimentary. I see the COM method does allow inventory adjustments, but haven't used this type of technology before....can I use it in conjunction with this "go between" .NET windows app that I discussed earlier?
Thanks in advance,
Chad
