c2c-oerpscenario team mailing list archive

["Ferdinand @ Camptocamp" <850752@xxxxxxxxxxxxxxxxxx>]

thanks

1) Warehouse>Reporting>Inventory Analysis
the grouping does not work correctly currently (can not group by location AND product - its always product/location regardless in which order the buttons are pressed) so I can not try and confirm

1a) IMHO nevertheless needs a button "Show only not zero" (default ON) , because all products where in=out will be shown with 0 Quantity - in the long run almost every product.
(instead of making everyone create/save a function "Quantity is not equal 0" - which of course works here as qty is a DB (view) field)

1b) the result of any grouped views as "Inventory Analysis" can neither be printed nor  exported for further processing
- a missing feature 

BTW we are working on a XML/CSV export utility which is started by a wizard and runs on the server to avoid transfer timeouts etc.
http://bazaar.launchpad.net/~c2c/c2c-rd-addons/trunk/view/head:/table_generate_xml
- draw back - OpenOffice does not import all +100.000 CSV raw data we export.
- workaround - create a module/view in OpenERP that groups before export.

2) the wizard that opens inventory for a location could have an option to show only available products
* this is what I have done for v5 already - should be come standard and default in many wizards

3) Koo
I thought of incremental display of data to avoid the necessity to  compute all lines at once 
and (new)  apply filters on the computed results.
IMHO there is no reason why filters can not be applied to results (appart that it is not coded)
the "simple" rule 
domain
* is DB field - add condition to SQL WHERE query
* else filter results.
would do it.
If the organization needs filtered results these must be produced somewhere / somehow

4) Performance
4a) one day we will need materialized views (period sums) to avoid expensive computation based on millions of stock_moves
in one of our former installations we have some 50000 moves for the most frequent used products (for ~ 10 years). 
If OpenERP has to compute the qty always on 50000 moves it will become slow overall because theses are the products used most frequently.
4b) please think again of SAAS or remote (ADSL) locations. All data we do not have to transmit save time (and  costs for not flat rate lines) and users do not have to examine /exclude these visually. 
for many operations it does not make sense to display products with real stock = 0 especially if 
http://bazaar.launchpad.net/~c2c/c2c-rd-addons/trunk/files/head:/c2c_stock_negative/
is installed.
the purpose of forbidding negative stock is to correct the data before the process can continue. - it's painful but often the only way to enforce correct stock handling and correct average prices(per stock location) and real time moves.


sorry for beeing long....

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/850752

Title:
  fnct_search missing for many function fields

Status in OpenERP Addons (modules):
  Won't Fix

Bug description:
  according to
  https://bugs.launchpad.net/bugs/823049
  it will be possible to search for function fields store = false if fnct_search is defined

  a quick search shows 
  280 function fields in addons
  14 fnct_search

  it would enhance the user experience a lot if at least for the most important function a searech could be defined for 6.1
  as it is the rebirth of a lost feature available in v5 it would also easy migration.

  will you implement search functions if we / the community nominates some important candidates ?
  like 
  * product stock available / on hand

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/850752/+subscriptions