Sage 100

I knew the v4.5 => v2016 Adv PU 3 migration/conversion was going too smoothly. Encountering error message below when doing an initial ALE in inventory maintenance or inquiry. KB searches are not meaningful. All thoughts and prayers are appreciated.

I've run into that before - not necessarily with the specific versions you're dealing with. I think I just click OK to use the standard lookup, then deleted the corrupted lookup and recreated it.

I am starting to once again hate ALE's. I have deleted all item master related ALE's to no avail. Time to have a liquid lunch.

Next thing I would do is make a backup of SY1Q01, SY1Q02, SY1Q03 and SY1Q04. Then use DFDM to delete any records referencing the area where you're getting the error.

Do they have ACS's MB??

Nope...

Maybe this will help. I had some corrupted ALE's. How to reset ALE Lookups You can't hurt anything doing this, per Carmen. From the Sage 100 ERP Desktop Go to File, Run and type SYZCON. Click OK At the prompt type the following: o print %SYS_SS'CreateTable(""TableName"",""COMPANY:Company Code"") Note: When entering the table name exclude the .soa or .m4t extensions Press Enter Wait until a 1 is returned Exit SYZCON Example Inventory Maintenance Lookups are wrong that come from CI_ITEM from company code ABC the command would be as follows: print %SYS_SS'CreateTable(""CI_ITEM"",""COMPANY:ABC"")

(I assume you ran the Lookup Conversion utility from Library Master...).

@KevinMoyes - Yikes - Bad assumption!!!!

I often forget this, but it's my go-to first step after an upgrade with ALE issues.

Thought for sure that was going to be the big winner. Still an issue.

@RhondaMcNamara - Good thought but no improvement

Well, I ended up pulling from backup the original SY1Q01, SY1Q02, SY1Q03 and SY1Q04 tables created during the initial installation. Original issue is no more however, all of the customization created in v4.5 are no longer so they have to be rebuilt. I encountered one in the inventory master that is a puzzler. There is a field call Build Kits available that appears to have been modified (renamed). Where can I look to find the original field name?

Scan the UDF listing in custom office? Custom office, UDF Maintenance, print preview.

It might also have been a custom calculated field...

@BethBowers - Good thought but I looked at the set up in v4.5 and there was not calculation for it. The calculation formula appears immediately below (last field) of panel if it is a custom calc. I think it is a field that was renamed for the ALE.