From: baliboss <it...@ba...> - 2016-03-30 03:14:05
|
Hi Phil, Thank's for the suggestion, Ok, I've got the idea but is it impact to other table ? I've just been try with 201601999, number of invoice maximum is 999 a month. Thank's Ary / baliboss phildaintree wrote > Yes - it can be reset but you would need to ensure you avoid duplicates > ... I'd suggest setting to > > 201601000 > > for transactions in Jan 2016 > then 201602000 for Feb etc - you'd need to be sure there are not more > than 1000 transactions in the month as this will then go to 201603000 > before you've got to March! > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890 > http://www.logicworks.co.nz > > On 28/03/16 23:16, baliboss wrote: >> Dear All user, >> >> Based on our prospectus client request in Indonesia, >> Can the order number or invoice number on webERP reset monthly ? >> or any other work around to to do this ? >> on webERP the number will sequence counter from 1 to next number, >> can I change it to (e.g. 01/JAN/2016/1 it mean's 01 January 2016 order >> number 1) >> >> Thanks in advice, >> Ary / baliboss.com >> >> >> >> ----- >> Baliboss >> Bali Open Source Solution >> www.baliboss.com >> -- >> View this message in context: >> http://weberp-accounting.1478800.n4.nabble.com/Reset-order-number-or-invoice-number-monthly-tp4658567.html >> Sent from the web-ERP-users mailing list archive at Nabble.com. >> >> ------------------------------------------------------------------------------ >> Transform Data into Opportunity. >> Accelerate data analysis in your applications with >> Intel Data Analytics Acceleration Library. >> Click to learn more. >> http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140 >> _______________________________________________ >> web-ERP-users mailing list >> > web-ERP-users@.sourceforge >> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> > > > ------------------------------------------------------------------------------ > Transform Data into Opportunity. > Accelerate data analysis in your applications with > Intel Data Analytics Acceleration Library. > Click to learn more. > http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140 > _______________________________________________ > web-ERP-users mailing list > web-ERP-users@.sourceforge > https://lists.sourceforge.net/lists/listinfo/web-erp-users ----- Baliboss Bali Open Source Solution www.baliboss.com -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Reset-order-number-or-invoice-number-monthly-tp4658567p4658569.html Sent from the web-ERP-users mailing list archive at Nabble.com. |