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 _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
