Discussions
How to add item sales quantity to a view or report.
In a report I have created, the fields being used are
Item Type, Item, Item description, Reorder Multiple, On hand quantity, Commited, Backordered, On Order, Available, Cost, Sold Quantity. See screen shot.
Filtered fields are Item Vendor, Item Manufacturer, Date range.
My problem is the report only show items with sales history. How do I get the report to show all items from the filtered vendor or manufacturer?
I also would like to know how to show sales history by the month.
Thanks, Johnny