on 09-08-2008 10:48 AM
hi all,
How to upload prices of all the items in price list using DTW ?
What are templates used for it ?
Item masters were already created.
Jeyakanthan
The other option is just using "Import from Excel" under Administration - Data Import/Export. Only Item, BP are available with this utility.
It might be more convenient for those who need to update the list more often since you can update price list easier than DTW once you complete the first round setup.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gordon
I tried updating a pricelist using "import from Excel"
My excel table had four columns:
Column A: item code
Column B: Pricelist number
Column C: Price
Column 😧 currency
I kept getting an error that there was something wrong in row 1. So I put 1s in row one of each column. Still got an error but the prices updated. However all the barcodes for the updated items are now blank.
Any idea what went wrong?
what other data could have been blanked?
Is there a fix to reverse?
Regards
J.R. Naik
use the template
'C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oItems\Items_Prices.xlt'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot gordon,problem solved.
Jeyakanthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
same error message occurs.
Jeyakanthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks you all for replies,
But the error message appears in log as
update failed docentry cannot find this object in
B1 application-defined or object-defined erroroItems.
Jeyakanthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Which option to select in DTW import business object/update busienss object,because item master already created ?
Jeyakanthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Create two Excel templates 'Items.xls' and 'Items_Prices.xls'
Since you have already imported items, just have the record key and item code alone in the 'Items.xls' . For example:
RecordKey.......ItemCode
1.......................I0001
2.......................I0002
In the Items_Prices template, Fill Pricelist Number fromOPLN and Price of the Item
RecordKey....LineNum......Price
1......................1..............350.00 (Means for Item I001, Pricelist 1 is updated with 350)
1......................2..............300.00 (Means for Item I001, Pricelist 2 is updated with 300)
2......................1..............550.00 (Means for Item I002, Pricelist 1 is updated with 550)
2......................2..............600.00 (Means for Item I002, Pricelist 2 is updated with 600)
In step 4 of DTW, Choose
Check - Update Exisiting Object
Uncheck - Import New Object
This should update the pricelist alone for the items
what is line number should i fill it for price list number 1 on item prices template ?
Jeyakanthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what are the other templates should i use with Item prices ?
Jeyakanthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You will need to fill two templates for Item Prices import through DTW
Items and Items_Prices
In the Items template you will need to fill the
RecordKey.......ItemCode
1.......................A0001
In the Items_Prices template, you need to fill the
RecordKey....LineNum......Price
1......................2..............20.00
NOTE: You need to enter the Pricelist number in the ListNum column
Suda
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.