Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007539Openbravo ERP07. Sales managementpublic2009-02-12 16:412009-04-20 15:16
plujan 
alostale 
highmajoralways
closedno change required 
5
pi 
 
Core
No
0007539: The standard filter that shows only last week Sales Order has gone
On Sales Order, the grid has a filter by default so you will see only the orders created on last week. Since now, that filter has gone and you see all the orders.
1. With orders created in (at least) last two weeks, Enter Sales Order in grid mode.
2. Check that you see ALL the orders (wrong)
3. Enter filter and filter by last week orders. Now you see only last week orders.
Default behavior of Sales Order grid is that you would see only last week orders.
No tags attached.
depends on backport 0008479 closed alostale The standard filter that shows only last week Sales Order has gone 
Issue History
2009-02-12 16:41plujanNew Issue
2009-02-12 16:41plujanAssigned To => rafaroda
2009-02-12 16:41plujanRegression testing => No
2009-02-16 09:09rafarodaAssigned Torafaroda => alostale
2009-02-16 09:09rafarodaStatusnew => scheduled
2009-02-18 17:54alostaleStatusscheduled => closed
2009-02-18 17:54alostaleNote Added: 0013683
2009-02-18 17:54alostaleResolutionopen => unable to reproduce
2009-03-18 11:02anonymoussf_bug_id0 => 2691389
2009-04-07 10:58rafarodaStatusclosed => new
2009-04-07 10:58rafarodaResolutionunable to reproduce => open
2009-04-07 10:58rafarodaNote Added: 0015245
2009-04-07 10:58rafarodaSeveritycritical => major
2009-04-07 10:58rafarodaStatusnew => scheduled
2009-04-07 10:58rafarodafix_in_branch => pi
2009-04-17 16:41alostaleNote Added: 0015407
2009-04-17 16:41alostaleStatusscheduled => feedback
2009-04-20 15:16alostaleStatusfeedback => closed
2009-04-20 15:16alostaleResolutionopen => no change required

Notes
(0013683)
alostale   
2009-02-18 17:54   
I'm not able to reproduce this behavior in current trunk (r13303)
(0015245)
rafaroda   
2009-04-07 10:58   
I've been able to reproduce it changing date and time formats in my Openbravo.properties:

####################
# Date/time format #
####################

dateFormat.js=%d/%m/%Y
dateFormat.sql=DD/MM/YYYY
dateFormat.java=dd/MM/yyyy
dateTimeFormat.java=dd/MM/yyyy HH:mm:ss

bbdd.sessionConfig=select update_dateFormat('DD/MM/YYYY')

Seems to be working only with date format: DD-MM-YYYY
(0015407)
alostale   
2009-04-17 16:41   
I've tested with that configuration in PostgreSQL and in Oracle and it is working fine for me.

Please confirm it does not work.

Just some clarifications:
-The number of DAYS (note that it is not weeks) since last transaction it is defined in General Setup || Application || Session Preferences || Session Preferences, please check it is correct.
-This default filter uses UPDATED column not DATEORDERED which is the one used in the filter in the toolbar, thus it is expected to obtain different result with these two filters.
-Note that sample data now is loaded by DAL and it does set created and updated dates to the creation date, thus it is normal to see all records just before creating database.