Monday, September 18, 2017

How to call Stored Procedure in MS Dynamics NAV?

How to Connect with SQl in NAV 2009?

This is for NAV 2009 using Automation Object For Above 2009 you can change these variables to Dotnet. The Link is provided below :- 

Direct Link For Reference in NAV 2013 and Above.

Name DataType Subtype Length
ADOConnection Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Connection 
LADOCommand Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Command 
LADOParameter Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Parameter 
lvarActiveConnection Variant  
SQLString Text  1024
ADORecordSet Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Recordset 

Name ConstValue
pcodServerName Server NAME
pcodDatabaseName DBNAME
pcodUserID USERID
pcodPassword PASSWORD


Step 1 :- Create the Connection


ltxtConnectionString := 'Driver={SQL Server};'
                        + 'Server='+pcodServerName+';' 
                        + 'Database='+pcodDatabaseName+';' 
                        + 'Uid='+pcodUserID+';' 
                        + 'Pwd='+pcodPassword+';'; 

NameCompany := 'DEV Company';

EXIT(ltxtConnectionString);

Step 2. :- Calling the SQL Connection.


IF ISCLEAR(ADOConnection) THEN
  CREATE(ADOConnection);

ADOConnection.ConnectionString := GetLiveConnectionString;

ADOConnection.Open;

Step 3. :- Write the SQL Querry


SQLString := 'select CAST(sum(SIL.Amount) as float) as InvoiceAmount, '
            + '((SUM(SIL.Amount)-SUM(SIL.[Unit Cost (LCY)]*SIL.Quantity))/SUM(SIL.Amount)*100) as GrossProfit '
            + 'from dbo.['+NameCompany+'$Sales Invoice Line] as SIL '
            + 'join dbo.['+NameCompany+'$Sales Invoice Header] as SIH '
            + 'on SIL.[Document No_] = SIH.[No_] '
            + 'where (SIH.[Posting Date] between '+ ConvertedStartDate + ' and ' + ConvertedEndDate + ');';

Step 4. :- Execute the SQL Querry

ADORecordSet := ADOConnection.Execute(SQLString);

Step 5 :- Manuplate if you want the record set if you want the SQL Record Set.

ADORecordSet.MoveFirst;

Step 6 :- Close All Connection and Clear the Variable.


ADORecordSet.Close;
ADOConnection.Close;
CLEAR(ADORecordSet);
CLEAR(ADOConnection);

Tuesday, August 15, 2017

More than 30 Points you must think before designing any RDLC Reports in MS Dynamics NAV 2017

Hi,

This post is related with RDLC Report Defination Language in C/AL so before Designing you must

know the reason why and whom and How you will create Reports in MS Dynamics NAV 2017.

So my readers will be able to resolve many problems and concepts which anyone can use in their

daily development process.

25. We can pick Year , Month and Date Difference From Posting Date in NAV.

Using 

= Year(Fields!PostingDate.Value) Further you can also use this as grouping in RDLC.

24. We can use Format in TextBox & also Use HTML in TextBox in NAV

You can use HTML Format in Reports using Textbox If you need help in it you can comment below.

23. Use Of Exit Funtion in Source Expression

You may use  Exit Function also in Data Source of DataItem of RDLC Reporting

22. PrintOnlyIfDetail

Most of you might be knowing it can be used to save unwanted dataset in Report so can be used to improve the timing issue.

21. Use Matrix Report

20. Use conversion Function in RDLC Reporting to convert Format of Expression

19. What is the use of Dataset (Fields!Expression,"Dataset Result")?

It Defines the scope of Field Expression to complete the Result.

18. Use of Function in RDLC 

Check where Code.BlankZero Defination is Given in Report in Report Properties.

17. We can also use Date Function in RDLC Reports

16. We can use year for Grouping in RDLC Reports

15. INLine IF (IIF) and Switch Case can be used in expression of Row and textboxes

14. We can change Expression of Text Box on Behalf of conditions

13. Filling row with color even odd as per requirement.

You can use it in visibility expression

=Iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")

You can change the Color of BackGround on Behalf of grouping in MS Dynamics NAV.

12. We can insert Row No. in Table using inbuilt function ROWNUBER in RDLC

11. We can repeat header in RDLC Report on every page using static property

10. We can use top n property present in Filters of tablix property to calculate top N customer Item Vendor Report.

9. You can put images in MS Dynamics NAV Report and according to conditions.

8. You can Dynamically break a Tablix and remove last Line from tablix easily using RowNumber Inbuilt Function in RDLC.

=Int((RowNumber(Nothing)-1)/25) 

So these are the points which are possible in MS Dynamics NAV if any any of the above point you need practical session you can comment me or directly message me from my blog I will update you with my blog.

Thanks to all my readers.

Happy Independence Day 2017 to all Indians.

Understand Grouping and applying Toggles in MS Dynamics NAV RDLC Layout

Hi,

Before going in detail you should check the details about controlling the Columns and Rows in NAV

RDLC Layout.


Today I got a requirement from my client to show all Items By Location Report in MS Dynamics 

NAV. The requirement was simple using Item and ILE Tables but he wants to see the total in one line 

and if he needs to show details then only details must appear.

This requirement can be completed by using SSRS or RDLC Toggle Functionality present in MS Dynamics NAV.


So lets Get Started with seeing the Final result in Demo DB Cronus.


You can click on + and see the details so it is dynamic report for your client.

How to achieve it?


This Hide Details is a boolean field and Integer has Data Item Table view property
Number = 1 as we do earlier.

Now I had created the Layout as follows

Location Code is Grouped as Parent Group here. And selecting the Details Row I had Set the expression as Follows:


NOT Last(Fields!HideDetails.Value, "DataSet_Result")




Monday, August 14, 2017

Top 10 Points While Setting Up New Company in MS Dynamics NAV

1. Define No. Series

You have to decide which No. Series You are going to use and record for future discussion with 

client. These No. Series are defined under :-

1. Sales & Receivables Setup.
2. Purchase & Payables Setup.

2. Decide about Payment Tolerance?

This implies whether an invoice is settled at less amount than actual means 1059.00 $ can be settled at 1050.00 $ so ask from your client.

3. What are the major setups needed to start the transaction?

1. GL SETUP
2. Sales & Receivables SETUP
3. Purchase & Payables Setup.
4. Inventory Setup.
5. VAT and TAX SETUP as per your localisation.

4. Document Exchange Service & XBRL 

If data exchange is required from MS Dynamics NAV Financial Management PEPPOL Format
Extensible Business Reporting Layout required by system.

5. Types Of Costing Method

For inventory decision FIFO LIFO Average Specific or Standard.
FIFO :- Inventory Valuation will be based on cost last received 
LIFO:-  Inventory Valuation will be based on cost First received
AVERAGE:- Inventory Valuation will be based on average of all.
SPECIFIC:- Inventory Valuation will be based on serial No. of Items and Inv. Val. will be based on exact units in stock.
STANDARD :- Inventory Valuation will be based on FIFO but the only difference is that the incoming cost which are based on an estimated cost that you set up on an ITEM. It is mainly used with Manufacturing.

6. How will you close the company?

Will there be any subsidiary coming in the company decide the designing of COA accordingly.

7. Decide about the Posting Groups?

Specific , General and Tax Posting Group present in MS Dynamics NAV.

1. Customer Posting Group 
2. Vendor Posting Group
3. Inventory Posting Group
4. Bank Account Posting Group
5. Job Posting Group
6. Fixed Asset Posting Group
7. Gen. Business Posting group
8. Gen. Product Posting Group
9. VAT Posting Setup / Tax Setup.

8. How will you do Payment Reconciliation ?

Will there be any data exchange framework requirement for details you may check Table series 1200.

So these are few major points which a Functional consultant must be aware before delivering the project to client.

Sunday, August 13, 2017

How to use Update Propagation Property in NAV

Hi,

This post is bridge between a blog which I liked the most to describe the functionality of MS

Dynamics NAV from 2015 version.

What is Updatepropagation property in MS Dynamics NAV?


To reduce the customization in the page of MS Dynamics NAV we can use this property , you will 

find this property on Sub Page as shown below in screen.


With the use of this property you dont need to use Currpage.Update on various triggers.

Where we can use this property?

This property is majorly used while calculating Lines Column in document on Header for eg.

Sales Header .

TO view about this in practical you can go to this Link.


30 Things you should know about Microsoft Dynamics NAV

Hi ,

This post is related to upgradation of our skills as MS Dynamics NAV Developer if you are junior ,

Senior , Fresher or manager in an organisation. Below is list of 30 most well upgraded Links which

we all should know , if we are working in MS Dynamics NAV as Technical or Functional

Consultants.

No One is Perfect , But practice can make anyone PERFECT.

So visit and subscribe these links to upgrade yourself as much as possible.


2. https://explore.dynamics.com/

3. How many types of Discounts you can provide to your customer in Navision?


    We can provide 3 types of discounts in NAV:-

     Line Discount , Invoice Discount , Payment Term Discount.

4. When Last Direct Cost is updated?

 
     Last direct cost is updated when a purchase invoice is posted in the system and this price is

     appearing in Lines of document.

5. Summarize the WorkFlow Process in Navision?


    Setups required for the workflow configuration in NAV 2016 onwards:

    Setting up approval users (including setting up a user in Windows and in Microsoft Dynamics            
    NAV).

    Create a user in active directory

    Create a user in NAV and link with Windows directory
   
    Set up Approval

    Set up a workflow user group

    Setting up notifications for approval users:

    Create a notification schedule

    Create a notification setup

    Modifying and enabling an approval workflow:

    View the workflow template

    Create a new workflow

    Starting the job queue that dispatches notifications: (if required by client customization)
    Job queue setup
   
    Requesting approval of a purchase order, as user A:
   
    Create purchase order, after login from user A
    Send the request to approve
    Receiving a notification and then approving the request, as user B:
    Login from user B and approve the purchase order.

6. What are the types of Journal Entries in Nav?

   General Journal , Standard Journal , Recurring Journal , Reversing Journal.

7. Why document date is used or use of posting date and document date?

   Document date is used for all major calculation in system like Payment Terms and Methods while 

   Posting Date is date when it is posted in the system or document last date to change.

8. What is the use of OnHold Field in CLE is used for?

   To specify a code for user to hold the payment means if user wants to stop some payment due 

   to settlement then it is used.

9. How to process prepayment in Navision?

  I will not disscuss here whole process you can check on MSDN. I am just providing summarised 

  step to setup.
  1. General Ledger Setup Field Check Prepayment VAT.
  2. Sales & Receivables Setup Prepayment Calc.
  3. Gen. Product Posting Grp. Define Accounts.
  4. Sales & Receivables Setup. & Setup No. Series For Prepayment.

10. Diffrence between Cash Receipt Journal and Payment Journal?

 Main Difference is you can use check Functionlity with PAyment Journal which is not available 

with cash receipt Journal.

11. What is the use of Remaining Amt. on CLE and Open Field?

Original Amount and Remaining Amount columns on CLE & VLE. If the Remaining Amount column is zero, the full payment has been received.

if the checkbox is not selected in the Open column, the invoice is fully settled.

12. What is Payment Registration Functionality in NAV?

This functionality of MS Dynamics NAV provides you to check all the payments that needs to be 

received or paid. You can also post the payment directly from here. Pth is as below in Cronus

CRONUS International Ltd./Departments/Financial Management/Cash Management

13. What is Data Exchange Framework in NAV?

This framework is basically designed for payment and bank reconciliation in MS Dynamics NAV.

You can look at table and codeunit in 1200 series and can use the functionality to import any type of 

data format in the navision.

Saturday, August 12, 2017

How to use email Item Record Table and Mail Management Codeunit

Hi All,

Thanks to Saurabh Sir for provoking me to write this blog. I thanks him for providing new

information as much as possible. I had followed his blog and re - writing this blog with variables and

screenshots which were not available there. So it will be better to understand few consultants like me

slow learner.

To go directly to Link click here Saurav Dhyani

I had applied the same solution you can view the screenshot and download my solution from Here

Download Codeunit 50000

Download Report 50000

Download Page 22 Customer List

Remove the objects present already on these ids and before importing these objects.

This report is using the concept of Open Field present on Customer Ledger Entries and calculating

the sum of amounts in navision RDLC Reports.

Codeunit is using TempBlob Record Table also to customize the requirement.




Friday, August 11, 2017

August 2017 Latest MIcrosoft Dynamics NAV released Cumulative Update 09

Hi ,

This post provides information about the latest cumulative updates provided by microsft for NAV 2017 Version.

Get your Latest CU 09 for NAV 2017 August 2017 release.

All summarised sheets of cumulative update is provided in the link below:



Download NAV 2017 August Release 2017




Monday, August 7, 2017

Microsoft New Latest Release NAV 2018

Microsoft Latest Release TENERIFE MS Dynamics NAV 2018

So Friends,

Microsoft is going to release its next version of NAV and it is known to be MS Dynamics NAV 2018.

TENERIFE


So wait for the latest release of MS Dynamics NAV 2018 at my blog.

This blog post will update you all latest knowledge of MS Dynamics NAV 2018.



"Tenerife" will be able to use online 24 * 7 Artificial Inteligance Web Services like capability to take decision on behalf 

of images and activities.

Hope So ,Microsoft will also extend its capabilities in Dynamics 365 Finance and

Operations Business edition.


New Development tools for NAV 2018


Drag and Drop Facility for several customization steps.

Visual Studio to develop extensions in MS Dynamics NAV. 

All About MS Dynamics 365 Registration and certification for MS Dynamics?

What is Dynamics 365 from scratch and all?


So Guys for past one year we are in news of MS Dynamics 365 released by Microsoft and now it is 

available in 2 Versions .

Dynamics 365 For Business .

Dynamics 365 For Financials.

What are these 2 Terms So stay with me for whole bunch you will get all here.

These 2 are basically SAAS based service Software as service one of the 3 categories of cloud based 

implementation.

Who can use it?

Any small , mid or medium size enterprise who needs to automate its business tracking via software can use it.

What it really is?

In terms of ERP , it is an cloud based ERP System based on CRM and ERP NAV integration, if you 

have really worked on MS Dynamics NAV then you can relate it with the process. So without 

wasting much of your precious time

time I will tell you how a normal consultant or any business owner can start with Dynamics 365.

To Register For MS Dynamics NAV ,

You may need to sign up for Microsoft Account or hotmail login, Because it will be required in Further process,






How To Learn Dynamics 365 customization?

I can provide you the Link For Certification , So for my next training material for these certification 

you may contact me and subscribe for my blog so that next time it will directly reach at your mail ID.




How Purchase of an item Impacts our Navision and its ledgers?


This is regular impact of MS Dynamics NAV in Cronus Database provided by Microsoft.

SO to summarise the whole scenario let me give a brief.

To purchase an Item you can do a Purchase Order or Purchase Invoice. Many a times we create a 

Quote to send our Vendors.

Quote as such has no impact on ledgers.

If you make a receipt of Order it will update your

ILE and Posted Receipt is created for the same Order.

If you post the invoice for the same order or directly creating the invoice of an Item then it will,

update your all ledgers as follows

Vendor Ledger Entry

Detailed Vendor Ledger Entry

G/L Entry

Value Entry

Tax Entry / Vat Entry if applicable.

IF Reservation is applicable you will get separate Lines of Items in ILE else all will be summarized.

Saturday, July 15, 2017

This Is How 14 Questions Which You Must Ask From Yourself Before Implementing GST In MS Dynamics NAV.

Hi Readers,

India has launched GST on 1st July 2017, we had implemented the same on our customers. So this

post is most awaiting for me to summarize my steps on how to implement GST in Microsoft

Dynamics NAV 2016. I will try my best to make this post as small as possible.

To start with I want to give an brief intro of 14 Questions which you must ask from yourself before

implementing GST in our MS Dynamics NAV.

These are basically the functional questions which a functional consultant must know.

So let us begin the journey to Understand GST.

How to setup GST in Microsoft Dynamics NAV for

INDIAN Version?

Step 1.

Understand GST and Types of GST in Microsoft Dynamics NAV.

Previously we have 2 types of taxes :-

1. Direct Tax (Income Tax & Corporate Tax)

2. Indirect Tax (Central Tax & State tax)

Now we have 3 Types of Taxes :-

1. SGST (State GST)

2. CGST (Central GST)

3. IGST (INTRA State GST)

We have set GST Rate as :-

5%
12%
18%
28%

There will be a 15 Digit GST Number called as GSTIN

State Code 2 Digit
PAN No.    10 DIGIT
ENTITY CODE 1 Digit
CHECK DIGIT 1 DIGIT
BLANK       1 DIGIT

Q.2 Where we need to update GSTIN Reg. No. ?


1. Company Information

2. Location Masters

3. Vendor Masters

4. Customer Masters

Q3. What is GSTIN , UID OR GID and where are they defined in NAV?


1. GSTIN 15 Digit CODE for suppliers

2. UID     UNIQUE IDENTIFICATION NUMBER from GSTN Portal applicable for UN BODIES and required by supplier supplying goods to these.

3. GID     Government Bodies not making outward supply of GST goods but making inter state purchases.

In NAV You can select it in Customer Master Field Name GST Registration Type.

Q4. What are HSN and SAC Code.?

Harmonized System Nomenclature applicable for Goods

Service Accounting Codes applicable for Services.

HSN Code  is 8 Digit

IF Turnover is > 5 Crores mention 4 Digits

IF Turnover is 1.5 to 5 Crore mention 2 digits.

For Export and import Mention 8 Digits.

Taxpayer May use 6 digit or 8 digit.

Q5. Where HSN/SAC is defined in NAV?


A master Field is provided in Item Table and GL Account for each Item and Service.

They flow in Sales Line and purchase line.

System Validates HSN/SAC Code at the time of applying an advance payment with an invoice.

Purchase lines are also clubbed based on HSN or SAC Code for Reconciliation.

Q6 What is a Place of Supply?


As per GST this is place where services are provided or goods are sold on the behalf of this only

transactions are decided if its inter or intra state.

It can be Buyer's ,Seller's or any other place where goods are delivered or service is provided.


Q6 What are the conditions on which CGST , SGST and IGST is decided?


Intra State When location of supplier and place of supply is Same
CGST
SGST

Inter State When location of supplier and place of supply are in different States.
IGST

Q7 How Navision is handling the impact of place of supply on product design?

In NAV,
Place supply is Bill to Address , Ship TO Address or Location Address.

GST Dependency Type Field has been created in Sales & Recievable Setup with above 3 options.

The option must be

Place of supply for sale of all goods and services.

For any GST Group ,
if Place of Supply is diffrent from what is defined in GST Dependency Type then same can be defined in GST Group Setup.

Q8. How Place of Supply is mentained in NAVISION?


Place of Supply is defined in GST Group Setup then the same flows to GST Place of Supply field in Sales Lines

If it is not defined then GST Dependency Type shall flow to GST Place of Supply Field in Sales Lines.

System validates shipping location state code and place of supply
state code with GST configuration setup for any matching line and triggers the tax accordingly.

Q9. How time of supply is handled in Nav?


Time of supply provisions of Model GST Law contemplates when Liability.

Time of Supply for goods & Services:

Invoice Date or Receipt of Payment whichever is earlier.

Time to supply for goods subject to reverse change.

Date of receipt of goods.

date of payment.

date immediately following 30 days from date of issue of invoice by supplier.

Time to Supply for Services subject to reverse charge

date of payment

date immediately following 30 days from date of issue of invoice by supplier.

Time of Supply for Associated Enterprises

date of entry in books of account of the recipient
date of payment

Relevance of time of supply in product design

Time of Supply for creation of General Ledger entries.
When Payable Account is credited in accounting entries.

Q.9 What are documents needs to be prepared at GST?


Tax Invoice A registered taxable person at the time of supplying taxable goods/services.

Self Invoice A registered taxable person who is liable to pay tax under reverse charge for goods or services purchased from a person who is not registered.

Bill of Supply A registered taxable person supplying exempted goods or services

Credit Note issued by supplier

if taxable value in tax invoice exceeds actual tax amount

Return of goods by purchaser
recipient rejects the service

Debit Note
Supplier issues a debit note if taxable amount in a tax invoice is less than actual value of tax amount.
Supplementary Invoice

Q10. How NAV is Relevant to a product design?


In Purchase documents , a field Invoice Type is created with options

Invoice
Debit Note
Supplementary
Non-GST

User can select any one at time of posting.

If Invoice type is blank system will pick it as tax invoice.

Self Invoice comes with a posted no. series which can be defined in Purchase & Payable Setup.

In Sales Documents also Invoice Type is created with same options.

In Service Module , Separate posted invoice number series is provided and defined in service setup.

Q11. How NAV is Handling NON GST Supplies?


NON GST Purchase must be available in GSTR 2.

NON GST Sold must be available in GSTR 1.

An Invoice type of NON GST has been created in Both purchase and sales documents to capture

NON GST Transactions.

Q12 How Bill of Entry Details are maintained?

For Goods imported

Bill of entry No.

Date and Value is kept in GSTR - 2

Purchase documents contains all this in Tax Information Column.

Fields are mandatory where vendor type is import and purchase lines are of item.

Q13. What are the mandatory Address for B2C supplies?

Address of Buyer in every invoice >=50000

Invoices less than 50000 and no address are reported under GSTR 1

Address and State Code are mandatory fields in customer master.

Q14. How Bill of Export is maintained in NAV?

For Goods exported Shipping Bill or bill of Export No. and date are to be reported in GSTR 1.

Sales Document contain Bill of Export No. and Bill of  export date is present in information tab.

These fields are mandatory where Customer Type is Export and sales lines are items.



Saturday, July 8, 2017

How To Setup VAT Value Added Tax in MS Dynamics NAV 2017 ?

Dear All,

As we Know GCC countries are soon going to implement VAT Taxation System in their countries so

I just want to share some important steps for you all.

This is a summarised step and I hope it will help you out all for successful implementation and

upgrade your system to access VAT in MS Dynamics NAV 2017.

What is VAT Value Added TAX?

The Esteem Included Expense, or VAT, in the European Union is a general, comprehensively 

construct utilization impose surveyed with respect to the esteem added to merchandise and ventures.

 It applies pretty much to all products and enterprises that are purchased and sold for utilize or 

utilization in the European Union. Subsequently, merchandise which are sold for fare or 

administrations which are sold to clients abroad are regularly not subject to VAT. Then again imports 

are saddled to keep the framework reasonable for EU makers so they can contend on square with 

terms on the European market with providers arranged outside the Union. 

Esteem included duty is 


a general duty that applies, on a fundamental level, to all business exercises including the generation 

and dissemination of products and the arrangement of administrations. Be that as it may, if the yearly 

turnover of this individual is not as much as a specific point of confinement (the limit), which 

contrasts as per the Part Express, the individual does not need to charge VAT on their deals.

How to Setup VAT in MS Dynamics NAV 2017 ?

Step 1.
Create a new vendor.
Define gen. bus. posting group, VAT BUSINESS Posting Groups For Customer And Vendor
and Vendor Posting Group.
Step 2.
Create an item,Gen. Product Posting Group,Vat Product Posting Group,Inventory Posting Group.
Step 3.
Create Purchase Invoice and now Setup VAT Posting Setup,
Create new Code and define VAT & Percentage define Accounts also for sales and purchase.
Step 4.
Create a customer and define
Gen. Bus Posting Grp
VAT Bus. Posting Grp
Customer Posting Group
 Step 5.
Create a sales Invoice and post the invoice.
Step 6.
Check for VAT Entries.
Step 7.

Now check for Reporting VAT

You have to search for VAT Statement in search bar.
Create a new statement
EDIIT VAT Statement
Row No.
Setup For Sales And Purchase VAT Statement here
Now run this batch report to settle VAT amount in Chart of Accounts.
Report Name

Calc. and Post VAT Settlement

No Start Date
Enter Ending Date
Posting Date
Provide a document No.
Provide a Settlement No.
Run this report.
Step 8.

Check VAT Entries.


Friday, July 7, 2017

Cumulative Update 08 Released For MS Dynamics NAV 2017

Dear All,

Microsoft just released the latest cumulative update for MS Dynamics NAV 2017 for July 2017.



This aggregate refresh contains all the hotfixes and administrative capacities that were discharged for

Microsoft Elements NAV 2017, including hotfixes and administrative capacities that were discharged

in past total updates.

This aggregate refresh replaces the already discharged total updates. You ought to dependably

introduce the most recent refresh rollup.

Note: Usage of this refresh rollup requires a database overhaul.


You may need to refresh your permit after you execute the hotfix To access new elements that are

 incorporated into this or past total updates (just applies to licenses for the client).

Rundown of combined updates for Microsoft Flow NAV 2017 see the arrival of the refresh rollup for

 Microsoft Progression NAV 2017 . Aggregate updates are intended for new and existing clients who utilize Microsoft Progression NAV 2017.

Vital


We prescribe reaching Microsoft Progression accomplice, before you introduce the hotfix or refresh.

Verify that your condition is good with the hotfix or refresh introduced. Hotfix or refresh may cause

interoperability issues with customizations and outsider items work with Microsoft Flow NAV.

 How to install this Update Click Me

Wednesday, June 14, 2017

Types of Tables in Microsoft Dynamics Navision 2017

Summary of Tables in MS Dynamics NAV 2017



Hi,
These are the tables that are used in MS Dynamics NAV. It is a summary of the post for all tables present in MS Dynamics NAV. You will learn about these and hope you will enjoy too.

What are tables?

Tables are the collection of records and it is the heart of any database because it contains all the 

values and data for further manipulation of records.

To implement any solution you first need to learn how to store the data in an accurate way. So to get 

the logical output you must check this blog for bettter understanding.

1. Master Tables



2. Journal Tables



3. Document Tables



4. Document History Tables



5. Setup Tables



6. Supplemental Tables



7. Subsidiary Tables



8. Ledger Tables



9. Register Tables



Cumulative Update 07 for Microsoft Dynamics NAV 2017 Build 16996

CU 07 FOR NAV 2017

Microsoft has released its new cumulative update 07 for NAV 2017. You can download the link for 

Cumulative update from the below link.

Download CU 07 NAV 2017
Download CU 2017
The latest update have been released for Microsoft Dynamics NAV 2017 which includes hotfixes.

Note Implementing this cumulative update will require a database upgrade.

It may be necessary to update your license after implementing this hotfix.
For a list of cumulative updates released for Microsoft Dynamics NAV 2017.

Link to see the overview :-

 Overview Details of this Update
 Overview Details of this Update
You can check the list of all updates from here of MS Dynamics NAV 2017.
 List of Cummulative Updates for MS Dynamics NAV 2017
 List of Cummulative Updates for MS Dynamics NAV 2017

Hope you are enjoying it.

Monday, May 29, 2017

Grouping In Export To Excel Report Without Layout in MS Dynamics NAV 2017

Grouping In Report with Code in A/L


Hi All,

Today I Got a Requirement for Excel Buffer Report in Navision and with Grouping of Location 

Code in Item Ledger Entry.

Typically it was tough requirement , but thanks to MS Dynamics Community and Saurabh Dhyani Sir

for his valuable time which shared a most important thing and rarest blog of Navision.

Direct Link For Grouping of Reports via Coding in MS Dynamics NAV

I had used the same method  in MS Dynamics NAV 2017. I am Sharing my FOB with you all to 

download and understand the issue better.



Useful Points about this Report

1. We can use grouping via C/AL Code.

2. We can arrange the Function via boolean Field.

3. Use of Exit Function in MS Dynamics NAV.






Tuesday, May 23, 2017

How to do dynamic implementation of decimal place in RDLC Reports?


Dear All,

Today  I had requirement from report in RDLC to implement dynamics Decimal Places. Initially it was to realise but I followed report 206 and once again I got my solution done soon.

For those who still not understand check the red screen there we have dynamic decimal place Value.

Solution :-

To implement this we have to use custom decimal formatting in RDLC reports and in that we had to define Format Value.

For Reference see the screen Shot.










This post also explain to juniors when you need to use Format Value in RDLC Reporting.


Thanks for your time to read my blog post.


Sunday, May 21, 2017

How NAV Calculate Unit cost of items in NAV?

How to Calculate Unit cost in Reports of NAV?


Using the below code MS Dynamics NAV Calculates Unit Cost in Report of 746.

ItemRec.RESET;

ItemRec.SETRANGE(ItemRec."No.","No.");

ItemRec.SETFILTER(ItemRec."Date Filter",'%1..%2',0D,CALCDATE('-1D',SDate));

IF ItemRec.FINDFIRST THEN;

ItemCostMgt.CalculateAverageCost(ItemRec,AverageCost,AverageCostACY);

AverageCost := ROUND(AverageCost,GLSetup."Unit-Amount Rounding Precision");

How to Select Boolean Field from page in Nav 2017?

Hi All,

This is code which works very dynamic in selection of boolean field.

We have to create a boolean field in the desired table.






Upgrading from NAV 4.0, NAV 5.0, NAV 2009 SP1, NAV 2009 R2 to NAV 2017

Download Upgrade document For MS Dynamics NAV




If we are upgrading from one of these below versions then

  • Microsoft Dynamics NAV 2009 SP1

  • Microsoft Dynamics NAV 2009 R2

  • Microsoft Dynamics NAV 5.0

  • Microsoft Dynamics NAV 4.0
Use the following links given below to upgrade to NAV 2013 first & then follow the above steps to

 upgrade to NAV 2017:

1. NAV 2013 Upgrade Part I - TextFormatUpgrade2013 Tool


2. NAV 2013 Upgrade Part II - Upgrading the Standard Objects


3. NAV 2013 Upgrade Part III - Data Upgrading


4. NAV 2013 Upgrade Part IV - SQL Migration


**Another useful link for SQL Migration:









Saturday, May 20, 2017

Workflow status Field on journals in NAV 2017.

Hi All,

This was one of my finding which I had done on implementation of Approval status Field in MS 

Dynamics NAV 2017.

In all journals we have workflow but we cant find out which lines are sent for approval nd which are 

approved or rejected.

To get this functionality developed I had put this code on Validate trigger of Status Field in NAV 

table ID 454 Approval Entry.

I had added Field on NAV Table 81 which changing its value acording to the status field on this table.

I hope this post will help many of the NAV developers I am also attaching the FOB in the Post below.




Download the Fob Now



Summary of Pages Article provided by Microsoft

This post is related to the summary I followed from article provided by Microsoft. You can Download the complete article from here.


Note 1 :-

Expression properties let you easily control the same behavior of several controls at the same time. By binding the same property, such as Visible, to the


same Boolean variable, you can toggle visibility of multiple controls from a single line of code. Do not forget to set the IncludeInDataset variable property to Yes.

Note 2 :-



Note 3 :-

You can define both the OnAction trigger and the RunObject property.If you define both, the client runs both the object that is defined in the RunObject

property, and the C/AL code that is defined in the OnAction trigger.

Note 4 :-

Linking Pages and Page Parts

SubPageView Sets a specific table view that is applied to the page part.You can choose the key, the sorting order, and the table filter that are applied to the page part.

SubPageLink Sets up a link between the main page, and the page part. The link lets you filter the page part by field values on the main page, and to apply additional page filters.

Tuesday, May 16, 2017

NAV Tech Days 2017

16 & 17 november 2017, Antwerp (Belgium)

Welcome to one of the most awaited event for Nav. You can register from below link.



Few mentioned events and hints about this Tech days
Pre-conference workshops
Making Visual Studio Code in MS Dynamcis NAV 2017,Dynamics NAV with Power BI, Extensions with VS Code to implement in real transactions. 
Event Sessions
– Building dedicated Mobile Experiences
– SaaSification guidelines
– Deep dive into the new development tools

Some Important Links
About
https://www.navtechdays.com/2017/about

Stay tuned !
@NAVTechDays