On-Hand Inventory report

(0) Share

Report

Posted on by David Tailor

822

Hello,

i had assign product category to my items, however when i try to print On-hand inventory report, i didn't see any option to filter by product category:

is it possible to modify the query responsible of filtering by adding EcoResProductCaregory table? and how?

Regards,

David

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

A.Prasanna 8,223 on at

Like (0)

Report

I had same problem but not for the Inventory On -Hand , I've developed my own report to see Item with Product category and Item Group.I don't think it will be big deal.

Thanks & Regards,

Amith Prasanna

Was this reply helpful? Yes No
Verified answer

Galyna Fedorova 3,566 on at

Like (0)

Report

Hi,

Try to use Advanced filtering, I assume it should work. On the report dialog, click on Select button and then follow steps below.

Was this reply helpful? Yes No
David Tailor 822 on at

Like (0)

Report

Hi Galyna,

Thank you for your reply.

i followed your steps, however report showed me all records.

any idea?

i did assign a product category to one item, and filter by that category, but still showing all records.

Regards,

David

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi David

Did you select a Category just like the image below.

Was this reply helpful? Yes No
Srihari.molaka 339 on at

Like (0)

Report

Hi Galyna,

Does the tables will show based on security?

Recently the tried to add the table in query joins to one of the user but the required table is not showing in the list.

Same i searched with admin user the required table is showing.

If you have any idea please suggest me.

Thanks and regards

srihari.

Was this reply helpful? Yes No