ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> Inventory Usage/Turns
http://www.istechforum.com/YaBB.pl?num=1057625639

Message started by Lynn_Pantic on 07/07/03 at 18:53:59

Title: Inventory Usage/Turns
Post by Lynn_Pantic on 07/07/03 at 18:53:59

Another report needing definition. Inventory usage is simple enough - transaction type S, I, J or negative A type within a date range will give you either total quantity or dollar value of parts consumed.

However, "Turns" is usage divided by some measure of on-hand. Suggestions requested for defining the on-hand to use - aggregate dollar value of inventory based on GL, IN-F calculated value as of some series of dates averaged together, ???

Turns can be aggregate based on dollar value or part by part, perhaps based on some on-hand quantity calculation. It is the averaging algorithm that needs to be defined.