Monday, December 21, 2009

Remote warehouses and XML orders. in Golden Inventory System


You can have many storage locations in your company and you may want to automate all. You can use two approaches to this. First, install MS SQL Server and connect to it from all remote locations through the internet. You use one inventory database in this case but you must have a reliable connection to the network in all your branches.Any break down of the internet connection will lead to stop work in your branches.The second approach is that you are installing a separate database for each storage location and synchronize them using XML orders.We consider each location as your customer or reseller. We create invoices when we ship goods to your remote location. We call these invoices as internal invoices and denote their the special group "internal". Then, create copies of these files in XML format. You can download Golden Inventory software for testing this function. You can send these XML invoices via email or on any flash device with a truck driver. Personal of your remote warehouse receive XML invoices and upload them in the local inventory database using the function Add from XML file at a New Item Receipt. You'll have item receipts in remote databases as copies of invoices from the main base. This provides full synchronization of data in the main and remote databases. Golden Inventory has a lot of XML functions and you can create purchase and sales orders in the XML format.This allows you to automate your workflow with remote warehouse.

No comments:

Post a Comment