Inventory Report By Vendor

(0) Share

Report

Posted on by Community Member

I am trying to create an inventory report with the vendor name and the quantities available.

I finally got a report, generic Smart List Item Quantities, to pull up and list the item name, and numbers on hand, but the vendor name is blank. Is there a diff one I can use?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Inventory Report By Vendor

You're going to need to develop such a report. The reason the Vendor Name is blank is because any quantity could potentially be made up of receipts from multiple vendors. I'm not sure why vendor info columns are even available to select in that SmartList.

It would be better to start with the Purchase Receipts SmartList, dump it into Excel and slice and dice the data in it according to your needs.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory Report By Vendor

I went in to Report Writer and found Invenotry Purchase Advice by Vendor. Where is this located so I could run it?

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Inventory Report By Vendor

Purchase Receipts SmartList is under Inventory in SmartList.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory Report By Vendor

The Inventory Vendor Activity Report is perfect BUT is does not list the Quantity on Hand. Is it possible to get this added? I went thru all the available fields and do not seeit listed!!

TY

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Inventory Report By Vendor

Hi Guyder,

if you need the Vendor Activity report as a view, then you can go to the SQL server, expand the company database.

Expand the view node, try to find the Vendor Activity report view.

You can create a new view related to the standard view by adding the IV00102.Quantity on Hand field.

Using smart list builder, you can create a new smart list report regarding to this.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory Report By Vendor

TY for your suggestion.

I ended up opening the report in Report Writer and adding the Item Quantity Master to the Tables. I was then able to add theQrt on Hand field. Now I just have to figure out how to drop the .00 as we use only whole numbers.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: Inventory Report By Vendor

Hi Mguyder,

Change the format on the field in Report Writer.

Kind regards,

leslie

Was this reply helpful? Yes No