I'm interested in developing or using some method so I can quickly generate a .csv, or some type of document openable in Microsoft Excel, which will show only a list of product names, (selected based on their inventory cycle), and next to them, their quantity available. It should have a format as similar as possible to the following:
Whether there are headers or not, (preferably not), is of no concern.
Issues with my attempts at creating such a method include using Visual Integrator to generate such a document. However, when I try to create a temp field with a calculation, (since it doesn't seem like a field exists already for quantity available), subtracting from IM_ItemWarehouse.QuantityOnHand, IM_ItemWarehouse.QuantityOnSalesOrder and IM_ItemWarehouse.QuantityOnWorkOrder, I've given the following:
(There is also an issue in which I don't know how to use any variables in these calculated, since I get error even when I use the suggested variables).
Thank you in advance for any assistance that you can provide.
