https://wiki.idempiere.org/w/api.php?action=feedcontributions&feedformat=atom&user=Effecitech 2026-10-01T08:32:50Z User contributions MediaWiki 1.35.2 https://wiki.idempiere.org/w/index.php?title=User:Effecitech&diff=2537 2018-01-17T18:21:22Z

<p>Effecitech: </p> <hr /> <div>{{Userboxtop}}<br /> {{User real name|Fabio Canella}}<br /> {{User it}}<br /> {{User en}}<br /> {{User Facebook|http://www.facebook.com/effecitech}}<br /> {{Userboxbottom}}<br /> <br /> <br /> == TIPS ==<br /> <br /> === How Enable Export Record Button ===<br /> <br /> In order to enable the export button in every window In the Role window you have to enable '''Can Export''' and also '''Access Advanced'''<br /> <br /> === Document DocumentNo Order - Postresql reports===<br /> <br /> If you have a sequence like that:<br /> <br /> IN123/17<br /> Where IN is the document name (IN for INVOICE)<br /> 123 is the document number counter<br /> 17 is the year<br /> <br /> <br /> if you want to have ordered reports you could use a query like this:<br /> <br /> select *<br /> from c_invoice i<br /> where issotrx='Y'<br /> order by <br /> substring(i.documentno, '[0-9]+$')::int,<br /> substring(substring(i.documentno, 3), '[0-9]+') ::int<br /> <br /> ==Errors==<br /> ===IDempiere 4.1 java.lang.RuntimeException: Error initializing storage.===<br /> As suggested here [https://groups.google.com/forum/#!msg/idempiere/O9YdENpYEMs/JmKuniD7CQAJ] you have to delete some files.<br /> <br /> sudo -u idempiere find /opt/idempiere-server/ -name '.fileTableLock*' -delete <br /> sudo -u idempiere find /opt/idempiere-server/ -name '.fileTable.*' -delete<br /> <br /> In my case this error occur when I'm not using the right Java version.</div>

Effecitech https://wiki.idempiere.org/w/index.php?title=User:Effecitech&diff=2536 2018-01-13T15:57:27Z

<p>Effecitech: </p> <hr /> <div>{{Userboxtop}}<br /> {{User real name|Fabio Canella}}<br /> {{User it}}<br /> {{User en}}<br /> {{User Facebook|http://www.facebook.com/effecitech}}<br /> {{Userboxbottom}}<br /> <br /> <br /> == TIPS ==<br /> <br /> === How Enable Export Record Button ===<br /> <br /> In order to enable the export button in every window In the Role window you have to enable '''Can Export''' and also '''Access Advanced'''<br /> <br /> === Document DocumentNo Order - Postresql reports===<br /> <br /> If you have a sequence like that:<br /> <br /> IN123/17<br /> Where IN is the document name (IN for INVOICE)<br /> 123 is the document number counter<br /> 17 is the year<br /> <br /> <br /> if you want to have ordered reports you could use a query like this:<br /> <br /> select *<br /> from c_invoice i<br /> where issotrx='Y'<br /> order by <br /> substring(i.documentno, '[0-9]+$')::int,<br /> substring(substring(i.documentno, 3), '[0-9]+') ::int</div>

Effecitech https://wiki.idempiere.org/w/index.php?title=User:Effecitech&diff=2535 2018-01-10T09:21:39Z

<p>Effecitech: Created page with &quot;{{Userboxtop}} {{User real name|Fabio Canella}} {{User it}} {{User en}} {{User Facebook|http://www.facebook.com/effecitech}} {{Userboxbottom}} == TIPS == === Document Docume...&quot;</p> <hr /> <div>{{Userboxtop}}<br /> {{User real name|Fabio Canella}}<br /> {{User it}}<br /> {{User en}}<br /> {{User Facebook|http://www.facebook.com/effecitech}}<br /> {{Userboxbottom}}<br /> <br /> <br /> == TIPS ==<br /> === Document DocumentNo Order - Postresql reports===<br /> <br /> If you have a sequence like that:<br /> <br /> IN123/17<br /> Where IN is the document name (IN for INVOICE)<br /> 123 is the document number counter<br /> 17 is the year<br /> <br /> <br /> if you want to have ordered reports you could use a query like this:<br /> <br /> select *<br /> from c_invoice i<br /> where issotrx='Y'<br /> order by <br /> substring(i.documentno, '[0-9]+$')::int,<br /> substring(substring(i.documentno, 3), '[0-9]+') ::int</div>

Effecitech