Buffer – Page 2 – Pardaan.com

Create New Dimension ID to import dimension values from buffer table

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…

5 July 2017

Dynamics NAV & BC Tips & tricks

Importing Excel file in Microsoft Dynamics NAV using Excel Buffer

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…

26 April 2017

Dynamics NAV & BC Tips & tricks

XML Buffer and CSV Buffer Tables

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…

3 April 2017

Dynamics NAV & BC Tips & tricks

Is it still useful to buffer records in a temptable?

Maybe some of you remember my how-to increase performance by reducing db reads. I wrote it in 2007 when we still had the native DB and also the SQL DB but NOT the service tier with all its extra’s for performance. Bron : Totovic NAV Blog…

1 April 2016

Dynamics NAV & BC Tips & tricks

Excel Buffer & Ease of Upgrade

Microsoft is trying to make our life easier from an upgrade perspective with merge commandlets and upgrade codeunits. This is nice but sometimes you run into situations that are not fixable with tools like these. Bron : Mark Brummel Lees meer...

14 December 2015

Dynamics NAV & BC Tips & tricks

NAV 2013 R2 – Multiple Sheets in Excel Using Excel Buffer

In this article we will see the possibility of having Multiple Excel Sheets Using Excel Buffer Export. Bron : Saurav Dhyani Lees meer...

3 August 2015

Dynamics NAV & BC Tips & tricks

NAV 2013 R2 – Import Excel File Using Excel Buffer

This article is based on a friend request. The Requirement was to import the data in a table From an Excel File. Most of us know this feature is there in standard objects of Microsoft Dynamics NAV from a long time. If you are one of…

8 July 2015