Programming Microsoft Dynamics NAV - Fifth Edition

Building a simple Query

Sometimes, it is necessary to quickly retrieve detailed information from one or more ledgers that may contain hundreds of thousands to many millions of records. The Query object is the perfect tool for such a data selection as it is totally scalable and can retrieve selected fields from multiple tables at once. The following example (using Cronus data) will show the aggregated quantity per bin of lot-tracked items in stock. This query can be presented to a user by means of either a report or a page:

1. We will define the logic we need to follow and the data required to support that logic, then we will develop the Query. It is necessary to know what inventory is in stock and contains a lot number. This is accomplished ...