I made a new report on OpenERP, for stock module, which uses the product.product
model, like the default one which is Stock Level Forecast
.
Now, what is the problem I have, I need this report to be shown on "Location Structure->Physical Locations->Warehouse->Analyze current inventory"
It is showing there, no errors, everything's fine, but my problem is, because this report is tied to product.product
I need to show some product fields (already declared on report) and the location_id
of the warehouse I'm querying.
Obviously if I loop over the current location on my report, it throws an error, because this is a stock
object, and not from product.
So, my question is, how can I bring all product fields into stock, to effectively report all product fields AND stock location at the same time?
I guess I should make a related field, or a one2many there, but I'm very confused at this point.
Any ideas?
I hope I explained myself, if you need the code please let me know I'll edit my question then.
Thanks in advance!