c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <850752@xxxxxxxxxxxxxxxxxx>]

On 09/16/2011 01:33 PM, Ferdinand @ Camptocamp wrote:
> 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

We would have to analyze this as a bug and reproduce it, because as far
as I can see it works well in the 3 clients I just tested: 6.1-web,
6.0-web and 6.1-gtk, and I can have grouping as Location>Products


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

Why not, that could be nice to have.


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

The Print button on any Analysis view should work well in the GTK client
to export the data as PDF, also respecting the grouping. And for the web
client, all browsers let you print the current page with their built-in
print menu.

As for CSV export, we tried to provide a basic support for the "export
data" wizard on all analysis views, similarly to what works on normal
tables. Just tested on the 6.0-web branch on runbot (exporting the
inventory analysis view after unchecking 'import compatible' mode) and
it seems to mostly work (you can export the data), but maybe not in all
cases.


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

Great, all contributions are always welcome!
The case of timeouts for long-running wizards might need a proper
solution, though, rather than workarounds.


> 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

Excellent, could you perhaps provide a minimalistic merge proposal for
adding that to trunk, in order to make it available in standard addons?


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

Afraid that won't help for function fields, as performing a correct
search/filter would still require loading the whole table - no magic bullet.


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

My opinion is that this is very counter-intuitive and would be a great
cause of hidden mistakes for most users - how will they be able to tell
the difference between the two cases?


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

Yes we have considered several solutions for this, some suggested by
community contributors, including you ;-)
We haven't found the right solution yet, but we hope to address this in
the near future.


This is getting long indeed, perhaps this discussion is best continued
on the mailing-lists rather than this bug report ;-)

Thanks for your feedback, as usual!

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