Trying to get a very simple report from IM.
Item Number, Reorder Point, Quantity Sold YTD and PY along with a calculated field.
The Reorder Point prints fine as do other fields such as Quantity On Hand and Quantity on Sales Order but I get nothing for Quantity Sold fields.
I assume this is because they are date dependent and I am not providing a date - If my assumption is correct how do I provide a date the system can use to determine which years will determine YTD and PY.
I started with the system Inventory Reorder Report so my data files are Work Files.
Can I access the Quantity Sold data anywhere else? If so, I haven't been able to find it.
