Skip to Content
0
Former Member
May 27, 2008 at 11:31 AM

SQL script to automate Price List update

47 Views

Does anyone know the SQL script to update Price Lists? We have an Inter Company Price list which is setup as Last Purchase Price x Factor (1.1). I fear that this has to be run frequently to update the Items where new Purchases have been made. I'd like to have a script that I can setup as a job in SQL and run every evening so that the Price List remains as up to date as possible.