SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

Increase all goods prices by a percentage ( 10%) (General)

posted by DavidJ(R), 13.10.2016, 06:50

Hi,

Hopefully some one can help, I need to increase all prices for all stock on
sql-ledger by 10 %.

Thanks , Rebecca

IF you're familiar with postgresql and SQL-L, you could try something like :

UPDATE parts SET sellprice = sellprice*1.1

Or use listprice if thats what you want.
Warning. Don't try this at home without adult supervision.
If you break something, don't blame me.

 

Complete thread:

Back to the forum
Board view  Mix view
986 Postings in 325 Threads, 327 registered users, 112 users online (0 registered, 112 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum