How to Use MVC.Net on the Dynamics NAV Database Structure


How to Use MVC.Net on the Dynamics NAV Database Structure

MVC

nice post about ASP MVC.Net integration with NAV (post by Codeproject).

About ASP MVC.Net

ASP MVC.Net is an robust & good pattern-based way to build dynamic websites; if you don’t like to use Web Services & OData this is a valid alternative (old but actual). You can use to build Website based on NAV database structure. “How you can use the Entity Framework in an MVC.Net web application with Dynamics NAV ?”

Tutorial

This tutorial will show you how you can use the Entity Framework in an MVC.Net web application with Dynamics NAV.

Take a look to project.

Source: http://www.codeproject.com/Articles/421643/How-to-Use-MVC-Net-on-the-Dynamics-NAV-Database-St

Advertisements

Let NAV Speak (with a Simple and Useful Client Add-in)


nice old post by Duilio Tacconi.

“In this blog post you will find the source code (below) to “let NAV speak.” You would have a wide range of possibilities to use this simple Add-in and enlarge this project.

If you want to know more about Client Add-ins you can refer to this MSDN link:

Extending the RoleTailored Client Using Control Add-ins and Microsoft Dynamics NAV 2009 SP1

This simple Client Add-In is based on System.Speech namespace:

Microsoft.Speech.Synthesis Namespace

Source: Let NAV Speak (with a Simple and Useful Client Add-in) – Dynamics NAV Team Blog

“Scheduling Reports” option also available in report.RUNMODAL instead of report.RUN


Dynamics Product Suggestion | Microsoft Connect

“Scheduling Report” option also available in report.RUNMODAL instead of report.RUN

it would be useful to use the “report schedule” option also in report.RUNMODAL mode (in this mode is inhibited by design).
i can change the codeunit that launchs reports from “report selection” but  i think isn’t a good idea, i dont’ know why this feature is inhibited by design.

Source: “Scheduling Reports” option also available in report.RUNMODAL instead of report.RUN | Microsoft Connect

NAV 2013 SQL Query Codeunit Tool (SQL From NAV Part II)


NAV 2013 SQL Query Codeunit tool

i found this nice demo tool by Dynamic Manufacturing Solutions on Mibuso.

Source http://mibuso.com/downloads/nav-2013-sql-query-codeunit
nice tool, based on .NET integration (AD), usefull if you don’t like Powershell.

Purpose of this tool
“Simple codeunit allows you to execute an SQL query to populate any NAV (temporary) table using one call.  Test page is included to demonstrate functionality with a simple query.”

… Nice tool (with demo page & codeunit objects) tu run SQL Statements directly from NAV using .NET integration (ADODB); you can run SQL Select statements and any sql commands (if you have rights).

Modifications

I did some modifications to load a generic table using dynamics fields.. example field1. field2, fiels3 etc. and possibility lo load a saved SQL Statement from “.SQL” Script file or from BLOB field in “SQL Commands Table” etc. ..

Example of utilization
..you can retrieve Intercompany “Contacts” running a simple “SELECT with UNION SQL statement”…
.. also you can publish this page “as a web service” to retrive\expose data from multi-sources database using only a web service connection!

SQL RUN COMMAND

SIMPLE QUERY
SELECT SUM(Quantity) AS QuantityTot, [Item No_], [Location Code], [Lot No_], [Serial No_]
FROM dbo.[CRONUS Italia S_p_A_$Item Ledger Entry]
GROUP BY [Item No_], [Location Code],[Lot No_],[Serial No_]
HAVING ([Location Code]<>” AND (SUM(Quantity)) >0)

MORE COMPLEX QUERY WITH HAVING FILTERS
SELECT SUM(Quantity) AS Field1,  [Item No_] as Field2, [Location Code] as Field3,
[Lot No_] as Field4, [Serial No_] as Fileld5 FROM dbo.[CRONUS Italia S_p_A_$Item Ledger Entry]
GROUP BY [Item No_], [Location Code],[Lot No_],[Serial No_]
HAVING ([Location Code]<>” AND (SUM(Quantity)) >0)

SQL STATEMENT TO “CREATE A NEW TABLE”
CREATE ACTIVITY 2 TABLE
CREATE TABLE [dbo].[CRONUS Italia S_p_A_$Activity_2](
[timestamp] [timestamp] NOT NULL,
[Code] nvarchar NOT NULL,
[Description] nvarchar NOT NULL,
CONSTRAINT [CRONUS Italia S_p_A_$Activity$10] PRIMARY KEY CLUSTERED
(
[Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

ANY SQL COMMAND EX  BACKUP…..

etc. etc.

Great tool!

Source http://mibuso.com/downloads/nav-2013-sql-query-codeunit

Load Data into NAV using C/AL and Powershell (SQL From NAV Part I)


Load Data into NAV using C/AL & Powershell

powershell cAL 

Sample Scenario

“Read distributed data from Sql Server and load a data warehouse using NAV C/AL with Powershell integration”

If you need to retrieve (and aggregate) data from more than ONE company or from more than ONE database , in NAV you can use “SQL Server Views” objects mapped as “NAV linked objects”.

… but if don’t want to use NAV Linked objects (SQL Tables or SQL View because is complex and time consuming to managing with many companies\many databases or because you don’t’ want to consume NAV tables for linked objects) and you don’t like “.net integrations” or utilization of external applications, you can use Powershell in NAV (and outside NAV certainly…)

You can achieve this goal using a Hybrid Methods to load data into NAV from different sources

  • Read data from Powershell
  • Write Data\Processing in NAV with C/AL Coding

You can use two functions by Waldo to do this:

  • Powershell Wrapper for NAV C/AL function
  • Invoke-NAVSQL function

Scenario

  • Use good Waldo function to launch powershell fro NAV (after this you can schedule on NAV NAS load data process) – PowerShell Wrapper
  • Read Sql Views from Powershell using Waldo Invoke-NAVSQL’ function
  • Write into NAV table using C/AL logic & data validations mixing C/AL and Powershell commands.

NB: Powershell consumes a concurrent user.

Details about these good functions by Waldo

“How-to” use powershell in NAV (NAV Powershell Wrapper)

“How- to” load data into NAV with Powershell? (Invoke-NAVSQL)

Example

Get all companies, and get the customers of the first company:

$Mycompanies = Invoke-NAVSql -ServerInstance ‘dynamicsNAV90’ -SQLCommand ‘Select * From Company’

$Customers = $Mycompanies |

select -First 1 |

foreach{ Invoke-NAVSQL -ServerInstance ‘dynamicsNAV90’ -SQLCommand “select * from [$($_.Name)$(‘$Customer’)]” -ShowWriteHost }

$Customers | select ‘No_’, Name, ‘Credit Limit (LCY)’ | Format-Table –AutoSize

ALL Source links:

http://www.waldo.be/2014/12/17/running-powershell-from-nav/

http://mibuso.com/downloads/running-powershell-in-nav

http://www.waldo.be/2016/06/08/invoke-navsql-execute-sql-queries-on-nav-databases-with-powershell/

https://github.com/waldo1001/Cloud.Ready.Software.PowerShell/blob/master/PSModules/Cloud.Ready.Software.NAV/SQL/Invoke-NAVSQL.ps1

NAV Shortcuts & Filters | ArcherPoint, Inc.


Great post about “NAV Keyboard Shortcuts & Filters” by Archerpoint.

13 essential NAV Schortcuts

http://www.archerpoint.com/sites/default/files/docs/dynamics-nav-shortcut-keys.pdf

NAV Filters

http://www.archerpoint.com/sites/default/files/docs/dynamics-nav-filters-guide.pdf

Source13 Essential Microsoft Dynamics NAV Shortcuts | ArcherPoint, Inc.

New Scrum guide @Scrumguides.org


New Scrum guide @Scrumguide.orgscrum 2

Scrum is a framework for developing and sustaining complex products. This Guide contains the definition of Scrum. This definition consists of Scrum’s roles, events, artifacts, and the rules that bind them together. Ken Schwaber and Jeff Sutherland developed Scrum; the Scrum Guide is written and provided by them. Together, they stand behind the Scrum Guide.

New Scrum guide (July 2016 release) here:

http://www.scrumguides.org

Source: Home | Scrum Guides

NAV 2016 Italian Flyer


NAV 2016 Italian Flyer

nav italian Flyer

NAV 2016 What’s New Flyer, a short flyer (fast tracks) about NAV 2016 new features.

Download link: http://www.soluzioniedp.it/admin/public/downloads/52cb0bfb7756a9314d0b25770b206ee1/files/FlyerPersonalizzatoSEDP-Dynamics-NAV2016-SEDP-lowres.pdf