NAV - Vendor List Report with Column Grouping

Today we will learn to Create a NAV Report named Vendor List which will show amount of vendors for all G/L Accounts.

The G/L Accounts will come in one Row.

Declare Your Data Item (NAV Table from which we want to fetch data)





Declare variables for filter and other fields which you want to fetch from other tables.

To make filter of from and To Date, Go to Request Page and add the variable created for from and To Date.

Write Code for getting and setting your variables and filters.

Add a row group: Vendor No.

Right click on any textbox

Add a column group: G/L Account No.

This is our Column Group.


Final Output of Report. You can see all G/L Accounts coming in one row.