You know you keep claiming that SIFT is broken, but you won’t tell us how you determined that.
How did you do this? I want to know exactly how did you determine whether the object was unmodified.
The reason I want to know is that you can go into the table design on SQL Server and change all sorts of things, and you will never know in the NAV table designer.
Again, tell me exactly how you did this. I want to know table names, filters, fields, everything. You took something from one table and compared it to something else from another table.
The reason why I want to know is that from NAV you NEVER actually know whether you are getting anything from the actual SIFT tables or from the source table itself. You might be looking at one thing that is completely unrelated to the other thing. If you were looking at the actual SIFT tables on SQL Server, how do you know that you weren’t setting certain filters on one thing that are not even part of the flowfield definition in NAV?
I’ll ask again (this is the third time now): did you follow the steps that I outlined in my first reply to regenerate SIFT?