7.23 ***What conditions need to follow in order to do the Export & Import XML from Different SQL Accounting Database?***
Below is the list of conditions need to be follow...
1. The ALL the Master/Maintenance Tables (eg Customer, Supplier, item Code, etc) is MATCH with SOURCE SQL Accounting Database.
2. Tick the option at Tools | Options | Customer | Use Cash Sales No. for Payment Received for both SOURCE & TARGET Database.
3. Tick the option at Tools | Options | Supplier | Use Cash Purchase No. for Payment Paid for both SOURCE & TARGET Database.
4. Make sure both SOURCE & TARGET Database is using different Set of Running Document Number.
5. Backup the TARGET SQL Accounting before begin to import.
6. Make sure both SOURCE & TARGET Database is using SAME SQL Accounting Version.