Sage 100

Generally how are you managing conversions of inventory reports which in 4.30 and earlier relied upon the IM2 data file which has now been split to be: IM_ItemWarehouse and IM_ItemWhseHistoryByPeriod. The question I have is whether there's an elegant way to get current period and prior period data onto the report. In prior versions the IM2 held current/prior info so the link was fairly easy. IM_ItemWhseHistoryByPeriod now holds this total data individually for each period so obtaining prior period totals would appear to require some fancier Crystal report to pull in prior year: Warning : No mapping available for field ""PriorYrQtySold"" in table ""IM_ItemWarehouse"" Warning : No mapping available for field ""PriorYrQtyReturned"" in table ""IM_ItemWarehouse"" Warning : No mapping available for field ""QtyIssuedPriorYr"" in table ""IM_ItemWarehouse"" Am I overlooking something simple? I supposed the easiest way to compute current/prior is with formulas?

I try to find a standard report that has the info on it and modify the hell out of it. Especially for the 12 month reports - I start with the standard report and go from there.