I have 2 databases that should have the same inventory information, since one database is exporting the data into the second database overnight. However, a lot of items to not match. Both databases displays only item with quantity <> 0. Both databases have item not listed in the other database. I’m in the process of identifying the problem.
The first thing to do is to get a list of all items not listed in the other database.
Thank you again