I know what it is… I was just nagging Bart about it 2 weeks ago.
So the fields are there and the Yellow is misleading… Use the “List” View! Then make sure your
- Integers have a default of 0 in the List View (Somehow the List and Detail Dont Match)
- Booleans have a default of false NOT BLANK! (I also changed any that had no to false)
- GUIDs have a default of 00000000-0000-0000-0000-000000000000
- Your Decimal format might be >>>9.9999 with Decimals 4 but the Default Value in List View might be 0 set it to the correct 0.0000
As you are setting the defaults you might notice your Table goes green and in sync. As you are switching btw Detail/List you can notice the Default’s dont match. Once you fix them in the List View your Table goes in sync! It only took me like 7 hours to figure it out lol I even poked around with all Epicors Stored Procedures and SQL Debugging.
The Problem that seems to happen is 400, 500 and earlier versions allowed you to have some blank defaults, which in 10.2 does not like. For me it was Migrating from E9 I had Integer with BLANK which in E9 was fine in 500 it was fine… but in 10.2 it was not.
Fix the Default Initial Values via List View and you should be good. Dont let the Detail Tab Fool you =) If its still Yellow then there is 1 or more Defaults you missed or don’t match the format.
PS: Even when I had Integer set as 0… I set it back to 1 and saved and back to 0, triggered an update and I went green on a table. Even there the 0 didn’t really take until I re-triggered an update.
There really was no failure, it was just the Shape showed Table not in Sync because the Defaults didnt fit, as soon as I fixed it, it went green instantly.