Monday, August 15, 2016

Export more than 5000 records to excel in Dynamics NAV

Hello Friends,

Dynamics NAV default setting doesn't allow user to export more than 5000 rows to excel in NAV 2013 and newer version.

If user want to export more than 5000 rows to excel than we need to update following parameter in user custom setting files.

update the tag value: <add key=”MaxNoOfXMLRecordsToSend” value=”100000″/> in user configuration file.

File is located in respected version folder:
















Update the value in following parameter.
























You can find the user configuration file at following location:

Windows Server 2003 or Windows XP:  (Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Microsoft Dynamics NAV\ClientUserSetting.config)


Windows 7, Windows Vista, or Windows Server 2008 : (C:\Users\<username>\AppData\Local\Microsoft\Microsoft Dynamics NAV\ClientUserSetting.config)

Common Error face during the import of Merge Text File - Dynamics NAV Upgrade

Hello Friends,

This blog is only relevant to Technical Developer of Dynamics NAV.
While we doing an upgrade project we have prepare a single merge text file contain all the old version customization and we need to import this text file new standard version base database.

While import the file we have face different type of error - because something wrong during merge or may be there is some text issue in old code.

I have summarize all the possible error during import files and solution for that.
Because some time it is very difficult to identify the issue in merged files.

1)      Error for “//” written in description field

Error:
---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
There is a syntax error in the import on line 220749 in position 2 :   KEYS.

A '{' (ElemBegin) is expected here.
---------------------------
OK  
---------------------------

Error Reason:
There is double slash written in field description
















Solution:
Remove that double slash from description field.

=======================================================================

2)      Syntax Error (TAB Character exists in text constant )

Error:
---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
There is a syntax error.
---------------------------
OK 





















Error Detail:
Tab Character in Text Constant (some time we copy paste the text from word file than it was happen)















Error Solution:
Remove TAB Character manually






=======================================================================

3) “OnBeforePassField” trigger not supported in NAV 2013 and it is also not converted by conversion tool















---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
'Export::OnBeforePassField=12 }' is not an option.

The existing options are:

Indentation, Expanded, NodeName, NodeType, SourceType, ID, ParentID, NamespacePrefix,
Namespaces, Comment, Occurrence, MinOccurs, MaxOccurs, VariableName, Format, TextType,
Width, DataType, Import::OnAfterAssignVariable, Export::OnBeforePassVariable
---------------------------
OK  

Error Detail: OnBeforePassField” trigger not supported in NAV 2013 and it is also not converted by conversion tool






















Solution : This property not supported in new version. Skip import that xmlport and do it latter.

=======================================================================

4) Field Name is change in new version so it is giving error for : “Prod. Order No.” to “Order No.”
















---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
You cannot enter '    {    ;Prod. Order No.,Item No.                 }' in FieldNo.
---------------------------
OK  


Error Reason:
Change the name of field












Solution:
Fix the name of key fields















=======================================================================

5)      } “Breaket” is used instead of semi colon (;)












---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
There is a syntax error in the import on line 32203 in position 50 :                                                   Description=C0011-1001330 }.

A '{' (ElemBegin) is expected here.
---------------------------
OK  


Error Reason:
There is should be line end with semicolon but it is ended by }








Error Solution:
Write the semicon in place of closing breaket








=======================================================================

6)      There is keyword “VAR” is missing before define the variable in function











---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
'BEGIN' should come here.
---------------------------
OK  

Error Reason:
There is keyword “VAR” is missing before define the variable in function








Error Solution:
Enter the keyword “VAR” before the first variable define








=======================================================================
7)      Begin and END line exists with start procedure (it is invalid past line so check and remove it)










---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
'.' should come here.
---------------------------
OK  

Error Reason:
There is invalid line files (Procedure syntax is missing before function code start)





















Error Solution: 
Remove that lines and make it correct
















=======================================================================

8)      Duplicate Name Found in table












---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
The field name can appear only once in a table:

Field Name: Shipping Agent Code
Table: Service Header
---------------------------
OK  

Solution: You have added customize field with same as new standard field. So update the name of your custom field.

========================================================================

9)      You have Replace the “VAR” keyword with “Begin” so system is doesn’t find the END for that new Begin













---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
There is a syntax error in the import on line 120574 in position 50 : 
                                      CaptionML=ENU=Location Code }.

The AL code is not indented as much as the first line.
---------------------------
OK  

Error Reason:
See the following snapshot. Where you can find that you have replace the “VAR” Keyword by “Begin”









In text file it is look like





















Solution:
Update that Begin keyword with VAR keyword























=======================================================================
10)      Error in Import Page File














---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
'{ 64      ;2   ;Action    ;                      CaptionML=ENU=Line Discounts;' is not an option.

The existing options are:

ID, Name, CaptionML, Caption, ToolTip, ToolTipML, Description, Image, Visible, Enabled,
RunPageMode, Promoted, PromotedCategory, PromotedIsBig, ShortCutKey, Ellipsis, RunObject,
RunPageView, RunPageLink, RunPageOnRec, InFooterBar, ActionLevel, OnAction
---------------------------
OK  

Error Reason: There is closing breaket is missing in new action added on page





















Solution: Merge the missing part and it will solve the error









=======================================================================

11)      Error for double semicolon in page









---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
You cannot enter '; } PROPERTIES { CaptionML=ENU=Service Item Card;' in FieldNo.
---------------------------
OK  

Error Reason:
There is double semicolon in data




















Solution:
Remove one to solve error

=======================================================================

12)      Import Error “t_id” import file










---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
't_id' should come here.
---------------------------
OK  

Error Reason: 



















Solution:
Added Breaket to solve error


















=======================================================================
13)      VAR Keyword is missing before define variable











---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
Use the symbol { to start the comment. For example: {Ordinary comment}.
---------------------------





















I will update blog when i face any new error in import.
I hope it will help you some time to get the solution of your issue.

Thank you reading.
Please write the comment if have any query/concern.

Kepp Sharing... Keep Growing...

Happy Independents Day,,,,,

Use of PreventWhiteSpace Property in XMLPort Dynamics NAV

Hello Friends,

Recently I have face the issue in file import by XMLPort.
XMLPort has automatic replace the double space from item code by single space. Because of that I have got error message item code doesn’t exists in item table.

For example,
File has contain item code - HL330063A  REV.0 (it has contain double space)
While we import file the XMLPort has convert the item code as - HL330063A REV.0 (it has contain only single space)

There is one property in XMLPort – PreserveWhiteSpace

Determines whether white space should be preserved in documents that are imported through an XMLport.

By default, Microsoft Dynamics NAV supports the XML standard by normalizing white space in attribute names and values that are imported through an XMLport. It converts tabs, carriage returns, and spaces to single spaces. It also eliminates leading and trailing white space.
When this property is set to Yes, none of these normalizations is performed

So, avoid this issue we just need to set this property value = Yes






















I hope it will help in future.

Find the more detail  at - https://msdn.microsoft.com/en-us/library/ee909558.aspx?f=255&MSPPError=-2147217396

Thank you for reading.
Keep Sharing...Keep Growing....

Sunday, August 14, 2016

GST patch for Dynamics NAV India

Hello Friends,

GST Patch Released for Dynamics NAV !!!
Read the following blog for more detail - GST Patch Microsoft Dynamics NAV

GST bill was passed in Rajya Sabha on 3rd August, 2016 and expected to be implemented from 1st April, 2017.

The GST is completely replacing of existing Indirect tax system. So that our Dynamics NAV ERP has to modify as per new Indirect Tax System.

Microsoft had provided the patch for SBC & KKC after it was announced by Government. 

Let hops that we will get the GST patch before 1st April 2017 by Microsoft.
Patch will be available for following Dynamics NAV IN version:
  • NAV 2013
  • NAV 2013 R2
  • NAV 2016
  • NAV 2017 IN (if it was launched !!!)
NAV 2009 R2 and prior version support close by Microsoft so that GST patch will not release for it.
Partner has to developed it by self or they have 6 months time to upgrade to new version.

Document reports need to modified by developer to show the GST Tax on layout and it is very time consuming task to modified all existing customer reports at a time. 

I wish GST will implement in Dynamics NAV successfully without any trouble for customer and partner.

I will update this blog when i will get any tentative release date for GST Patch for Dynamics NAV IN.

More detail about GST:

What is GST?

GST is a consumption based tax levied on sale, manufacture and consumption on goods & services at a national level. This tax will be substitute for all indirect tax levied by state and central government. Exports and direct tax like income tax, corporate tax and capital gain tax will not be affected by GST. GST would apply to all goods other than crude petroleum, motor spirit, diesel, aviation turbine fuel and natural gas. It would apply to all services barring a few to be specified. With the increase of international trade in services, GST has become a global standard.
The proposed tax system will take the form of “dual GST” which is concurrently levied by central and state government. This will comprise of:
  • Central GST (CGST) which will be levied by Centre
  • State GST (SGST) Which will be levied by State
  • Integrated GST (IGST) – which will be levied by Central Government on inter-State supply of goods and services.
Many taxes has been subsumed under GST which are as under

Central Indirect Taxes & Levies
  • Central Excise Duty
  • Additional Excise Duties
  • Excise Duty levied under the Medicinal Preparations (Excise Duties) Act,1955
  • Service Tax
  • Additional Customs Duty (CVD)
  • Special Additional Duty of Customs
  • Central Surcharge and Cess


State Indirect Taxes & Levies
  • VAT / Sales Tax
  • Entertainment tax (other than the tax levied by local bodies
  • Central Sales Tax
  • Octroi and Entry Tax
  • Purchase Tax
  • Luxury Tax
  • Taxes on Lottery
  • Betting and Gambling
  • State Cesses and Surcharges
Who will pocket taxes?

For Intra State Transactions: In case of Intra State transactions, Seller collects both CGST & SGST the buyer and CGST needs to be deposited with Central Govt. and SGST with State Govt.
 For Inter State Transactions: Integrated Goods and Service Tax (IGST) shall be levied on Inter State transactions of goods and services which are based on destination principle. Tax gets transferred to Importing state. More over it is proposed to levy an additional tax on supply of goods, not exceeding one percent, in the course of inter-state trade or commerce, to be collected by the Central Govt. for a period of two years, and assign to the States where the supply originates. Valuation of stock transfers to be determined. Exports and Supplies to SEZ units will be zero rated.

How to adjust the Credit?
 Setoff of IGST, CGST & SGST will be as follows in the below mentioned chronological order only. 

Credit of             To be Adjusted with
IGST                          IGST, CGST,  SGST
CGST                   CGST, IGST
SGST                         SGST, IGST

What impact GST will have on pricing of products as compared to current scenario?


Let us take an EXAMPLE to understand this clearly.























In the above example, you can note that the tax paid on sale within state can be claim against tax paid on sale outside state in GST system, which is not in present tax system.
The credit of CGST cannot be taken against SGST and credit of SGST cannot be taken against CGST but both credits can be taken against IGST.

ENROLLMENT & REGISTRATION:

NSDL has been appointed to incubate the GST Portal and develop its functionality. NSDL has created a pilot portal known as “GST Pilot Portal” 
Here, every tax payer will be issued a 15 digit common identification number which will be called as “Goods & Service Tax Identification Number” (GSTIN) a PAN based number. 
Online application form for dealers will be available to provide their details and upload documents.
Registration includes basic steps like register themselves on the Enrolment page, and then Login using the given “User ID” and “password”, filling the application form by uploading the requisite documents related to excise, Service Tax, IEC, CIN, Professional Tax number, Shops & Establishment Number and any other state specific registration numbers, contact numbers, postal address & E-mail address of business entity, bank account details including MICR code, place of business, details of goods & services, scanned signed photographs.

Like, every coin has two sides, even this concept of GST has its own positives and negatives,

Positive Aspects
  1. The main reason to implement GST is to abolish the cascading effect on tax. A product on which excise duty is paid can also be liable for VAT. Suppose a product A is manufactured in a factory. As soon as it releases from factory, excise duty has to be paid to central government. When that product A is sold in same state then VAT has to be paid to state government. Also no credit on excise duty paid can be taken against output VAT. This is termed as cascading effect since double tax is levied on same product.
  2. The GST is being introduced to create a common market across states, not only to avoid enfeebled effect of indirect tax but also to improve tax compliance.
  3. GST will lead a more transparent and neutral manner to raise revenue.
  4. Price reduction as credit of input tax is available against output tax.
  5. Simplified and cost saving system as procedural cost reduces due to uniform accounting for all types of taxes. Only three accounts; CGST, SGST, IGST have to be maintained.
  6. GST is structured to simplify the current indirect system. It is a long term strategy leading to a higher output, more employment opportunities, and economic boom.
  7. GST is beneficial for both economy and corporations. The reduced tax burden on companies will reduce production cost making exporters more competitive
Negative Aspects
  1. GST is being referred as a single taxation system but in reality it is a dual tax in which state and centre both collects separate tax on a single transaction of sale and service.
  2. At present the main Indirect tax system of central Government is central excise. All the goods and commodities are not covered by the central excise and further there is an exemption limit of Rs. 1.50 Crores in the central excise and further traders are not liable to pay central excise. The central excise is payable up to the stage of Manufacturing but now GST is payable up to the stage of sale.
  3. Majority of dealers are not covered with the central excise but are only paying VAT in the state. Now all the Vat dealers will be required to pay “Central Goods and service tax”.
  4. The calculation of RNR (Revenue Neutral Rate) is very difficult and further Govt. wants to enhance its revenue hence rate of Tax will be a problem. As per the News reports the proposed rate for State GST is 12% and Central GST is 14% Plus Govt. wants to impose 1% CST at the initial stage of GST on the interstate sale of Goods and services. So the normal rate of overall tax will be 26%. This rate is very high comparing to the fact that small and medium Industries are at present not covered by the central excise and most of the Goods such as agricultural products are out of the preview of the Central Excise.
  5. Improvement in the Manufacturing and distribution of Goods and service, increase in exports, various reforms, check on corruption, less Government control are some of the factors which are responsible for the economic growth of the country. A tax system can make a revolution in the economy of the country is“rarest of the rare” thing.


Thank you reading.

Please write your comment if you have any query.