Inventory report for specific items?

1

I am trying to find a way to create a report for specific items?

I want to be able to make multiple reports with specific items in each report.

Any suggetsions? Pointers?

Thanks

Joseph

2

Any body can give any ideas or suggestions as to how to do an inventory of specific items?

I need to get the current inventory of specific items on a regular basis, and instead of working through the entire inventory list, I am hoping to find a way.

Thanks

Joseph

3

Create an item group with these specific items and you can filter any reports with the item group.

4

That is a good idea. My item groups are all set up. Can an item have more than one item group attached to it?

The other idea I came up with last night, but it seems to be only part of the solution.

I was able to create tags and tag my products.

When I go and list my products, I can filter them using the tags.

I get the exact items I am trying to find.

But, the next step is to be able to create a report that filters using the tags, but I also need to get the current inventory of the items.

How can I get the current quantity listed in the report as well?

Thanks

5

When you reach this level of complexity (e.g. filter by Tags + fetch current Stock), it’s time to write either a Query Report or Script Report.

You’ll have to write your own SQL and/or Python code, based on the Tables/DocTypes where the data is stored. But you have the ability to write almost any tabular report.

1 Like