I have been tasked to create an Inventory Turns Calculation in Crystal, I have a report with all the items, a date range parameter and COGS calculation, Piece of cake. How would get average inventory? Is there a table that gives you historical inventory on hand?
Any insights appreciated. I've been writing crystal for 20+ years but somewhat new a Sage 50.