Sage 100

Blank Item issue - Just wanted to give a heads up. Had client upgrade to 4.40 and when they tried to add an item on the fly in Sales Order, the Item Code field on the Inventory Maintenance screen was blank and grayed out, even if you chose to copy from another item. Come to find out, first item in CI_Item was a BLANK item (surprised the Pre-Migrate didn't catch that) and I manually deleted and all was swell. I know I've seen blank items in other client files, so I'm sure this will pop up again.

I believe the premigration looks for the same item to exist in the IM1 and IM2 or IM3, if needed. If a blank exist in each table it wouldn't spot that there is an issue.

And so today, my third upgrade this week, had the exact same issue. Thereby benefiting from Client A's woes...

I have had this happen is Sales order too. MAS doesn't like having the first key in the file to be all blanks.