Sage 100

Does anyone know what this field represents in 4.3 and below?? {IM2_InventoryItemWhseDetl.AveOnHandQtyAt}

Inventory Item Warehouse Detail Average On Hand Quantity????

In the old TRSG it says it is calculated an period end.

So it is the average qty AT period end??

Yeah.

Thanks all. Has anyone created a Crystal report similar to the inventory turnover report at 4.4 or above?? I had created one at 4.3 - using the above field - and I don't want to start from scratch using the IM_PeriodHistoryPosting table. If you have anything similar and don't wish to post it here, please PM or email me. Thanks in advance!!

Therese, have you looked at the existing inventory turnover report in 4.4? I would start there unless it just doesn't suit your needs.

I have not yet but good idea @GeneUlrich !