Category Archives: NAV 2017

Cumulative Update 04 for Microsoft Dynamics NAV 2017 (Build 15601)


Cumulative update 04 released for 2017 and you can download from following links


Problems that are resolved in this cumulative update

The following problems are resolved in this cumulative update:

Platform hotfixes

ID Title
200766 Meeting invites are logged and placed in the store folder but the interaction cannot be opened.
200796 The Web client cannot open a dynamic lookup from the ReqFilterFields property from the request page, such as in Suggest Sales Price on Wksh. report.
200798 Document reports are inconsistent when you select languages and the language code is not within the client languages.
200800 FlowField filtering does not work.
200816 Local month names do not revert to ENU anymore.
200841 The calendar picker opens on an incorrect date.
201505 “The User Setup does not exists. Identification fields and values” error message if you try to rename a user that has user setup in multiple companies.
201850 The Database Lock page does not show locks for cross-company tables.
202601 Text typed into a text field on a page disappears when you use the Ping-Pong Timer Control add-in.
202730 Cached SQL commands can be reused after you install or uninstall an extension that leads to errors.
202733 Extensions fail to publish if there are duplicate type/ID records in the Object table.
202749 CRM Integration does not work with Dynamics CRM 2016 (8.1) and Dynamics CRM 2016 SP1 (8.2) On Premise.
203068 “ControlList Name ‘xxx’ already exists” error message when you look up the EventPublisherElement property.
203304 Events stop being triggered after you compile other objects.
203485 The Business Outlook Add-in throws errors when you click on an email that contains a quote character (‘) in the subject.
203684 The SaveValues metadata is not cleared if a change is made to the global variable length on a request page.
204203 The MenuSuite delta application is wrong when multiple extensions try to create the exact same nodes.
204276 “There are too many actions on the page” error message when you import many language modules.
204473 “Could not find prepared statement with handle -1” error message after SQL Server cluster failover.
204970 Multiple lines of text do not work properly with Word templates.
205010 Including multiple Control-Add ins within a single assembly in an extension show as unhelpful error message.
205037 Installing an extension with a particular dependency configuration can crash the server.
205985 Table views are stored using invariant culture.

Application hotfixes

ID Title Functional area Changed objects
202446 Some TableCaption, FieldCaption fields are editable and FlowFields are not calculated but assigned in some RapidStart tables. Administration TAB 8611 TAB 8619 TAB 8624 TAB 8626
202828 “The Sent Notification already exists. Identification fields and values: ID =1” error message when you copy a company with notifications. Administration TAB 1514
203957 The notification is not created and sent by the workflow if the approval request is rejected by the approver. Administration COD 1535
203978 If you enter a value in the description of a sales or purchase document and the type is different from items or resources, the Number field is not populated automatically. Administration COD 10 TAB 27 TAB 37 TAB 39
203660 User groups are not exported correctly if permission sets are missing. Administration XML 9000
202526 If you post a payment reconciliation journal including a G/L account with some dimensions and in the payment reconciliation line, you set up different dimensions, in the posted entries, a dimension set ID is different from the linked dimensions. Cash Management
204328 The journal is created with an incorrect sign if you use the Transfer to General Journal function on the Bank Acc. Reconciliation page by using a batch with the Bal. Account No. field different from blank. Cash Management REP 1497
205049 “Open must have a value in Cust. Ledger Entry: Entry No. = XXXX. It cannot be zero or empty” error message if you try to post a payment reconciliation journal with multiple payments for the same customer or vendor in a specific order. Cash Management COD 1255 COD 370 COD 426 TAB 1293 TAB 274
201785 Inconsistencies with the field layout on the Item Card page and the Contact Card page. Client PAG 21 PAG 26 PAG 30 PAG 42 PAG 5050
202299 The Amount in FX gain/Loss account is not reversed on reversal of payment. Finance TAB 179
202774 Posting an IC general journal to an IC partner with no currency code will create an outbox transaction, which pulls the source company’s LCY code in the G/L setup. Finance
202841 “The Workflow Step Instance does not exist. Identification fields and values” error message if you delete lines form a workflow and put them back in. Finance TAB 1502
203437 The Standard Sales – Invoice report hows an incorrect total value when the Incl. VAT, Amount Excl. VAT value is missing. Finance REP 1306
203452 The Where-Used list for a component item does not show the closed production BOM that it is part of when it is part of an active version. Finance COD 99000770
203479 “The hidden expression used in tablix “Vatentry” returned a data type that is not valid” error message if you run the EC Sales List report for a period where there are no entries in the system. Finance REP 130
203574 The income statement account becomes the balance account when you create a new G/L account with a blank Account Category value. Finance TAB 15
203964 Performance issues when you run the Change Global Dimensions report. Finance REP 83
204064 GLSetup.GET is missing in the InitializeRequest function in the Change Global Dimensions report. Finance REP 83
204638 Different error messages in the Aged Account Receivable and Aged Account Payable reports. Finance REP 120 REP 322
205466 For a set of G/L entries with the same transaction number, the balance is not zero. Finance COD 12
201706 The VAT entry and related G/L entries are missing after the Apply, Unapply, and Reverse Transaction operations. Finance TAB179 COD17
204282 Under certain circumstances, VAT entries are not created as expected on the Fixed Asset Disposal report. Fixed Assets COD 12
204506 Under certain circumstances, fixed asset ledger entries are not created as expected. Fixed Assets COD 90
202552 “There was a problem pasting the rows” error message when you paste rows into a standard cost worksheet when the last item line has Standard Cost = New Standard cost. Inventory TAB 5841
202643 The Next Counting Start Date value and the Next Counting End Date value is not consistent when you use a period greater than 12 for the count frequency. Inventory
203001 Special characters as ‘=’, ‘>’ in an item variant code causes the Calculate Inventory Value batch job to not recognize any values. Inventory REP 5899
203162 When you save item journal lines as standard journals, it is possible to create an incorrect item ledger entries and influence inventory values. Inventory REP 751
203481 Standard text is not renamed on sales lines. Inventory TAB 7
203626 The item unit of measure is not validated when a base unit of measure is automatically populated when using the Item Templates page. Inventory TAB 1301
204225 The unit amount is reset to 0 while the unit cost remains on old value when you change the quantity on an item journal line. Inventory
201743 “Qty. Transferred to Invoice must be equal to ‘0’ in Job Planning Line” error message if you try to create two sales invoices from the same job planning line using a job in a foreign currency. Jobs TAB1003
202345 The manual unit price should not be overwritten with the unit price from the item card if you change the location in the job planning line. Jobs COD 7000
202594 Job journal posting is slow. Jobs TAB 167
203577 If you drill down on the Resource, Item, or G/L Account fields in the Billable Price section of Job Details FactBox in the Job Card page, the filters applied are incorrect. Jobs PAG 1030
201885 “Select Dimension Value Code X for the Dimension Code Y for Item Z” error message when you post production journals where output has a linked backflush consumption. Manufacturing COD 22
202053 When the Capable-To-Promise calculation has been accepted from a sales order, the suggested planned production orders in the planning worksheet and the Ref. Order No. field is incremented by more numbers (9) than what is defined in the number series Line (1). Manufacturing COD 99000886 TAB 246
203005 “Overflow under conversion of System.Int64 value Y to System.Int32” error message when you refresh a production order. Manufacturing COD 99000774
203007 “Overflow under conversion of Microsoft.Dynamics.Nav.Runtime.Decimal18 value Y to System.Int32” error message when you navigate to the Structure page in item card. Manufacturing COD 5870
204022 “You must set a location filter” error message when you enter a forecast without a location defined. Manufacturing PAG 9245
205943 When a Capable-To-Promise calculation has been accepted from a sales order, the suggested planned production orders in the planning worksheet, the Ref. Order No. field is incremented by more numbers (9) than what is defined in the number series (1) field. Manufacturing COD 99000886 TAB 246
203619 “Document No. … cannot be zero or empty” error message on posting preview in a purchase order. Purchase COD 90
204444 “You do not have the following permissions on TableData Purch. Rcpt. Header: Insert” error message if you try to delete a purchase invoice for which you get an error message when you try to post it. Purchase COD 364
201015 The Sales Invoice report does not print the Total Excl. VAT value and the Total GB Incl. VAT value when the last line is a text line in the invoice body. Sales REP206
201308 The Document Sending Profiles page does not work as expected if you select posted sales documents for two different customers at the same time. Sales TAB 112 TAB 114 TAB 167 TAB 38 TAB 5992 TAB 5994 TAB 60
202519 The due date in the planning worksheet is not based on the shipment line when it relates to a sales blanket order. Sales COD 99000854
202646 “The Sales Line already exists. Identification fields and values: Document Type=’Invoice’,Document No.=X,Line No.=Y” error message when you get shipment lines for an earlier posted shipment which has discounts. Sales
203397 Extended texts are not pulled into the document as expected if there are more than one extended text for an item. Sales COD 378
204649 Several page actions on the Customer List page have the same name preventing implementation of NAV events based on the OnBeforeActionEvent event. Sales PAG 22
203155 Error when you add a non-stock item to the Service Order – Service Lines page  . Service TAB 5902
201872 “Qty. to Handle (Base) in Tracking Specification for Item No. X, Serial No.: Y, Lot No.: Z is currently A. It must be B” error message when you post a warehouse shipment for a remaining quantity where earlier shipped quantity is on an unposted invoice. Warehouse COD 6501
201882 The Item Availability by Period page does not use the Firm Planned status in the filter for the Prod. Order Comp. Line List page. Warehouse PAG 99000902
202492 “There is nothing to handle” error message when you create an inventory movement for reserved stock. Warehouse COD 7322

Local application hotfixes

AT – Austria
ID Title Functional area Changed objects
202843 In the VAT Statement AT report, the categories 067 and 090 are not correct if the total amount is negative in category 72 in the Austrian version. Finance REP 11110
202844 The tracking entries in the Reservation Entry table do not consider the already picked quantity that causes duplicate info in the Austrian version. Inventory COD 6500 COD 99000831 PAG 6510
AU – Australia
ID Title Functional area Changed objects
203415 The Cost Amount (Expected) field is not updated and the expected cost is not posted to G/L for subcontracting production orders in the Australian version. Manufacturing COD 22
203292 The bin code is repeated for all actions of type Take on the Pick page in the Australian version. Warehouse COD 7312
BE – Belgium
ID Title Functional area Changed objects
203488 The Column No. field is optional but if it is not defined, the Purchase Analysis by Dimension page will not show any columns in the Belgian version. Administration PAG 7118
204204 “The field Applies-to Entry No. of table Direct Debit Collection Entry contains a value (nnn) that cannot be found in the related table (Cust. Ledger Entry).” error message when you create a file with the Domiciliation Journal page in the Belgian version. Cash Management REP 2000039
201964 PEPPOL Export does not use the Company Enterprise No. field. in the Belgian version. Finance COD 1605 COD 1620
201608 Printing special orders from the Carry Out Action Message report within the Requisition Worksheet page only prints one purchase order out of two created for same vendor in the Belgian version. Purchase COD 333 TAB 38
202302 The calculation of the row total is incorrect in the VAT Statement Preview page if you enter a VAT correction on a row where calculate with is an opposite sign in the Belgian version. VAT/Sales Tax/Intrastat PAG 475
CZ- Czech
ID Title Functional area Changed objects
201610 Issue with production BOM lines that already exists in the Czech version. Manufacturing REP 99001043
ID Title Functional area Changed objects
203470 “You do not have the following permissions on TableData VAT Entry: Modify” error message when you use the Set G/L Account No. function in the DACH version. Finance PAG 315
204228 “Item XXX cannot be shipped because inventory at location “”, bin “”, variant “” is only 0.” error message when you post a sales order with item of type Service having the Block Ship. value and the Neg. Invent. value set to Yes on the Sales & Receivables Setup page in the DACH version. Sales
DE – Germany
ID Title Functional area Changed objects
202406 “You cannot revalue individual item ledger entries for items that use the average costing method” error message when there are deleted items in the database in the German version. Cash Management TAB 83
202800 If you export an account schedule to Excel, the default page size is always set to Letter regardless of the country default value in the German version. Finance TAB 370
203459 An order-to-order link is not created when you create a released production order with source type Sales Header in the German version. Manufacturing COD 99000787
ES – Spain
ID Title Functional area Changed objects
201931 A value entry recognizes an item charge amount as Cost Amount (Actual) in cases where an item charge is recorded on the Purch. Invoice page, it is assigned a shipment line and recorded with a discount in the Spanish version. Administration COD 22
202998 Unpaid sales invoices sent to Dynamics CRM via CRM Integration are showing as Paid in Dynamics CRM in the Spanish version. Administration
204138 Possible overflow in the SplitPurchInv function in the Spanish version. Administration COD 7000005 REP 10743
204918 “There is nothing to Void” error message if you try to void customer refunds from the Payment Journal page in the Spanish version. Purchase REP 10722
205297 “In order to use electronic payments one of the bank accounts for the vendor must have the field Use For Electronic Payments selected” error message if you enter a customer line with the Electronic Payments Bank Payment type on the Payment Journal page in Spanish version. Purchase TAB 81
205172 The E-mail and VAT Registration No. fields are overlapped in the Statement report if you export the report to PDF with a long email on the Company Information page in the Spanish version. Sales REP 116
FI – Finland
ID Title Functional area Changed objects
205342 If you have open invoices and credit memos and the total is zero, it is possible to create a bank file but not to suggest the payment in the Finish version. Cash Management REP 393
FR – France
ID Title Functional area Changed objects
203970 The Export G/L Entries – Tax Audit report does not show the correct applied entry numbers in the EscritureLet field if you apply several invoices with different Apply-to ID in the same payment slip in the French version. Finance REP 10885
201723 “Sales Line: The Item does not exist. Identification fields and values” error if you rename an item and open an existing sales order containing that item in the French version. Inventory TAB 15 TAB 156 TAB 27 TAB 37 TAB 39 TAB 5600 TAB 5800
IT – Italy
ID Title Functional area Changed objects
204209 It is possible to set a closing date as working date in the Italian version. Administration COD 12
203464 If you post a purchase invoice where the currency code is set, the system does not check that the total amount of the lines corresponds to the amount inserted in the Check Total field in the Italian version. Finance COD 90
205005 The Replace Document Date field does not work in the Batch Post function in the Italian version Finance
NA – North America
ID Title Functional area Changed objects
204379 You cannot switch between List and Chart on the Deposit List page in the North American version. Cash Management PAG 10146
202934 Inconsistency error when the sales tax rate calculation results in a difference in the tax amount on the sales lines and from what is shown on Statistics page in the North American version. Sales COD 398
NL – Netherlands
ID Title Functional area Changed objects
202197 If you reverse a G/l entry after applying it, the remaining amount of the entries do not balance with the total amount of the posted entries in the Dutch version. Finance PAG 11309 TAB 11307 TAB 179
203584 The Receive Response Messages report fails with a permission error in the Dutch version. Finance REP 11408
205120 VATIdentificationNumberNLFiscalEntityDivision in ICP Declaration is filled unexpectedly even if ElecTaxDeclarationSetup. Part of Fiscal Entity is FALSE in the Dutch version. Finance REP 11404
202689 The Import protocol is wrongly bound to the Objects (Telebanking) page in drilldowns and lookups in the Dutch version. VAT/Sales Tax/Intrastat PAG 11000015
UK – United Kingdom
ID Title Functional area Changed objects
202410 The Carry Out Action Message function moves the due date to a later due date instead of to an earlier due date when the original due date is non-working day in the British version. Manufacturing COD 99000854
RU – Russia
ID Title Functional area Changed objects
201939 “The following C/AL functions are limited” error message when you print from the Item Shipment page in the Russian version. Inventory TAB 112 COD 229 PAG 12450 PAG 12452 PAG 5629 TAB 12451 TAB 12471 TAB 77
202925 The Posted Cr. M. Factura-Invoice report shows the data in columns in the wrong order in the Russian version. Finance COD 12401 REP 12484
203746 Strange difference in initial and reverse sides of G/L Corresp. Entries records for the Debit/Credit Дохрасх Код columns in the Russian version. Finance COD 12404
204134 Repeated fixed asset depreciation after the reverse transaction is impossible in the Russian version. Finance COD 5616
204219 “The length of the string is 20, but it must be less than or equal to 10” error message when you run the Purchase Receipt M-4 report in the Russian version. Finance REP 12475 REP 12483

Fetch Filename from Directory using DotNet Datatype-NAV 2017

During recent implementation got task to fetch the files from specified directory to import in tables using XMLPORT and I was using NAV 2017.

Now in classic version we were able to use FILE and this virtual table was giving us the list of files in specified path by using required filters and we were able to import data from multiple files.

Coming to latest version to find the files in directory I used DotNet variables as follows

From one of the folder I am fetching the filename as follows


Define the variables as follows

Name             Data Type               Sub type                                                       Length
gvDirectory  DotNet                      System.IO.DirectoryInfo.’mscorlib’
gvFile             DotNet                      System.IO.FileSystemInfo.’mscorlib’
gvArr              DotNet                       System.Array.’mscorlib’
i                        Integer

In one codeunit write following program

FOR i:=0 TO gvArr.Length-1 DO





This will help in importing the multiple/sequential’s files in tables using XMLPORT.

Let me know yours feedback.



Cumulative Update Summary-Feb 2017


Following is summary for cumulative update release in month of February

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you.

Download Cumulative update from following

NAV 2013 CU 47  Build No 47667  download from NAV2013 CU47

NAV2013 R2 CU40 Build No 47662 download form NAV2013 R2 CU40

NAV2015 CU 28 Build No 47871 download from NAV2015 CU28

NAV 2016 CU16 Build No 47864 download from NAV2016 CU16

NAV 2017 CU3 Build No 15140 Download from NAV2017 CU03


Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed

Media Datatype-NAV2017

In this blog will try to explain how Media data type works in NAV2017 for uploading media,image.

Media data type store media in system tables of the database and then reference the media from application records. Media datatype provided better performance than traditional BLOB datatype. With BLOB datatype ,media is rendered every time in the client ,Media datatype provides unique Media ID to provide the data to client.

Table fields support data types for adding media to records. You can import media directly to a record . This media will get store in the system table Tenant Media with the unique identifier (ID). 

The media data type is associated with single media.


Following example illustrate how to use Media data type in development.


Field Id Field Name Data type
1 PictureNo Integer
2 MyPicture Media

Create list page and card page with above fields

Create one Action button on Page for importing the image.

Define following variable

filename   Text   250

MediaID   GUID
IF filename<>” THEN BEGIN
MediaID :=Rec.MyPicture.IMPORTFILE(filename,’Media Image’+FORMAT(Rec.PictureNo));

In tenant Media table following GUID will get inserted


Now Open the page in Web client and see the result


Following Media types are supported.

  • BMP
  • EMF
  • EXIF
  • GIF
  • JPEG
  • PNG
  • TIFF
  • WMF

You can use this method for applications that are developed for the Microsoft Dynamics NAV Web client and Microsoft Dynamics NAV Universal App:

  • Display media with records in list type pages, when the page is viewed in the Brick layout.
  • Display media on a card type page for a record.
  • Display media in a report.


Keep testing and let me know your feedback