Sign in

Microsoft.com

Microsoft

Remove From My Forums

pricelist item price update

Question
0

Sign in to vote

We've got about 3000 different products. Each month we get a new price list from our supplier. The prices of the price list items then needs to be updated accordingly.

How can I update these items? Downloading the file and updating each record manually is going to take forever, so I need a more automated way.

Thanx

Please vote if you find my post useful. Add me on Skype @ christo.skype1

Wednesday, April 2, 2014 9:55 AM

All replies

0

Sign in to vote
Hi Christo,

you may use a BULK update on directly on Database. In my company we have the same problem and the ways are two: or manually o you can create a small script to make a bulk update..

Bye

Alessandro

Alessandro Graps
- Edited by [MVP] Alessandro Graps Wednesday, April 2, 2014 10:52 AM error in words
Wednesday, April 2, 2014 10:51 AM
0

Sign in to vote

Ho does the bulk update work? Also, can you assist with the script? Thanx
Please vote if you find my post useful. Add me on Skype @ christo.skype1

Wednesday, April 2, 2014 12:14 PM
0

Sign in to vote
This company makes an add-on that can do price list updates: http://www.dynamics-pros.com/products/2013/price-list-utilities
Jason Lattimer
My Blog - Follow me on Twitter - LinkedIn
- Proposed as answer by JLattimerMVP, Moderator Wednesday, April 2, 2014 12:50 PM
Wednesday, April 2, 2014 12:50 PM

Moderator