Stock Inventory report with export function

[Clau123 0]

This is the forum for the Contrib Stock Inventory report with export function.

Edited July 15, 2009 by Clau123

[lhps 0]

This is the forum for the Contrib Stock Inventory report with export function.

 

 

HI , have problem this....

 

1054 - Unknown column 'p.products_cost' in 'field list'

 

select p.products_id, p.products_quantity, p.manufacturers_id, pd.products_name, p.products_model, p.products_weight, p.products_cost, p.products_price, p.products_status, pr.manufacturers_name from products p inner join products_description pd on p.products_id = pd.products_id left outer join manufacturers pr ON (p.manufacturers_id = pr.manufacturers_id) where pd.language_id = '4' group by pd.products_id order by pd.products_name ASC limit 0, 200

 

 

to solve?

 

Thank's

[Clau123 0]

Did you installed the margin report Contrib?

[nudylady 0]

Would easy populate do this job?

[René H4 58]

Claudia, excellent Contrib!

 

I was a little hesitating installing the Margin Reports contrib, since it has so much code to change.

 

Everything just works, saves me a lot of time, especially dec 31st/jan 1st.

 

Groeten uit Apeldoorn.

 

Rene

[Sanmesh 0]

Hello,All actually the Sorting isnt working ! When u click on the Title the url changes but the result isnt shown as expected!