Hi Ann!
You will need to prepare two files and then upload them through the DTW.
First file just needs two columns, RecordKey and ItemCode:
| RecordKey | ItemCode |
| RecordKey | ItemCode |
| 1 | ALA001 |
| 2 | ALA002 |
| 3 | ALA004 |
Second file needs to link the RecordKey to the price list, price and currency:
| ParentKey | LineNum | Price | Currency |
| ItemCode | LineNum | Price | Currency |
| 1 | 0 | 699 | USD |
| 2 | 0 | 449 | USD |
| 3 | 0 | 799 | USD |
The ParentKey in the prices file corresponds to the RecordKey in the first file. The LineNum corresponds to the price list number from OPLN (I have seen this not match exactly in 9.X versions so make sure you test.
When I'm trying to find out which price list I need, it is occasionally necessary to make a simple set of files like the following:
OITM:
| RecordKey | ItemCode |
| RecordKey | ItemCode |
| 1 | ALA001 |
ITM1
| ParentKey | LineNum | Price | Currency |
| ItemCode | LineNum | Price | Currency |
| 1 | 0 | 1 | USD |
| 1 | 1 | 2 | USD |
| 1 | 2 | 3 | USD |
This file above, when you change "ALA001" to some test item will give you an idea of which price list you need to use. So when you upload this via the DTW it will set price list 0 to $1 and price list 1 to $2 and price list 2 to $3. You can add rows if you need but with some newer versions it has been more difficult to match up the price lists simply by using SELECT * FROM OPLN.
Once you have the above information and you know the price list number you want, then you go back to my first example and set the LineNum to the correct number. This way you are 100% sure you are updating the right price list.
You can update multiple price lists at once as well. Just make sure you sort the spreadsheet by ParentKey and LineNum. If the different price lists are out of order I have seen it cause issues.
If you are not familiar with the DTW, you need to download and install it first, Run as Administrator. Login to your test db first then click "Import." Following the prompts you will go "Master Data," next "Update Existing Data," next "Inventory >> Item Master Data" and next. Click the "Items" ellipses button [...] and attach the first file with the itemcode listing, then click the [...] for "Items_Prices" and attach the second file.
Click "Next" again and you should see your columns align with the system columns. Click "Next" and then click "Simulate" which will run through the system and validate your file. If it runs into 10 errors it will stop and you can check the failed records to see what you did wrong.
Once ready just click "Next" again and it will import. Make sure you do this on a test db first and make sure you cross-check 10-15 items to make sure you have the right information going to the right places.
Hope this helps! Let me know if you have any more questions,
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.