SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the board
Thread view  Mix view  Order
Rebecca shirzad(R)

02.09.2016, 03:34
 

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

Hi,

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

Thanks , Rebecca

DavidJ(R)

13.10.2016, 06:50

@ Rebecca shirzad

Increase all goods prices by a percentage ( 10%)

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.

JayArr(R)

Mission BC Canada,
12.02.2017, 23:53

@ DavidJ

Increase all goods prices by a percentage ( 10%)

This will round out the price if you like...


update parts

SET listprice = round((listprice*1.10)::numeric,2);

Back to the board
Thread view  Mix view  Order
963 Postings in 317 Threads, 321 registered users, 122 users online (0 registered, 122 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum