User:Effecitech - Revision history

Effecitech at 18:21, 17 January 2018

2018-01-17T18:21:22Z

Effecitech at 15:57, 13 January 2018

2018-01-13T15:57:27Z

Effecitech: Created page with "{{Userboxtop}} {{User real name|Fabio Canella}} {{User it}} {{User en}} {{User Facebook|http://www.facebook.com/effecitech}} {{Userboxbottom}} == TIPS == === Document Docume..."

2018-01-10T09:21:39Z

Created page with "{{Userboxtop}} {{User real name|Fabio Canella}} {{User it}} {{User en}} {{User Facebook|http://www.facebook.com/effecitech}} {{Userboxbottom}} == TIPS == === Document Docume..."

New page

{{Userboxtop}}
{{User real name|Fabio Canella}}
{{User it}}
{{User en}}
{{User Facebook|http://www.facebook.com/effecitech}}
{{Userboxbottom}}

== 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

← Older revision		Revision as of 18:21, 17 January 2018
Line 31:		Line 31:
	substring(i.documentno, '[0-9]+$')::int,		substring(i.documentno, '[0-9]+$')::int,
	substring(substring(i.documentno, 3), '[0-9]+') ::int		substring(substring(i.documentno, 3), '[0-9]+') ::int
		+
		+	==Errors==
		+	===IDempiere 4.1 java.lang.RuntimeException: Error initializing storage.===
		+	As suggested here [https://groups.google.com/forum/#!msg/idempiere/O9YdENpYEMs/JmKuniD7CQAJ] you have to delete some files.
		+
		+	sudo -u idempiere find /opt/idempiere-server/ -name '.fileTableLock*' -delete
		+	sudo -u idempiere find /opt/idempiere-server/ -name '.fileTable.*' -delete
		+
		+	In my case this error occur when I'm not using the right Java version.

← Older revision		Revision as of 15:57, 13 January 2018
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===