Price List Update Error through DTW

[former_member225732]

Hi Experts,

    I am importing Price List in SAP B1 9.0 PL6 but it gives me error "This Entry Already Exist in the following Tables(ODBC-2035) 65171"

    I ready on SCN but not get proper solution.

    Can anybody can help me...

Regards,

Sandesh Shinde

[S0009633597]

Hi,

it is also very easy to imort prices with the function  "import from excel" in SAP.

This also can do by the customer.   But dont forget a Backup from the Database before you import the new prices.

Kind regards

marco

[former_member224264]

Greetings.

Instead of using DTW, use the feature of import from excel in the Administration module.

just create by selecting items and pricelist.

make a template of pricelist no, item code, price and currency.

upload thru import from excel feature.

this would help.

Regards.

[KennedyT21]

Hi Sandesh..

• In SAP Business One Data Transfer Workbench after Version 2004, the PriceList or PriceListName column is not required in the Items_Prices template.
• To comply with other item templates, SAP Business One Data Transfer Workbench uses the field LineNum to index the sequence of the price list.
• The LineNum starts from '0' which indexes the first Price List in the database.
• Using the # column(Red selection) in the screenshot below the LineNum is the # number minus(-) 1. For example, 0 for Base Price, 1 for the Discount Purchase Price and so on. Following this logic, please note that in this example the LineNum for New Price List02 is 6.

• To update a pricelist you need to enter the PriceList LineNum in the LineNum column. If the PriceList or PriceListName column is present, data should not be entered in the column.
  

Example:

An update is required to the price lists "Base Price" and "New Price List02" from the screenshot above. The update requires the Currency set to "GBP" and Price set to "10"  for Item A00001 in both Price Lists.

Set the data file Items_Prices as follows:

ParentKey,LineNum,Currency,Price,PriceList

ItemCode,LineNum,Currency,Price,PriceList

A00001,0,GBP,10 A00001,6,GBP,10

[Former Member]

Truly outstanding. 

Set up a bunch of templates, don't document their usage to any real extent, leave a few cryptic comments in the spreadsheets to indicate some form of compliance to the table structure, and then implement an inconsistent method of updating/adding one of the most important data items in the system. 

The only clue to how it truly works being hidden amongst a pile of questions, making whomever should find it both incredibly impressed at their own powers of detection, and utterly desolate at the level of "support" offered.

I guess it's never been properly mentioned, but I'm hoping that you support guys realise that people actually run their businesses with this software...

You must be very proud.

[julie_jamieson2]

You do realise that the people that answer your questions are not employed by SAP and are generally customers / partners giving their own time to help?

[Former Member]

Hi Julie (and everyone)

Forgive my childish rant, the product of a couple of wasted hours fighting with SAP.

The criticism is aimed directly at SAP, and certainly not at the kind folk in SCN that help me with my idiot questions.

[former_member225732]

441154404901A	19	21200	INR
542110109503A	18	76	INR
542154204901A	5	15500	INR
542154600102A	5	1000	INR
542154600101A	5	750	INR
542182104915LBRA	9	300	INR

[kothandaraman_nagarajan]

Hi,

Please refer thread http://scn.sap.com/thread/3436856

Thanks & Regards,

Nagarajan