Jump to content
Sign in to follow this  
Clau123

Stock Inventory report with export function

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×