Difference between revisions of "User:Effecitech"
From iDempiere
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...") |
Effecitech (talk | contribs) |
||
| Line 8: | Line 8: | ||
== TIPS == | == TIPS == | ||
| + | |||
| + | === How Enable Export Record Button === | ||
| + | |||
| + | In order to enable the export button in every window In the Role window you have to enable '''Can Export''' and also '''Access Advanced''' | ||
| + | |||
=== Document DocumentNo Order - Postresql reports=== | === Document DocumentNo Order - Postresql reports=== | ||
Revision as of 17:57, 13 January 2018
|
TIPS
How Enable Export Record Button
In order to enable the export button in every window In the Role window you have to enable Can Export and also Access Advanced
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
