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?
TY
*This post is locked for comments
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.
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.
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
Purchase Receipts SmartList is under Inventory in SmartList.
I went in to Report Writer and found Invenotry Purchase Advice by Vendor. Where is this located so I could run it?
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.
Share
Report
All responses (
Answers (
65,271
