Cumulative Update 06 for Microsoft Dynamics NAV 2017 (Build 16585)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2017, including hotfixes and regulatory features that were released in previous cumulative updates.

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

Note Implementing this cumulative update will require a database upgrade.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2017, see released cumulative updates for Microsoft Dynamics NAV 2017. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2017.

Important

We recommend that you contact your Microsoft Dynamics Partner before you install hotfixes or updates. It is important to verify that your environment is compatible with the hotfixes or updates being installed. A hotfix or update may cause interoperability issues with customizations and third-party products that work with your Microsoft Dynamics NAV solution.

Problems that are resolved in this cumulative update

The following problems are resolved in this cumulative update:

Platform hotfixes

ID	Title
207247	Calling OData from Excel to refresh the data from a query causes ASYNC_NETWORK_IO to consume too many SQL work threads, which leads to SQL Server instability.
208194	System.InvalidCastException when you export data.
208668	The FORMAT function incorrectly returns 0 rather than 7 as weekday for Sunday.
208816	"The server "DynamicsNAV100" was unable to process the request. The application will close" error message and the Windows client crashes when you try to use a lookup while stepping through the code with the debugger.
208823	NAV 2017 middle-tier crashes on data upgrade.
209206	"The metadata object Page xxx was not found" error message with XMLPort when you use SQL tracing.
209210	CSIDE .NET Interop Stream conversion does not work between objects.
209318	The No. field is missing in the Go-To functionality because the No. field is not visible.
209464	Improved detection of locking in the development environment when starting a database upgrade on Azure SQL DB
210332	InputFile.OPEN using TEXTENCODING::UTF8 only seems to handle 1,000,000 characters.
210414	The quick filter on the Customer List, Vendor List, Item List, Resource List, and Fixed Asset List pages contains the Image value, which does not make sense.
210518	The New-NAVAddin cmdlet fails when you use it with assemblies that contain multiple add-ins or if the add-in control name is different to the assembly name.
210617	The client crashes when you run reports with Full SQL Trace enabled.
210634	Uninstalling an extension with D365FF may crash a report or make it unusable if it is related to it.
210787	Stream conversion between the .NET data type and InStream/OutStream as parameter does not work if the stream is passed by reference (VAR).
210797	Building extension fails if the control add-in assembly has a different assembly name than the value of the ControlAddinExport attribute.
211036	The Apply Vendor Entries page is unusable in the Safari web client.
211571	Word report design cannot be maintained and it overwrites cell alignment of repeatable lines in a Word table.
211788	A mapped user in Dynamics NAV can be synchronized with CRM after the related CRM user has been deleted.
212731	Errors appear in the event log file when you use the new type of Outlook add-in in a multi-tenant environment.

Application hotfixes

ID	Title	Functional area	Changed objects
210099	The OCR job queue entry is set to On Hold if the NAV client is not waiting for any response from Lexmark.	Service	COD 881
211365	Customer overdue entries do not tally with aging summary on the Customer Statement report.	Finance	REP 116 REP 1316
209241	The Item Availability by Timeline page shows blanket order data when you disable the Include Blanket Sales Orders option.	Inventory	PAG 5540
209771	"There are new postings made in the period you want to revalue item no. XXX. You must calculate the inventory value again. –OK" error message when you post a revaluation journal.	Inventory	COD 23
210337	The starting and ending dates of the next counting period is incorrect when you run the Calculate Counting Period report from a stockkeeping unit card.	Inventory	REP 5706 TAB 5700
208687	A multi-lined production order loses its reservation when it is rescheduled on the Planning Worksheet page.	Manufacturing	COD 99000815
210722	Lot accumulation period is not considered when there are different supplies with due dates within the same accumulation period.	Manufacturing	COD 99000854
211782	Show document from an interaction log entry leads to the Save dialog ends with an error message if it is closed.	Marketing	COD 5054
210595	A zero discount for an item variant on a purchase line is not respected.	Purchase	COD 7000 COD 7010
210400	"Amount must be positive in Gen. Journal Line Journal Template Name='',Journal Batch Name='',Line No.='0'." error message when you post a sales or purchase order with prepayment and prices include VAT.	Sales	COD 80 COD 90
211108	G/L inconsistency error when you post preview of a sales order with items having the Assembly Policy value set to Assemble-to-Order.	Sales	COD 900
211718	"The following C/AL functions are limited during write transactions because one or more tables will be locked ..." error message when you validate the Blanket Order No. value on the Sales Order page.	Sales	TAB 37
208674	"Quantity available to pick is not enough to fill all the lines" error message when you click the Autofill Qty. to Handle button on a pick worksheet.	Warehouse	TAB 7326
209238	"Quantity (Base) must not be less than Quantity Handled (Base) in Whse. Item Tracking Line Entry No.=X" error message when you create a warehouse put-away from the Posted. Whse. Receipt page.	Warehouse	COD 6500
210002	The Vendor Shipment No. value on the Warehouse Receipt pager overwrites an existing customer reference in the External Document No. field on the Sales Return Order header.	Warehouse	COD 5760
210339	A pick line of 0 quantity is created even if the quantity is available when the item being picked is for both a sales order and an assembly component.	Warehouse	COD 7312
211208	"The Bin Content does not exist. Identification fields and values: Location Code='WHITE',Bin Code='A-11-0001',Item No.='LS-150',Variant Code='',Unit of Measure Code='PCS'" error message when you run the Create Pick function.	Warehouse	COD 7312
208108	When cross-docking is set up without a mandatory bin for a location, an incorrect put-away is created.	Warehouse	COD 7313
208670	Some reports print with the Letter format when they should use the A4 format in the Czech localization.	Sales	REP 114 REP 205
208989	The OnAfterCheckGenJnlLine event on the Gen. Jnl.-Check line codeunit can be skipped unintentionally if the OverrideDimErr variable is set.	Finance	COD 11
209065	Notification on a sales quote should be shown on a created sales order instead.	Sales	COD 83 COD 86 PAG 343 PAG 42 TAB 36
209195	When you create a new customer or vendor by using the Apply Template function, dimensions do not copy to the master record.	Sales	TAB 1300 TAB 1301 TAB 1303
209410	If you try to post a lump payment, and some documents use a different currency than the balancing account used for the payment registration, an message displays and the amounts from the other documents is added to the amount received.	Cash Management	COD 980
209796	The "Do you want to suppress send dialog?" message displays for each reminder if you choose to print multiple reminders.	Finance	TAB 297
210139	Cannot import pictures for fixed assets.	Fixed Assets	PAG 5600
210300	The description from a variant code is not validated in the Description field on the Job Planning Line page.	Jobs	TAB 1003
210354	The value in the Balance Due (LCY) field is incorrect on the Customer or Vendor list pages.	Finance	TAB 18 TAB 23
210414	The quick filter on the Customer, Vendor, Item, Resource, and Fixed Asset list pages contains the image to filter.	Administration	NA
210424	Items added to a customer price group after the initial integration do not sync to CRM.	Administration	COD 5150 COD 5334 COD 5341 COD 5345 TAB 5331
210519	If you update the DynamicsNAVIntegrationSolution.zip after it's installed, or if you delete the solution in CRM and try to reinstall it, an error message displays.	Administration	N/A
210520	Export or update Excel sheet from account schedules does not update values when they are 0.	Finance	REP 29
210644	The Item Category Code and Product Group Code fields can both be blank in the Product Group table.	Inventory	TAB 5723
210661	Fixed Asset Acquisition Wizard - Action Exit - CaptionML is missing.	Fixed Assets	PAG 5551
210694	If you export documents with the PEPPOL 2.1 format, warnings display when you validate the documents.	Sales	XML 1600
210711	Cannot reprint posted sales shipments.	Sales	PAG 130 PAG 142
210727	If you post a payment from a cash receipt journal by using an external document number, the Payment Amount in Customer - Payment Receipt report displays an incorrect negative sign.	Sales	REP 211
210738	The Copy Document action is duplicated on the ribbon on the Purchase Invoice page.	Purchase	PAG 51
210740	The page item variants, substitutions, and identifiers actions are not displayed on the Items list page.	Inventory	PAG 31
210793	"The Value Entry already exists. Identification fields and values: Entry No.='397'" message displays when the Post Inventory Cost to G/L batch job processes the value if the Gen. Posting setup has been deleted.	Inventory	COD 5802 REP 1002
210802	Create pick does not consider all components when you delete a semi-finished good on production order line, which turns the item into a pickable component.	Manufacturing	REP 99001026 TAB 5406
210983	If you work with different related number series for credit memos in a certain setup, an error displays when you create a corrective credit memo.	Sales	COD 1303 COD 1313 COD 396 TAB 36 TAB 38
211014	An item charge value is not created when posting if the purchase invoice line is created using the Get Receipt Lines function.	Purchase	COD 90
211042	Product to Item table CRM mapping integration issues.	Administration	NA
211205	The Create Account in Dynamics CRM function duplicates records in CRM without confirming that the records are already coupled.	Marketing	PAG 22
211312	The payment tolerance is posted to the payment tolerance account although you use the Transferred as Difference to Account function to manually post it to a different account.	Cash Management	COD 1255
211357	The calculate counting period in physical inventory journals does not show items that have a past due counting period, or when the work date is after the end date of the counting period.	Inventory	COD 7380
211523	The "Expiration Date is before the posting date. in Item Ledger Entry Entry No.=X" message displays when you return a purchase order.	Purchase	COD 22
211527	Logic improvement request.	Warehouse	COD 7313
211574	"The field Product Group Code of table Item contains a value (X) that cannot be found in the related table (Product Group)" message displays when you run a validate package.	Upgrade	TAB 111 TAB 113 TAB 115 TAB 121 TAB 123 TAB 125 TAB 246 TAB 27 TAB 32 TAB 37 TAB 39 TAB 5108 TAB 5110 TAB 5741 TAB 5745 TAB 5747 TAB 5902 TAB 5991 TAB 5993 TAB 5995 TAB 6651 TAB 6661 TAB 753 TAB 83
211578	The Dimension action is duplicated on the Sales Credit Memo page.	Sales	PAG 44
211592	The "Quantity (Base) must not be less than Quantity Handled (Base) in Whse. Item Tracking Line Entry No.='X' " message displays when you create a put-away.	Warehouse	COD 5760 REP 7305
211666	The Update Layout function causes blocks when printing larger reports.	Administration	TAB 9650
211711	Item attributes are deleted after you rename items.	Inventory	TAB 27 TAB 7505
211720	Warehouse reclassification journals cause a negative value in the Available Qty. to Take field on the Bin Contents page.	Warehouse	TAB 7302
211732	The Job Queue Status field is not displayed on several pages.	Administration	PAG 42 PAG 43 PAG 44 PAG 50 PAG 51 PAG 52 PAG 6630 PAG 6640
211780	In the My Customers or My Vendors view in the Role Center, the balance is calculated based on the Amount value instead of the Amount (LCY).	Finance	TAB 9150 TAB 9151
211792	The Unit Price field is negative if a resource ledger entry is created from a sales credit memo.	Sales	TAB 207
212219	The Posting Details group does not display on the Invoicing FastTab of the Customer card.	Finance	PAG 21
212367	If you enter a G/L account in the Freight G/L Account no. field of the Sales & Receivable setup table, the system does not validate that the account is set up correctly.	Finance	TAB 311
208632	The Physical Counting Period functionality does not work in Dynamics 365 for Financials.	Inventory	NA
210296	When you use the DEU language, an error message displays when creating cash flow worksheet lines.	Finance	TAB 843
210418	The "An attempt was made to change an old version of a Sales Line record. The record should first be reread from the database. This is a programming error" message displays when you post a sales order shipment and the item is reserved and Calc. Inv. Discount is enabled.	Sales	COD 86 PAG 498 TAB 1003 TAB 37
211733	Broken string menu when you send multi-selected posted sales invoices in the German language with a different sending profile.	Sales	TAB 60

Local application hotfixes

AT - Austria

ID	Title	Functional area	Changed objects
210498	"Attempted to divide by zero" error message when you create an Intrastat file in the Austrian version.	VAT/Sales Tax/Intrastat	REP 11106

BE - Belgium

ID	Title	Functional area	Changed objects
212833	For all G/L Journal lines created from an EB payment journal, the Bal. Account No. field is populated although the extra balancing line is created. The Bal. Account No. fileld should be blank in the Belgian localization.	Cash Management	REP 2000004
210890	The Payment Discount Possible field on the Customer Ledger Entries page is incorrectly calculated if you post a sales invoice with 100%  prepayment and a payment discount in the Belgian localization.	Sales	COD 442 COD 444
208584	The Total VAT field on the Purchase Order should be zero when the VAT calculation is the Reverse Charge VAT in the Belgian version.	Purchase	COD 57
211167	For all G/L Journal lines created from an EB Payment Journal, the Bal. Account No. value is populated although the extra balancing line is created. The Bal. Account No. field should be blank in the Belgian version.	Cash Management	REP 2000004

CZ- Czech

ID	Title	Functional area	Changed objects
210297	Some reports print with the Letter format when they should use the A4 format in the Czech localization.	Sales	REP 11740 REP 11742 REP 31045 REP 31074
212232	The Amount Exempted from VAT field on the EET Entry Card should contain the sales invoice amount when the calculation is made with reverse charge VAT, even if the VAT Rate field on the VAT Posting Setup page is set to Base in the Czech version.	Finance	COD 31121
212236	The VAT Base and VAT Amount fields on the EET Entry Card page should be filled in if you post a credit memo using postponed VAT in the Czech version.	Finance	COD 31121
212241	The User Checks Allowed functionality does not work in Role Centers menus in the Czech version.	Cash Management	COD 1020 COD 11795 COD 230 COD 240 COD 270 COD 330 COD 340 COD 350 COD 5638 COD 5646 COD 5656 TAB 7311 TAB 7326
212260	If you create a new purchase advance letter and fill in the VAT date, the original datum VAT date is inserted although the default Orig. Doc. VAT Date value is blank in the Czech version.	Purchase	COD 12 COD 370 COD 408 COD 5703 PAG 11716 PAG 1290 REP 11786 REP 11787 REP 595 REP 83 TAB 112 TAB 11740 TAB 11741 TAB 1293 TAB 1294 TAB 274 TAB 31020 TAB 352 TAB 36 TAB 37 TAB 38 TAB 39 TAB 5718 TAB 83

DE - Germany

ID	Title	Functional area	Changed objects
209526	Missing translation in vendor document layouts in the German version.	Purchase	PAG 9658

ES - Spain

ID	Title	Functional area	Changed objects
210691	The Previous Declared Amount field is not correctly calculated if there is a corrective invoice included in the previous period on the VAT Declaration page in the Spanish version.	VAT/Sales Tax/Intrastat	PAG 10736 TAB 254
211076	Total weight cannot be zero in Intrastat journals in the Spanish version.	VAT/Sales Tax/Intrastat	TAB 263

IT - Italy

ID	Title	Functional area	Changed objects
209275	Inbound posting to bin is allowed from another location when you set up bin content with the Block Movement value set to All, and posting is done on the Item Reclass. Journal page in the Italian version.	Warehouse	COD 21
211151	Cannot post an EU purchase invoice from the payment journal in the Italian version.	Finance	COD 13

NA - North America

ID	Title	Functional area	Changed objects
212441	"The transaction cannot be completed because it will cause inconsistencies in the G/L table. Check where and how the CONSISTANT function...." error message if purchase orders have Canada tax, dimensions, and negative lines in the North American version.	VAT/Sales Tax/Intrastat	COD 80 COD 90

NL - Netherlands

ID	Title	Functional area	Changed objects
210504	The Payment in Process field is incorrect for all the lines processed except the first one if you post a payment from the Telebank - Bank Overview page applying more than one entry in the Dutch version.	Cash Management	COD 11000001
210589	If the second decimal place of the invoice total amount is equal to 0, the amount is truncated in the SEPA DD xml file in the Dutch version.	Cash Management	COD 11400 REP 11000012 REP 11000013
210836	The VATIdentificationNumberNLFiscalEntityDivision value in ICP Declaration is filled unexpectedly when the Fiscal Entity No. value is filled, even if the Part of Fiscal Entity value is set to FALSE in the Dutch version.	Finance	REP 11404
211178	The NL audit file creation fails when the vendor account is set up with 20 characters in the Dutch version.	Finance	REP 11412
209394	Standard customer sales code is not considered if the sales order is created directly from the Customer card or list pages in the Dutch version.	Sales	PAG 42
211206	Standard customer sales code is not considered if the sales quote, sales invoice, or sales credit memo are created directly from the Customer card or list pages in the Dutch version.	Sales	COD 11400 PAG 42
211360	The filters for the Intrastat Journal are not used in the Intrastat Declaration Disk function in the Dutch version.	VAT/Sales Tax/Intrastat	PAG 311 REP 11413

NO - Norway

ID	Title	Functional area	Changed objects
211603	"Posting Date is in a settled and closed VAT period (xxxx period 6) in Gen. Journal Line Journal Template Name='XXXX',Journal Batch Name='XXXX',Line No.='XXXX'." Error message when you try to post a journal for end-of-year-closing entries in the Norwegian version.	Finance	COD 11

Local regulatory features

IT - Italy

ID	Title	Functional area	Changed objects
211092	2017 Updates for Declaration of Intent for Microsoft Dynamics NAV 2017 - Italy	Financial Management	REP12194, COD12134, TAB12186, PAG12100, PAG12161