Removing Null Country Values From the Syaddr Table

Unfortunately M2M does not automatically populate the Country field on many screens when a US State is selected. This can cause problems in reporting when an executive wants sales broken down by country and many of them are grouped under Null.

Anyway, if you want to see how many addresses are missing “United States” you […]

Let’s Play the Orphaned Records Game

In the past couple of weeks, I have discussed the problems of orphaned records in the M2M Database and promised to provide a script to find them. So, I’ve decided to turn it into a game.

If you’d like to play, paste the following script into your Query Analyzer or SQL Server Management Studio and […]

Data Utilities – Convenience or Crutch?

Recently I’ve been assisting a company with discrepancies in inventory master and inventory on hand tables. One problem is negative quantities in their inspection which can’t be removed, and they also have problems with inconsistencies in their on hand quantities of various parts.

So, a user brings the Material Availability (RPMAVL) and the […]