Version 4.4 of Sage 100 ERP changed some of the underlying data tables for the Inventory module. In come cases this means you might have to rework custom written reports to account for field name changes — or possibly changes to the file layout.
To view the table structures in your version of Sage 100 ERP go into the Resources section from your desktop. From there scroll down to “File Layouts and Program Information”.
Here are some notes on the table changes that may require you to re-work any custom written Crystal Reports.
Tip: Use ..\MAS90\HOME\MASCRCW.EXE to try to first auto convert any customer RPT files. In some cases you’ll find that Sage 100′s conversion tool might convert the reports without any manual corrections. Just be sure you backup your RPT files before attempting conversion.
DATA TABLE CHANGES IN SAGE 100 ERP INVENTORY
IM2 – Inventory Item Warehouse Detail Broken out into 2 tables now:
- IM_ItemWarehouse
- IM_ItemWhseHistoryByPeriod
Reports using PTD, YTD and Prior Period formulas may not convert and may require manual rework.
IM3 – Item Costing
Used to have two fields for Receipt Date (ReceiptDate, ReceiptDate2) and (ReceiptNumber, ReceiptNumber2)
Looks as if in old MAS (pre 4.4) ReceptNumber was used for Record Type 1,2 and ReceptNumber2 for Record Type 3,4
It is possible this was just normalized and we only need to make a swap to always use ReceiptDate, ReceiptNumber
IM9 – Item Sales Detail Warehouse – this file used to hold sales by period (1-13) it has been replaced by a file (IM_ItemWhseHistoryByPeriod) which holds only one period per record. Thus recreating the old file structure would require a re-write of any report based on this table.
IM_13 was one year per record now is one period per record
About Wayne Schulz