3rd July 2012
My last blog was about how to improve performance if you are NAV warehouse system. In my solution I used a sql script that summarizes the warehouse Entry table by Item,Variant,zone,bin,lot,serial,UOM and inserts the data into a new 50K range table and then a nav processing reports deletes all the warehouse entry and inserts the summarized entries into warehouse entry. In NAV 2013, MS has proved a new object type Query for C/Side Developers. You can use this object to do fast retrieval of data from SQL and let sql server to do some of the processing and calculation. I’ve rebuilt the solution in NAV 2013 using query and a CodeUnit. This makes the solution much easier to schedule nightly to run and have an optimized fast database with warehouse system.
Here is a screenshot of the query object for summarize warehouse entry.
And here is the Codeunit.
Attached are the objects