Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

Sage 100 ERP Upgrade Tip: Table Changes That May Impact Inventory Report Conversion To Be Manual

June 5, 2012 by Wayne Schulz

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

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP Tagged With: inventory, Sage 100 ERP

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Beware Fake Sage Support Sites
  • When Is Sage 100 Payroll 2.24 for 2023 Due?
  • Which Crystal Reports Versions Are Compatible With Sage 100 (As of October 2023)?
  • Windows Server 2012 R2 No Longer Supported with Sage 100
  • How can I see the tax tables being used for Payroll taxes?
  • Sage TLS 1.2 Change Deferred For Some Through March 2024
  • Sage 100 Updates for 2023: The Year-End Edition You Can’t Afford to Miss
  • Summit Hosting Rebrands as Summit
  • Does Sage have plans to stop supporting TLS 1.0 & 1.1 for Sage 100?
  • Payroll Requirements for Year-End 2023

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

sage 100 email newsletter
Schulz Says Email NewsletterSent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.