Implementing Microsoft Dynamics 365 Business Central On-Premise - Fourth Edition

Entry tables

As we have mentioned, the purpose of entry tables is to keep track of all the transactions done with a master table. Each time we purchase an item, we have to record the stock increase. Every time we sell an item, we have to record the stock decrease. It gives us valuable information about the item, such as the inventory quantity we have at any time.

We might think that we don't need an entry table to determinate the stock. When we purchase or sell, we create the appropriate purchase and sales document. Theoretically, we can just add all the purchases and sales document lines and get the same data. Again, we seem to be duplicating information. It is true that for one transaction the same information has to be copied to a lot ...