Sage 100

On the Inventory Turnover Report there is a column titled ""Average Inventory Year To Date"". Can anyone lookup the code and tell me the formula for this field? Given the data that Sage has to work with I can't come up with anything that makes sense. TYIA

Help says...YMMV For example, if the report is printed as of period 3, you would have the following calculations: Beginning Balance Period 1 + Change In Period 1 = Ending Balance Period 1 Beginning Balance Period1 + Change In Period 1 + Change In Period 2 = Ending Balance Period 2 Beginning Balance Period 1 + Change In Period 1 + Change In Period 2 + Change In Period 3 = Ending Balance Period 3 (Ending Balance Period 1 + Ending Balance Period 2 + Ending Balance Period 3) / 3 = Average Inventory

wait - where did you find that? What did you search for?

I used Help on the report. Everyone knows I can't search for crap, but I do wield a mean HELP.

There was an issue with this report assuming all periods but if a period had no activity it would add the activity for the 3 months and still divide by 7. That was several version ago.

The code seems to follow what Beth found in the help. It looks at IM_PeriodPostingHistory to get beginning balances and then reads IM_ItemWhseHistoryByPeriod to get the net activity for each period specified and then divides by the number of periods specified.

SHEESH - feel like an idiot, I looked and looked and could not find ANYTHING! Thanks @BethBowers @LarryBradford @TimEfinger

don't you love this site?

yes @alanniergarth agreed. I now know why I missed it, it's not until you get to the last 3 words in the paragraph that tell you what you are looking at... ""blah blah blah = average inventory"". I was searching for a heading defining average inventory. Thanks again everyone.