NAV 2015 Order Planning vs Production forecast


NAV 2015 Order Planning vs Production forecast

Is Dynamics NAV order planning function consider production forecast figures when plan ?  …

“No, By Design.”

planning forecats
…good question posted on Dynamics Community Forum                                                                  
“In order planning you can plan based on actual demands that are Production demand, Sales demand, Service demand, Job demand & Assembly demand. As the name of the page says “Order planning” is does not include production forecast.

Whereas you have an option to include production plan if you want to include it in material planning.

One more difference between order planning and planning w/s is that order planning suggests planning for one level (low level code) only, of more then one low levels are involved then you will need to re run the order planning and plan for next low level code. Whereas planning w/s considers all low levels associated to create an item.”

MSDN Links:
Advertisements

Top 10 SQL Server Counters for Monitoring SQL Server Performance — DatabaseJournal.com


Greg Larsen lists his top 10 SQL Server counters for maintaining database performance.

sql journal

Sorgente: Top 10 SQL Server Counters for Monitoring SQL Server Performance — DatabaseJournal.com

Great post by Greg Larsen.

NAV 2015 Basic Flowsheets for dummies (ITA)


Below some NAV 2015 Basic Flowsheets (ITA) … only simple and basic mental schema for newbies (and dummies…)

Flowsheets Topics

  • CRM Nav
  • Service
  • Sales & Shipments
  • Purchase & Receiving
  • Manufacturing

CMR Nav

CRM NAV 2015 - FLOW

Service

SERVICE NAV 2015 - FLOW

Sales & Shipments

VENDITE E SPEDIZIONI NAV 2015 - FLOW

Purchase & Receiving

ACQUISTI E RICEVIMENTI NAV 2015 - FLOW

Manufacturing

PRODUZIONE NAV 2015 - FLOW

also on TechNet http://social.technet.microsoft.com/wiki/contents/articles/32277.nav-2015-basic-flowsheets-for-dummies-it-it.aspx

…you are welcome !

Automate backup on SQL Express and Send Mail Powershell Script


sql express backup

Sql Server Backup Automation and send-email
Solution to automate backup on SQL Express and send mail based on first Microsoft SQL BackupScript “sp_SQLBackupDatabases”

Scheduling
NB: SQL Server Agent “is not available” on this SQL release
You can schedule jobs with standard “Windows Jobs“ !

How System Works:
3 Objectsd based procedure:
1) batch file > SQL-Backup.bat (Execute ALL Procedure)
2) backup procedure > SP_SQLBackupDatabase.sql (original Microsoft SQL Backup Script)
3) Send mail > Send-email.ps1 (a send email routine based on Powershell Script)

Example:
sqlcmd -U sa -P xxxx -S .\SQL2012EXPRESS -Q “EXEC sp_SQLBackupDatabases @backupLocation = ‘C:\SQLBackups\’, @backupType = ‘F’”

Original Microsoft Solution: https://support.microsoft.com/en-us/kb/2019698

MSDN Post Link https://gallery.technet.microsoft.com/Automate-backup-on-SQL-21eb452d
Download link https://gallery.technet.microsoft.com/Automate-backup-on-SQL-21eb452d/file/142818/1/SQL-BackupEmail.zip

BOOST NAV – How to show most 50 heavy queries on SQL SERVER


query

BOOST NAV – How to show most 50 heavy queries on SQL SERVER

… very nice SQL Script to discover slow Sessions !!

SQL SCRIPT

SELECT TOP 50 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,

((CASE qs.statement_end_offset

WHEN 1 THEN DATALENGTH(qt.TEXT)

ELSE qs.statement_end_offset

END qs.statement_start_offset)/2)+1),

qs.execution_count,

qs.total_logical_reads, qs.last_logical_reads,

qs.total_logical_writes, qs.last_logical_writes,

qs.total_worker_time,

qs.last_worker_time,

qs.total_elapsed_time/1000000 total_elapsed_time_in_S,

qs.last_elapsed_time/1000000 last_elapsed_time_in_S,

qs.last_execution_time,

qp.query_plan

FROM sys.dm_exec_query_stats qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt

CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp

ORDER BY qs.total_logical_reads DESC  /* logical reads */

/* ORDER BY qs.total_logical_writes DESC — logical writes

ORDER BY qs.total_worker_time DESC — CPU time */

 

You are Welcome !

Connect to remote nav server via administration shell


powerskell2

Below same links about this feature, powershell is better solution and better way to administer remote NAV servers.

How to: Administer Multiple Microsoft Dynamics NAV Server Computers

msdn.microsoft.com/…/hh165307(v=nav.80).aspx

How to: Administer a Remote Microsoft Dynamics NAV Server Computer

msdn.microsoft.com/…/hh165488(v=nav.80).aspx

How to: Run the Sync-NAVTenant Cmdlet to Synchronize the Tenant Database with the Application Database

msdn.microsoft.com/…/dn757126(v=nav.80).aspx

Coffee Break – Windows PowerShell Remoting

http://blogs.msdn.com/b/nav/archive/2015/03/18/coffee-break-windows-powershell-remoting.aspx

Importing objects in a multi tenancy environment

blogs.msdn.com/…/importing-objects-in-a-multi-tenancy-environment.aspx

Coffee Break | Windows PowerShell and Piping

blogs.msdn.com/…/coffee-break-piping.aspx

NAV to NAV SQL Fast Data Migration (with dynamic “INSERT INTO” STATEMENT)


new

SCENARIO

If you have some old NAV releases and you want to copy data fast from db\company to another db\company (and you don’t want to use Dataport\XMLPort to map each fields ore use Rapid Start Services), you can use SQL “INSERT INTO” statements to transfer data.

 TIMESTAMP FIELD ISSUE

You can’t use a “FULL SQL INSERT INTO * from table to table” statement because we have TIMESTAMP field ISSUE (look at Dynamics Community…more posts about this….) that can’t be copied to Destination Table

 MANUALLY SCRIPTING OBJECTS

If you can do manually exporting all (or single table) with SQL Script Object generator but I think that my solution can be useful and FAST.

HOW SYSTEM WORKS

System extract and pass fields like dynamics parameters to INSERT INTO Statement (es: company, db, fields); system build final INSERT INTO STATEMENT that will be execute and store script that will be execute on custom Table.

ASSUMPTIONS

  • NB1: TIMESTAMP field in NOT passed, is written automatically by Stored Procedure execution
  • NB2: “NO data validation and NAV logic is executing”, only SQL datatype fields mapping is checked
  • NB3: if you have more fields on Target Database than in Source Database (with “NOT NULL” restrictions on fields), will be necessary to MAP adjuntives fields on final SQL INSERT STATAMENTS passing 0 or ‘’ (BLANK) values for new fields.

OPERATIONAL STEPS

1) Create Stored Procedure “CopyTable

2) Create e new table “Tables Migration Config

3) Execute Stored Procedure “CopyTable” that write in field “Exec Script” > After copy and past on Excel on direct SQLQuery window to execute text existing on Exec Script field

1 ) Create Stored Procedure “CopyTable”

 copytable

CopyTable” Stored Procedure

USE [DB_SQL]

GO

/****** Object: StoredProcedure [dbo].[CopyTable]   Script Date: 10/09/2015 09:21:45 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[CopyTable]

— Input parameters

@inputSourceDatabase varchar(100),

@inputDestDatabase varchar(100),

@inputSourceTableName varchar(100),

@inputDestTableName varchar(100)

AS

BEGIN

— SET NOCOUNT ON added to prevent extra result sets from

— interfering with SELECT statements.

SET NOCOUNT ON;

— Declare the variables to store the values returned by FETCH.

DECLARE     @column_name varchar(100),

@table_catalog varchar(100),

@table_schema varchar(100),

@table_name varchar(100),

@column_name_2 varchar(100),

@table_catalog_2 varchar(100),

@table_schema_2 varchar(100),

@table_name_2 varchar(100),

@ResultScript varchar(max),

@tempTable_name varchar(100),

@EndResultScript varchar(max),

@StartResultScript varchar(max),

@TotalResultScript varchar(max)

DECLARE Table_cursor CURSOR FOR

Select [TABLE_CATALOG],[TABLE_SCHEMA],[TABLE_NAME],[COLUMN_NAME] from information_schema.columns

where

–table_name = ‘Planet s_r_l_$ZZTEST_TABLE’ AND

table_name = @inputSourceTableName AND

column_name <> ‘timestamp’ AND

TABLE_CATALOG = @inputSourceDatabase

OPEN Table_cursor;

SET @StartResultScript = ”

SET @EndResultScript = ”

FETCH NEXT FROM Table_cursor

INTO @table_catalog,@table_schema,@table_name,@column_name;

— Check @@FETCH_STATUS to see if there are any more rows to fetch.

WHILE @@FETCH_STATUS = 0

BEGIN

SET @ResultScript = CONCAT(@ResultScript,'[‘,@column_name,’],’)

FETCH NEXT FROM Table_cursor

INTO @table_catalog,@table_schema,@table_name,@column_name;

END

–Creo Parte finale della stringa di esecuzione.

SET @ResultScript = LEFT(@ResultScript,LEN(@ResultScript)-1)

SET @EndResultScript =CONCAT(‘) SELECT ‘,@ResultScript, ‘ FROM [‘, @inputSourceTableName,’]’)

CLOSE Table_cursor;

DEALLOCATE Table_cursor;

–Final String building (CONCAT)

SET @StartResultScript = CONCAT(‘INSERT INTO [‘,@inputDestDatabase,’].[dbo].[‘,@inputDestTableName,’](‘)

SET @TotalResultScript = CONCAT(@StartResultScript,@ResultScript,@EndResultScript)

–Verbose Mode

PRINT @TotalResultScript

–Execution Statement

INSERT INTO [Tables Migration Config] ([Source Database],[Dest Database],[Source Table Name],[Dest Table Name], [Exec Script])

values (@inputSourceDatabase,

@inputDestDatabase ,

@inputSourceTableName ,

@inputDestTableName,

@TotalResultScript)

END

2) Create new table “Tables Migration Config”

tableconfig

/****** Object: Table [dbo].[Tables Migration Config]   Script Date: 10/09/2015 09:20:05 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Tables Migration Config](

[timestamp] [timestamp] NOT NULL,

[Source Database] [varchar](50) NOT NULL,

[Dest Database] [varchar](50) NOT NULL,

[Source Table Name] [varchar](100) NOT NULL,

[Dest Table Name] [varchar](100) NOT NULL,

[Exec Script] [varchar](max) NOT NULL,

CONSTRAINT [Table Fields Name$0] PRIMARY KEY CLUSTERED

(

[timestamp] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Data Filegroup 1]

) ON [Data Filegroup 1] TEXTIMAGE_ON [Data Filegroup 1]

GO

SET ANSI_PADDING OFF

GO

3) Exec Stored Procedure “CopyTable” that recover all fields and write to table “Tables Migration Config

USE DB_SQL

Exec CopyTable ‘SOURCE DB’,’DEST DB’,’Source DB$Customer’,’Destionation DB$Customer’

Parameters

  • Source DB
  • Destination DB
  • Source Table
  • Destination Table

Output is written to video and in table “[Tables Migration Config]” > field “Exec Script

Example of utilization:

— Connect to DB

USE DB

GO

— Delete all data in table (first launch)

TRUNCATE TABLE dbo.[Tables Migration Config]

— Exec Stored Proc “CopyTable”

Exec CopyTable ‘SOURCE DB’,’DEST DB’,’Source Company$Customer’,’Destionation Company$Customer’

GO

–Result on Video (Verbose) and on”EXEC SCRIPT” Field

INSERT INTO [DEST DB].[dbo].[Destionation Company$Customer]([No_],[Name],[Search Name],[Name 2],[Address],[Address 2],[City],[Contact],

[Phone No_],[Telex No_],[Our Account No_],[Territory Code],[Global Dimension 1 Code],[Global Dimension 2 Code],[Chain Name],

[Budgeted Amount],[Credit Limit (LCY)],[Customer Posting Group],[Currency Code],[Customer Price Group],[Language Code],

[Statistics Group],[Payment Terms Code],[Fin_ Charge Terms Code],[Salesperson Code],[Shipment Method Code],[Shipping Agent Code],

[Place of Export],[Invoice Disc_ Code],[Customer Disc_ Group],[Country_Region Code],[Collection Method],[Amount],[Blocked],

[Invoice Copies],[Last Statement No_],[Print Statements],[Bill-to Customer No_],[Priority],[Payment Method Code],

[Last Date Modified],[Application Method],[Prices Including VAT],[Location Code],[Fax No_],[Telex Answer Back],

[VAT Registration No_],[Combine Shipments],[Gen_ Bus_ Posting Group],[Picture],[Post Code],[County],[E-Mail],

[Home Page],[Reminder Terms Code],[No_ Series],[Tax Area Code],[Tax Liable],[VAT Bus_ Posting Group],[Reserve],

[Block Payment Tolerance],[IC Partner Code],[Prepayment %],[Primary Contact No_],[Responsibility Center],

[Shipping Advice],[Shipping Time],[Shipping Agent Service Code],[Service Zone Code],[Allow Line Disc_],[Base Calendar Code],

[Copy Sell-to Addr_ to Qte From],[Int_ on Arrears Code],[Fiscal Code],[Cumulative Bank Receipts],[Banca di Sconto])

SELECT [No_],[Name],[Search Name],[Name 2],[Address],[Address 2],[City],[Contact],[Phone No_],[Telex No_],[Our Account No_],

[Territory Code],[Global Dimension 1 Code],[Global Dimension 2 Code],[Chain Name],[Budgeted Amount],[Credit Limit (LCY)],

[Customer Posting Group],[Currency Code],[Customer Price Group],[Language Code],[Statistics Group],[Payment Terms Code],

[Fin_ Charge Terms Code],[Salesperson Code],[Shipment Method Code],[Shipping Agent Code],[Place of Export],[Invoice Disc_ Code],

[Customer Disc_ Group],[Country_Region Code],[Collection Method],[Amount],[Blocked],[Invoice Copies],[Last Statement No_],

[Print Statements],[Bill-to Customer No_],[Priority],[Payment Method Code],[Last Date Modified],[Application Method],

[Prices Including VAT],[Location Code],[Fax No_],[Telex Answer Back],[VAT Registration No_],[Combine Shipments],

[Gen_ Bus_ Posting Group],[Picture],[Post Code],[County],[E-Mail],[Home Page],[Reminder Terms Code],

[No_ Series],[Tax Area Code],[Tax Liable],[VAT Bus_ Posting Group],[Reserve],[Block Payment Tolerance],

[IC Partner Code],[Prepayment %],[Primary Contact No_],[Responsibility Center],[Shipping Advice],[Shipping Time],

[Shipping Agent Service Code],[Service Zone Code],[Allow Line Disc_],[Base Calendar Code],[Copy Sell-to Addr_ to Qte From],

[Int_ on Arrears Code],[Fiscal Code],[Cumulative Bank Receipts],[Banca di Sconto] FROM [Source Company$Customer]

  • results are visible in Table with:

SELECT * FROM [dbo].[Tables Migration Config]

 

MSDN

  • Also published on Scripting GUY Gallery on MSDN

NAV to NAV SQL Fast Data Migration (with dynamic “INSERT INTO” STATEMENTS)

https://gallery.technet.microsoft.com/NAV-to-NAV-SQL-Fast-Data-4341b7e9#content

Bingo, You are Welcome !

Directions EMEA, NAV 2016 Sessions, October 5-7, 2015


NAV2016 – Day 1 Sessions, Mannheim, Germany, October 5-7, 2015

emea

– Dynamics NAV2016, Works Natively with CRM
– Dynamics NAV2016, Application extensibility
– Dynamics NAV2016, E-Everything, Document Management & OCR
– Dynamics NAV2016, Universal apps for all your devices
– Dynamics NAV2016, Workflows out of the box
– Dynamics NAV2016, Workflow for developers
– Dynamics NAV2016, Finance enhancements
– Dynamics NAV2016, RapidStart Test
– Dynamics NAV2016, 60 Web client enhancements
– Dynamics NAV2016, on Azure SQL
– Dynamics NAV2016, Small improvements that make a big difference
– Dynamics NAV2016, POWER BI

Source http://www.directionsemea.com/content/sessions/

Source http://www.directionsemea.com/

Roberto Stefanetti NAV Blog – BILANCIO XBRL NAV 2013


Questo post descrive brevemente la funzionalità del bilancio XBRL (eXtensible business reporting language) presente in Microsoft Dynamics NAV 2013 e NAV 2015 (ma anche in versioni precedenti con gestione a forms)

Source: Roberto Stefanetti NAV Blog – BILANCIO XBRL NAV 2013

NAV TECH DAYS 2015: My NAV 2016 favorite sessions


NAV TECH DAYS 2015: 19 & 20 November 2015 , Antwerp (Belgium)

sessions

Below “my NAV 2016 favorite sessions and pre-sessions\workshops” from full program.

19-11
NAV 2016: Workflow, Dynamics CRM Integration and Events

“Introduction to working with and implementing new workflows, getting started with Dynamics CRM integration and designing event publishers and subscribers in Dynamics NAV 2016.
This session will include a practical example of how to create and extend workflows, extending the out of the box Dynamics CRM integration and using events and other great new features introduced in Dynamics NAV 2016.”

20-11
NAV 2016:Phone Client/Webclient Enanchement/Windows 10

“With this release of Dynamics NAV we are bringing your NAV application on all devices. Join us for a tour of the Dynamics NAV 2016 Web client with a new fast and fluid user interface and enhancements to simplicity, productivity and performance.
Take a deep dive into the new phone client with its’ rich set of capabilities and support for Windows Phone, iOS and Android. Learn how easily you can develop for one or all form factors, taking advantage of device hardware such as Camera and Location.”

20-11
NAV 2016: Electronic document management & OCR

“Microsoft Dynamics NAV 2016 provides seamless integration with OCR, currency exchange rate and document exchange services. You can now capture on devices the invoice received from your vendor and using OCR service and workflow you can automate the full process including posting the document. Working with different vendors/customers on different currencies can be tedious but now you can keep your currency exchange rates up-to-date using the currency exchange rate services. Also exchanging documents (PEPPOL format and not only) electronically is one click away using the newly implemented document exchange functionality.
After this session, you will learn how to exchange documents electronically with your business partners, receive and process pdf/image invoices through OCR services and keep your currency rates up-to-date and not the least, managing the incoming documents into one single place.”

19-11 Pre-Session\Workshops
NAV ALM using Team Foundation Server

TFS is a powerful ALM (Application lifecycle management) tool that can support your NAV development projects. Secure your code with history using TFS source control or easily propagate your product to your customer projects. Track bugs and plan your work using TFS work items. Design and manage your test using TFS test manager and even build your fobs using the TFS build system.
But how to do this with the NAV development environment that is not integrated with Visual Studio?
In this workshop Dynamics NAV MVP Luc van Vugt will show you how to use Team Foundation Server with NAV development. Based on hands-on labs you will learn how to setup and configure TFS to support you’re Dynamics NAV development to support your daily work.

Working with Powershell & NAV
During this workshop, I will make you familiar with PowerShell, and what NAV has to offer within PowerShell. We’ll use the existing commandlets, enhance them, look into the existing PowerShell scripts, learn from them and also enhance them. All with practical and useful examples which we will create during the workshop.

Full Sessions List
http://navtechdays.com/2015/sessions

Speakers Details
http://navtechdays.com/2015/speakers

Register here:  https://navtechdays.com/2015/register

Source http://navtechdays.com/