Skip to Content
0
Former Member
Mar 04, 2009 at 02:50 PM

DTW - import sales rows using BP Catalogue Numbers

62 Views

Hi, I hope that someone can shed some light on this issue.

I need to import data into a new Sales document that is received from a customer in an excel sheet. I have set up a BP Catalogue Number series that maps our OITM ItemCode to their item code, now how can I use DTW to import the data on an excel sheet and use the customers item codes rather than out OITM ItemCodes?

Which template can be used so that the SubCatNum field in the rows is populated through DTW?