[Vtigercrm-developers] Inventory numbers for the modules PO, SO, Quotes and Invoice

[Gopal]

Hi,

I think it is better to retain the crmid as it is and and provide another column for serial number in each module with auto-increment facilitiy. I would like to have the Serial Number configurable as given below:

Serial Number = Prefix (Auto Incremental Number) Suffix 

With this option, users can define their own Prefix and Suffix and auto incremental number according to their requirements.

As suggested by Aissa, numbering based on date also prevailing in some parts of the world. In fact our finance guys (vtiger) are sending invoices to our annual support customers based on the date but they are currently using MS XLS for this purpose. But we have to see how complex it is to handle the serial numbers based on date.

Thanks,
Gopal

----sergiokessler at gmail.com wrote ---- 

aisa, funny that your invoice # 2206061 is *greater* than 0107061...

can't you use yymmdd ?
in that case, at least the numbers are in a progressing sequential...

mickie, I think is great to provide the serials numbers, but you are
also preserving the crmid, right ?


/sak

On 6/21/06, Abos <webmaster at vtigercrmfrance.org> wrote:
> Hi Mickie,
> lot of company here use ddmmyyN°quoteoftheday
> My first quote of today have the ID : 2106061
> 21 (for today) 06 (this month) 06 (this year) 1 (first quote today)
> My first quote for tomorrow will be :
> 2206061
> Same thing for invoices...
> so the first invoice for today as the same N° as the first quote of today.
> You can also add I/Q/P/S for begin or finish the N°
> Q2106061
>
> Regards
> Aïssa
>
> Mickie a écrit :
> > Dear Team,
> >
> > we have a plan to provide the serial number (ie., auto increment
> > number ) for PO, SO, Quotes and Invoice based on your openions.
> > As of now the crmid is used as PO id, SO id, quoteid and invoiceid
> > where as these ids will not be sequencial for each module. The first
> > invoiceid will be 100 and the second invoiceid may be 250, etc.,
> >
> > To avoid this problem, we will configure the starting number for each
> > entity (salesorderid, purchaseorderid, quoteid and invoiceid). After
> > configured this starting number for each module when we save the
> > corresponding entity this id will be incremented where as we will get
> > the ids as a sequencial one.
> > In the mean time shall we provide this id as editable where as if the
> > user want then he will change the id when creating new entity.
> >
> > For example, if we configured the invoice starting number as 00123
> > then the forthcoming invoice ids will be like 000124, 000125, etc.
> >
> > or
> >
> > we can leave as it is and you can add a customfield to handle this.
> >
> > Please do post your suggestions so that we can finish it off early.
> >
> > Thanks
> > Mickie
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Free web-based spreadsheet application from Zoho. Create and share spreadsheets online using Zoho Sheet - http://zohosheet.com?vt
>
> _______________________________________________
> Free web-based spreadsheet application from Zoho. Create and share spreadsheets online using Zoho Sheet - http://zohosheet.com?vt

_______________________________________________
Free web-based spreadsheet application from Zoho. Create and share spreadsheets online using Zoho Sheet - http://zohosheet.com?vt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20060621/ecd3fde1/attachment-0003.html