View unanswered posts | View active topics
|
Page 1 of 1
|
[ 3 posts ] |
|
| Author |
Message |
|
pvassalli
|
Post subject: Sequence Posted: Sun May 22, 2011 5:26 pm |
|
Joined: Thu Dec 03, 2009 4:30 pm Posts: 18
|
|
In sale_order_line (postgres db) I insert: nextval('sale_order_line_insertion'::regclass) But inside the program I always get 10 and it is not incrementing the value. How do I achieve the mess?
|
|
| Top |
|
 |
|
gdaddy
|
Post subject: Re: Sequence Posted: Tue May 24, 2011 10:04 am |
|
Joined: Wed Jan 27, 2010 6:21 pm Posts: 797 Location: Auckland, NZ
|
|
I think you are getting sequence confused with sequences. Given you are doing nothing more than incrementing the sequence and the default is to order by sequence, then id, there really isn't any point to the incrementing in the first place.
_________________ Graeme
|
|
| Top |
|
 |
|
burbuzzi
|
Post subject: Re: Sequence Posted: Sun Jun 19, 2011 3:26 pm |
|
Joined: Tue Oct 06, 2009 10:33 am Posts: 35 Location: Ukraine
|
|
Hi gdaddy.
Did you find any solution for your problem (automatic sequence increment)?
Firstly I'll describe some my situation (sales model). I'm selling spare parts for agricultural machines. I get a requests for quotation from client and make offer for him. The products list is splitted on some parts in my offer depending on machine model or machine bundle so lines order is very important because it should go directly as it's needed. I'm using sales_layout module for sequences in sales orders but I found it very anoying to put the number all the time by hands especially if you have to make offer for about 200 positions. Also sometimes clients add or deduct some positions. In this case I need to have some gap between seq. numbers to add product in right place (with deduction there is no problems).
I think the right way is to mention "sequence" as function in sale_layout.py of a sale_layout module (at least I'm using this module). For me solution will be to get sequence with some incrementing value, say 10, so we would have 10, 20, 30... product lines sequence values (offcource with possibility to change by hands).
Any thoughts?
_________________ Best Regards, Eugene Babiy
Sales/Purchase Manager Agrolinii LLC. Kiev, UKRAINE
|
|
| Top |
|
 |
|
Page 1 of 1
|
[ 3 posts ] |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum
|