User:Effecitech
From iDempiere
Revision as of 11:21, 10 January 2018 by Effecitech (talk | contribs) (Created page with "{{Userboxtop}} {{User real name|Fabio Canella}} {{User it}} {{User en}} {{User Facebook|http://www.facebook.com/effecitech}} {{Userboxbottom}} == TIPS == === Document Docume...")
|
TIPS
Document DocumentNo Order - Postresql reports
If you have a sequence like that:
IN123/17 Where IN is the document name (IN for INVOICE) 123 is the document number counter 17 is the year
if you want to have ordered reports you could use a query like this:
select * from c_invoice i where issotrx='Y' order by substring(i.documentno, '[0-9]+$')::int, substring(substring(i.documentno, 3), '[0-9]+') ::int
