right now i would like to display the internal key of the sales tax table OSTA, we sell in 9 different states and manually changing rates takes forever. i'd like to use the dtw to accomplish this task.
You can use the query generator to do this.
Just enter the OSTA Table and place all fields into the query, this will show the codes as well as the other fields.
You can export the reuslt to excel which is a great starting palce for your DTW import
Does this help?
thanks i think this will help, but i was expecting the iternal key to be a document number similar to the number we need to import incoming payments.