Sage 100

Has anyone come up with a standard way of creating an inventory PTD QTY Sold in v4.50? In earlier versions of MAS this was all stored in IM2. With the upgrade any custom reports using this value (as well as YTD and PRIOR, etc) are now broken. There does not appear to be an easy way to generate these values short of some fancier footwork to recreate these types of reports. This is not fun when the customer may have 10-15 that they've accumulated over the years. I know the suggest previously has been to re-purpose a report like the Inventory Sales History or Inventory Sales Analysis which does seems to accumulate some of those totals. If possible I'd rather avoid a lot of expensive re-writing during an upgrade. Anyone found a way around the table change issue?

So far I've found: IM2 - Broken out to two tables now - IM_ItemWarehouse - IM_ItemWhseHistoryByPeriod IM3 - There used to be two fields for ReceiptDate, ReceiptNumber (ReceiptDate2, ReceiptNumber2) - that seemed to vary based on the type of record being received. I'm assuming that Sage changed this and now the conversions fail because the '2' have been normalized so that there's no longer a need for 2 fields. IM9 - This used to hold period 1 - 13 sales, quantities, COGS - Now holds period by period

Don't forget IM_13 -- was one year per record, now just one period per record.

If they have VI, create a PTD and YTD UDF on the masterfile. Then create a VI job that calculates the totals nightly and populates the UDFs.