Skip to main content

Posts

NAV Report - How To Use Excel SUMIF Function?

Hi all, I think most of us know SUMIF Function IN Excel , Those who don't know below is a sample. Suppose i Export my Item Ledger Entries Data in Excel. Now i want to see the Total Quantity Sum where Entry Type Is Sales or Purchase. There are two ways to achieve same - 1. I Filter the Data based on Entry Type and Sum up Quantity. 2. Or I Can Use SumIF Excel Function where i can put a condition.

NAV 2013 R2 - Role & Permission Wizard

Hi All, In Back old days we have tools for creating Roles and Permission Using Code Coverage. There were so many. One such tool for classic Client is still available at Mibuso . Recently During a Implementation i was struggling with Roles and Permission and thought to Upgrade the Tool For Role Tailored Client. Disclaimer -  ** This Tool does not provide you complete Roles and Permission Set to be Created. It will help you in creating a basic Structure. As the Tool is based on Code Coverage, it will only consider objects which are called during operations via Code Only. ** This tool automatically assign Read, Insert & Modify Permissions on all Table Data called during Operation. User need to modify the Permission as per requirement. Below are the Details of the same.

NAV 2013 - cumulative update 26 Released.

Hi all, Please find below the details of Cumulative Update 26 released for Microsoft Dynamics NAV 2013. Title - Cumulative update 26 for Microsoft Dynamics NAV 2013  Build No. - 40940 Release Date - May, 2015 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link

NAV 2013 R2 - Cumulative update 19 Released.

Hi all, Please find below the details of  Cumulative Update 19 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2 Build No. - 40941 Release Date - May, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5