How “not” to increase the batch name


NAV standard, in the case of use of batch name containing numbers, after posting automatically increases the last number existing in batch name (example: Batch 1 > 2 ..AL110A > AL111A.. and so on..)

This functionality is handled “Bydesign” in NAV, if you want to “NOT increase” the number and keep the same number in the batch (example in the case of fixed batch used for example for output and consumption and related numbered machines, former assets) can modify the codeunit 23 “Item Jnl.-Post Batch”

To achieve this, you need to change this line ItemJnlBatch.Name: = INCSTR ( “Journal Batch Name”) in function HandleNonRecurringLine

Function HandleNonRecurringLine

(VAR ItemJnlLine: Record “Item Journal Line”; OldEntryType: ‘Purchase, Sale, Adjmt Positive., Negative Adjmt., Transfer, Consumption, Output,, Assembly Consumption, Output Assembly’)

Original Code
ItemJnlLine3.COPY (ItemJnlLine);
ItemJnlLine3.DELETEALL;
ItemJnlLine3.RESET;
ItemJnlLine3.SETRANGE ( “Journal Template Name”, “Journal Template Name”);
ItemJnlLine3.SETRANGE ( “Journal Batch Name”, “Journal Batch Name”);

IF NOT THEN ItemJnlLine3.FINDLAST
IF INCSTR ( “Journal Batch Name”) <> ” THEN BEGIN
ItemJnlBatch.DELETE;
ItemJnlBatch.Name: = INCSTR ( “Journal Batch Name”);
IF THEN ItemJnlBatch.INSERT;
“Journal Batch Name”: = ItemJnlBatch.Name;
END;

You can change code in this way … for example in case of Outputs Consumptions entries to post from machine from MES..
IF NOT (ItemJnlLine2. “Entry Type” IN [ItemJnlLine2. “Entry Type” :: Consumption, ItemJnlLine2. “Entry Type” :: Output]) THEN
..
//ItemJnlBatch.Name: = INCSTR ( “Journal Batch Name”); // OLD
ItemJnlBatch.Name: = “Journal Batch Name”; // NEW, maintain old batch name, don’t use INCRSTR statement
..

Nice post here on Mibuso about this issue.
Journal batch names post
http://forum.mibuso.com/discussion/44485/journal-batch-names

Advertisements

Dynamics NAV as SaaS …and 365 as IaaS


Dynamics NAV as SaaS (Software as a Service)
hi Guys,
some people have asked me information about this topic, below a little group of links about this topic (…old but actual).
saas
ABOUT SAAS (Software as a service)
Introducing Microsoft Dynamics NAV Managed Service for Partners
Microsoft Definition:
“The Microsoft Dynamics NAV managed service enables Dynamics partners to easily offer SaaS solutions to their customers, deployed on Azure infrastructure and managed by Microsoft Cloud Engineers.  It reduces the operational, technical and administrative complexity of deploying and maintaining multi-tenant NAV solutions in the cloud while at the same time enables partners to leverage the latest and greatest Microsoft technology.”
“Following the launch of Microsoft Dynamics NAV 2016, we are pleased to announce general availability of the Microsoft Dynamics NAV managed service for partners, a significant new option for Microsoft partners  interested in providing multitenant Software-as-a-Service (SaaS) solutions built on Microsoft Dynamics NAV and deployed in the cloud on Microsoft Azure.”
The Microsoft Dynamics NAV managed service is a highly scalable and reliable platform-as-a-service offering that consists of:
Streamlined administration: A new management portal and web services API enable Microsoft partners to efficiently deploy, manage, upgrade and monitor Microsoft Dynamics NAV multitenant solutions on Microsoft Azure.
Simplified operations: Cloud-optimized licensing and billing helps partners deploy customers more quickly, manage users seamlessly, and receive a single bill from Microsoft for the service.
Microsoft Azure:  Auto-scaled, load-balanced and highly-available, the service utilizes Microsoft Azure, which includes many built-in benefits such as enterprise-class security, geo-replication, backup support, and point-in-time restore.
24×7 support from Microsoft: Microsoft Cloud Engineers monitor and maintain partner solutions, customers, and users, offering Microsoft partners a financially-backed SLA of 99.9% availability.
The Microsoft Dynamics NAV managed service has been in preview since April 2015, with partner solutions and customers live on the service today.
Partners interested in the Microsoft Dynamics NAV managed service can find more information at:
CORE MODEL
FAQ
…some other useful links:
Microsoft Dynamics NAV 2016 now available, as is Microsoft Dynamics NAV 2016 managed service for partners
https://blogs.microsoft.com/firehose/2015/10/07/microsoft-dynamics-nav-2016-now-available-as-is-microsoft-dynamics-nav-2016-managed-service-for-partners/
ABOUT IAAS  (Infrastucture as a service)
and now … “THE IaaS ERA”… (from NAV TechDays 2016- Mibuso)
nice video here:
THE “NAVTechDays 2016 Playlist” (ALL VIDEOS)

“Cached Web Service Calls” – Microsoft Dynamics NAV Community


Cached web services calls

in this section you can find a nice post by NAV Team blog about “cached web services calls”:

Abstract

In a service-oriented deployment, web services are used to extend NAV’s functionality and reach. Depending on how volatile this data is and the corresponding usage scheme, it is expected to be up-to-date within a pre-defined period of time (e.g. once a day).

Description

When NAV is integrated with external services, then the user scenarios become dependent on the data and functions offered by such services. Eventually, there are different approaches through which the external data can be retrieved, stored and used.

  • Dynamic: either exposed by the external service itself or by a separate catalog that NAV can query.
    • Advantage: data is always up-to-date
    • Disadvantage: it requires constant connection to the data source.
  • Static: hard-coded in the database for the user to benefit from.
    • Advantage: data is promptly available when needed.
    • Disadvantage: if data changes at some point, it will require a maintenance effort, which exposes the business process to a risk of failure.
  • Cached: offered through an external service and gets pulled according to a pre-defined refresh rate or manually.
    • Advantage: data is ‘up-to-date’ within the rules acceptable by the business process, without extra load on the network resources or the external service.
    • Disadvantage: if data changes while the auto-refresh did not happen yet, the user may not have access to the latest data; however, the user can manually force a refresh of the data, if asked to do so.

When to Use It

Offer data in lookups that were cached from an external service.

Diagram

Source with samples: Cached Web Service Calls – Microsoft Dynamics NAV Community

Design Patterns Wiki

Read the “wiki page” on the Microsoft Dynamics Community!

https://community.dynamics.com/nav/w/designpatterns

NAV 2017 Roadmap


NAV 2017 Roadmap

Some nice “public pictures” from event “WPC 2016”

https://resources.wpc.microsoft.com/session-resources.html#

 

 

 

 

 

..you can download official Microsoft videos and ppt slides from here:

https://resources.wpc.microsoft.com/session-resources.html#

nice post by Saurav Dhyani about event topics here:

http://saurav-nav.blogspot.it/2016/08/microsoft-dynamics-nav-2017-demo-wpc.html

you are welcome !

“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

HR (Human Resources) module in Dynamics NAV


HR (Human Resources) module in Dynamics NAV

NAV HR Module

Some people have asked me about the HR NAV module, below some definitions and links.

HR Module’s Topics Details
The Human Resources feature lets you keep detailed records of your employees.
You can register and maintain employee information, such as employment contracts, confidential information, qualifications, and employee contacts.
You can also use Human Resources to register employee absences, which allows you to analyze registered absences as necessary.
To start using Human Resources, you must set up employees and other basic information. You can also associate various codes to an employee, which allows you to filter information and view specific employees.

Best Goals of Module
– Candidate profiling (skills matrix)
– Employees confidential information
– Managing employees absences
– Tracking of expensive equipments (assignements of benefits..etc.)
– Possibile integration with NAV resources (ex: timesheets)
– Possibile integration with external payroll system (NAV addons or Others..)

MSDN, NAV 2016 Human Resources Help Page
https://msdn.microsoft.com/en-us/library/hh167801(v=nav.90).aspx

nice PDF here
http://libertygrove.com/wp-content/uploads/2012/02/microsoft-dynamics-nav-human-resources.pdf

nice yuoutube videos here


NAV Project Management Module with resources integration

Jobs & Projects
https://msdn.microsoft.com/en-us/library/hh172378(v=nav.90).aspx

Best Topics
The Jobs area supports common project management tasks, such as configuring a job and scheduling a resource, as well as providing the information needed to manage budgets and monitor progress.
With the Jobs feature, you can manage long-term projects that involve the use of man hours, machine hours, inventory items, and other types of usage that you want to keep track of.
You can track machine and employee hours on the project by using time sheets. Using the Jobs functionality will provide a good overview, not only of individual jobs,
but also of the allocation of employees, machinery and other resources being used in all projects. You can also use this functionality for many types of services and consultancy tasks.

Task with resources
Create, schedule and manage resources
Integrate time sheets with job orders

Resource Planning Topics
https://msdn.microsoft.com/en-us/library/hh175161(v=nav.90).aspx

Create and price resources, both persons and machines
Set up time sheets and the approval process.

NAV TechDays 2016, Sessions @02-08-2016


NAV TechDays 2016 , 17 & 18 november 2016 , Antwerp (Belgium)

Sessions @ 02-08-2016  https://www.navtechdays.com/2016/sessions

My Favorite Sessions

-Design Patterns in NAV ‘Madeira’

-Building extensions for NAV

-How to build your solution for PaaS

-Best Practices in developing Microsoft Dynamics NAV 2017 Extensions

-Building cool experiences with O365, Outlook, PowerBI and more

Pre-conference sessions (15-16)

-PowerShell – Black Belt

-C# for C/AL Developers

-Troubleshooting Essentials for SQL Server and Dynamics NAV

-Power-BI – Advanced

-Extending the Data Exchange Framework

 

Register Page

https://www.navtechdays.com/2016/register

Speakers

https://www.navtechdays.com/2016/speakers

Sourceregister | NAV TechDays 2016

How to limit multisessions logins in NAV (from NAV 4 to NAV 2009 R2 Classic)


How to limit multisessions logins in NAV (from NAV 4 to NAV 2009 R2 Classic)

OnCompanyOpen_Trigger

Variables
Name  DataType Subtype
recUser Record  User
recSessions Record  Session
CanLogin Boolean

//MultiLogin Check

IF recUser.GET(UPPERCASE(USERID)) THEN
BEGIN
recSessions.SETRANGE(“User ID”, UPPERCASE(USERID))   ;  //utente connesso
recSessions.SETRANGE(“Application Name”,’Microsoft Dynamics NAV Classic client’);   //controllo solo per classic client
recSessions.SETRANGE(“Login Type”, recSessions.”Login Type”::Database);  //solo per utenti DB
IF recSessions.COUNT > 1 THEN
IF recUser.MultiLogin = FALSE THEN  //se NO multilogin esce
BEGIN
//MESSAGE(‘Utente sta usando già 1 Licenza NAV, MultiLogin NON Permesso per questo utente’);
CloseDB;  //Chiude le session NAV con WSHELL Automation
END;
END;

Function CloseDB()

// Using WShell Automation

Variables
Name DataType Subtype Length
WSHell Automation ‘Windows Script Host Object Model’.WshShell

CREATE(WSHell);
WSHell.Popup(‘Utente sta usando già 1 Licenza NAV, MultiLogin NON Permesso per questo utente’);
WSHell.SendKeys(‘%{F4}’);
CLEAR(WSHell);
End Function

SCM (Source Control Management) with NAV


SCM (Source Control Management) with NAV

do you need to use NAV with SCM (Source control Management) integration ?

…you can use two applications to reach this goal.

– Visual Studio Online (and team foundation server) (free for 5 users)

https://www.visualstudio.com/en-us/products/visual-studio-team-services-pricing-vs.aspx

– GIT (free and open source)

https://www.git-scm.com/about/free-and-open-source

You can find a script on codeplex for using GIT and NAV (integration with TFS and GIT) …. and Others nice free scripts at links below (always on codeplex repository)

1) NAV Powershell scripts and TFS Build Template

https://navscripts.codeplex.com/

2) TFS Build Template for GIT repository

https://navscripts.codeplex.com/wikipage?title=TFS%20Build%20Template&referringTitle=Home

Some parts of the scripts are based on work (Waldo) see http://www.waldo.be/tag/powershell/

Some parts are based on PowerShell scripts from module “Microsoft.Dynamics.Nav.Ide” made by Microsoft people.

My GIT@  https://github.com/rstefanetti   https://github.com/rstefanetti/NAV_SQL