It’s actually really difficult to come up with a simple demo query to prove this though (the Power Query engine is too clever about not evaluating things it doesn’t need for the final output of a query), but it’s fairly easy to understand the principle. Whenever you have an expression that returns a table something like this:
As you already might know, in the purchase/sales posting routines from NAV an additional temporary table Invoice Posting Buffer is used to group invoice lines by the fields specified in the Primary Key of Invoice Posting Buffer table (TAB 49) and then Post only 1 G/L Entry for each group of purchase/sales lines.
Many questions in Microsoft forum about this topic: “How to generate new dimension ID from data (dimensions values for NAV login) existing on external tables ?”
Use standard NAV to achieve this, you can use standard NAV function DimMgt.GetDimensionSetID(Rec) to create New Dimension SET ID of function existing on UpgradeToolkit since NAV 2013.
This article is to import data from the Excel file into existing NAV table. This import matches the excel entries with the existing NAV table and modifies the records of the table on import of the excel file. To accomplish this, we create a report using Excel Buffer as the DataItem.
Most of us that’s been programming in Dynamics NAV for a while are aware of the Excel Buffer table. It is a super useful table that can be used to create and read Excel files from C/AL code. This table have been around as far as I remember, and now it has some siblings, the XML Buffer and CSV Buffer tables.