Cumulative Update 20 for Microsoft Dynamics NAV 2017 (Build 23021)

This article applies to Microsoft Dynamics NAV 2017 for all countries and all language locales.

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.

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
218167	Incorrect link in the New-NAVCRMTable cmdlet help for the ConnectionString parameter.
265561	If you use the lookup function for the Source No. Filter field on the Purchase Analysis Matrix page, the table relation does not match the Source Type Filter field.
268826	The ShowAsTree property does not show the toggle control to expand or collapse record if it is bounded to an invisible control.
269019	The New action is missing when you look up into list pages with the Tablet client.
269038	Table relation validation check is wrongly applied when you create new records in a lookup table.
269157	Selected company specific customizations are lost when you use the Customize Navigation Pane function.
269162	"Unable to get property 'set_visible' of undefined or null reference" error message when you add a column.
269369	A multiline control in View mode will only show 3 lines of contents in the Web client, which requires the user to scroll to see more lines.
269703	Automatic deployment of .NET Add-ins does not work if there are different versions of the same DLL.
269936	The new session cannot support GUIDALLOWED when you open and refresh a Dynamics NAV Excel Add-in spreadsheet that opens a Windows client session in Dynamics NAV.
270192	Companies list is not displayed in any specific user-friendly sort order.
271059	Importing a Microsoft Dynamics 365 for Sales solution fails with an incorrect assembly version.
271495	Preview of a custom RDLC report layout is very slow.
272082	Bad refresh behavior in the Web client when you enter more than 15 lines.
273045	Keyboard shortcuts F3 and Ctrl+F3 do not work when you use the Dynamics NAV Windows client in Windows 10.
273096	The client crashes if a record link has a blank URL.
273239	The client crashes when you delete an empty line.

 

Application hotfixes

ID	Title	Functional area	Changed objects
266150	The auto-approvals should go through an "Approval request that is an approved event with Pending Approvals: > 0 On condition" event and the respective responses.	Administration	COD 1501 COD 1535
267774	Price list synchronization does not work correctly.	Administration	COD 5342
269670	Task scheduler processes too slow when there are nonrecurring job queue entries with the same job queue category code, and the process gets stuck.	Administration	COD 448 COD 449
269711	The workflow notifications always take the Notification Method setup on the Notification Setup page from the requestor but not from the approver.	Administration	COD 1509 TAB 1512
271726	USERID on the Job Queue Entries page is changed every time a user logs in.	Administration	COD 455
273094	Error when you rename a user with a customer license with data in the Workflow Step Instance Archive table.	Administration	TAB 1530
273824	Job queue entries are never set as the In Process status during execution.	Administration	COD 448
274204	Synchronizing an option field with the classic Outlook Add-in results in an error.	Administration	COD 5302
267495	The Payment Tolerance warning displays incorrect amounts.	Cash Management	COD 426 PAG 591
267894	Duplicate vendor remittances are being emailed when more than one payment line exists for a vendor.	Cash Management	COD 8800
273654	An incorrect date format is used in the Bank Acc. - Detail Trial Bal report.	Cash Management	REP 1404
261014	The report selected on the General Journal Template page is not printed when you use the Post & Print function on the Recurring G/L Journals page.	Finance	COD 13
261330	The Test Report function does not show a warning or error, but there is an error on posting.	Finance	COD 13 REP 2 TAB 81
266335	Currency precedence on the Payment Journal page should be in line with any change done balance account number on the General Journal page.	Finance	TAB 81 COD 10635
269236	Clearing the account schedules in the General Ledger setup and then running the reports generates duplicate account schedules and column layouts.	Finance	COD 570
269238	If the default column layout is changed on the Balance Sheet Account Schedule page, it is not printed from the Balance Sheet request page.	Finance	REP 25
269302	The Your Reference field is 30 characters long instead of 35 on the reminder headers.	Finance	REP 122 TAB 295 REP 28071 REP 28072 REP 28073 REP 28074 TAB 28071 TAB 28073 TAB 28075 TAB 28077 REP 5005272 REP 5005273 TAB 5005270 TAB 5005272
269736	The Payment Discount Tolerance warning is displayed where it should not be displayed when you enter the Applies-to Doc. No. field directly instead of using the Lookup function.	Finance	TAB 81
270722	Dimension values are changed after you type over shortcut dimension and tab off the Quantity field of the next line.	Finance	PAG 171 PAG 176 PAG 46 PAG 47 PAG 508 PAG 510 PAG 54 PAG 55 PAG 752 PAG 755 PAG 95 PAG 96 PAG 97 PAG 98
271024	When a Bal. Account No. field is specified in a Gen. Journal batch for a recurring G/L journal, lines can be created but cannot be posted.	Finance	TAB 232
271769	The HideValidationDialog variable is missing in the GetCustomerBalAccount function.	Finance	TAB 81
271840	Poor performance when you print the Reminders report with the company logo enabled from the setup.	Finance	REP 117
272779	Missing VAT entries after you un-apply for normal and reverse charge VAT when you use the Adjust for Paym. Discount function.	Finance	COD 12
272784	The Cash Flow Manual Expenses column header is used two times on the Cash Flow Availability Lines page.	Finance	PAG 866
273507	It is possible to post a prepayment invoice even if the Invoice Discount % field plus the Prepayment % field is bigger than 100.	Finance	COD 80 COD 90
273540	If you delete a payment on the Payment Journal page after you exported the payment, the deleted payment is not suggested if you use the Suggest Vender Payment report.	Finance	PAG 25 PAG 29
273881	"The bank account number was not found in the data to be imported" error message if you use the Import Bank Transactions function on the Payment Reconciliation page for SEPA CAMT 053-04 files.	Finance	COD 1260 COD 1261 COD 1262 COD 1263
270175	Captions are missing on the Fixed Assets Statistics page.	Fixed Assets	PAG 5602 PAG 5603
271022	Assembly order can be created when an item is blocked.	Inventory	TAB 900
271035	Assembly order is not reserved when you copy a document with a sales line for a given assembly-to-order type item and an assembly order is created.	Inventory	COD 6620
271095	"Attempted to divide by zero" error message when the Suggest Item Charge Assignment function is selected with the Equal option that has the Qty. to Invoice field as 0 on a Purchase Order Item Charge line.	Inventory	COD 5805 PAG 5805 TAB 5805
272295	The cost adjustment process does not respect the Inventory Value Zero field when setup on an assembly output item.	Inventory	COD 5895
268602	Missing validations with time sheets and job integration: a time sheet can be created, submitted and approved, but the job journal line can be edited for Job No., Time, and Work Type fields even after going through approval. These changes should be prevented.	Jobs	TAB 951
268941	Cost Shares page does not recognize sub-production BOMs that display incorrect quantity per parent.	Manufacturing	COD 5870
269262	"Applies-to Entry must have a value in Item Journal Line: Journal Template Name" error message when you post a line with a negative quantity for a lot-tracked item in an output journal, because the serial-tracked item allows posting.	Manufacturing	COD 22 PAG 99000823
269798	The planning worksheet line components show an incorrect due date/time.	Manufacturing	TAB 99000829
269838	The Runtime field in capacity ledger entry is not updated correctly if there is a unit of measure conversion of output quantity.	Manufacturing	COD 22
271292	The Planning action does not suggest to cancel an existing supply which makes the projected inventory to exceed the overflow level.	Manufacturing	COD 99000854
271071	The Create Oportunity action on the Contact List page is incorrect. It should be Create Opportunity.	Marketing	PAG 5052
268443	Carry out does not create all purchase lines when action lines have different purchasing codes for drop shipments.	Purchase	TAB 246
268735	Difference of 0.01 in G/L accounts that are posted from a purchase invoice.	Purchase	TAB 49
271548	The Purchase – Invoice report shows a variable text instead of an amount.	Purchase	REP 406
263931	Make the Cash customer functionality easy to use.	Sales	PAG 459 PAG 460 TAB 311 TAB 312 TAB 36 TAB 38
268859	The Item Overview page is not usable anymore if you create a sales quote from a contact.	Sales	TAB 5050
269464	When you run the Move Negative Lines function on the Sales Return Order page, the line discount is not copied.	Sales	COD 6620
269556	"Source Type must have a value in Reservation Entry: Entry No.=0, Positive=No. It cannot be zero or empty" error message when you try to reserve an assembly component from a purchase line.	Sales	PAG 501
269656	Bin code is not properly set in the Assembly Header table when you have the assembly-to-order option set and an assembly order is created through the Copy Document function from the Sales Order page.	Sales	COD 6620
269794	A change in the statistics for a prepayment sales order can destroy the audit trail for the whole process.	Sales	TAB 37 TAB 39
270951	The Overdue Amounts (LCY) field on the Check Credit Limit page is calculated differently than the Overdue Amounts (LCY) field in the Customer Statistics FactBox.	Sales	PAG 1871
271255	When a customer is deleted, related customized calendar entries are not deleted.	Sales	COD 7600 TAB 14 TAB 18 TAB 23 TAB 291 TAB 7603
271736	The record restriction is missing in the Sales Order Credit Limit approval workflow.	Sales	COD 1502
273174	Error in the Sales Return Order transaction that is created through an IC.	Sales	TAB 111 TAB 121
266760	The system produces an imbalance between Item Ledger Entry and Warehouse Entry tables in a scenario with service orders and warehouse shipments.	Warehouse	COD 5980
269846	"The Bin Content does not exist" error message when you register a pick and the quantity in the pick is not available in the bin.	Warehouse	COD 7307
270423	"Quantity available to pick is not enough to fill in all the lines" error message when you run the Autofill Qty. to Handle function on the Pick Worksheet page.	Warehouse	COD 7314 REP 5754 TAB 7326

 

Local application hotfixes

APAC

 

ID	Title	Functional area	Changed objects
270859	Error message when you post the GST settlement after BAS consolidation in the APAC version.	VAT/Sales Tax/Intrastat	REP 11603

 

BE - Belgium

ID	Title	Functional area	Changed objects
269927	If you set up non-deductible VAT for an account and you post an invoice with deferrals, the amounts posted are incorrect in the Belgian version.	Finance	TAB 39

 

CH - Switzerland

ID	Title	Functional area	Changed objects
271140	The information of which invoice was paid is missing when you use the Export Payment to File function with some vendor bank payment types in the Swiss version.	Cash Management	XML 1000
273610	A vendor payment file of Payment Type = 6 cannot be validated successfully if the Country/Region code in the vendor bank account is not filled in the Swiss version.	Cash Management	COD 1223 TAB 288 XML 1000
273163	Mistakenly, the From and To dates in the Swiss VAT Statement report are changed depending on the date range for the VAT reporting period in the Swiss version.	Finance	REP 26100

 

CZ- Czech

ID	Title	Functional area	Changed objects
269654	Incorrect application of payment to multiple advance letters on the Payment Reconciliation Journal page that use variable symbol in the Czech version.	Cash Management	TAB 1249 TAB 31035
271169	If the Bank Account No. and IBAN fields are set up on the Vendor Bank Account Card page and the Payment Reconciliation Journal Line page that are filled with only the Bank Account No. field, the system does not find the related party in the Czech version.	Cash Management	COD 1255
271185	The EET - Register No. field is sent to the service from the EET cash register instead of code.	Cash Management	TAB 31123
271193	The EET entry card does not show the seconds in the Creation Datetime field in the Czech version.	Cash Management	PAG 31123 PAG 31124 TAB 31123
273179	IBAN and SWIFT are not transferred from the Issued Bank Statement Line page to the Payment Reconciliation Journal Line page in the Czech version.	Cash Management	PAG 1290 REP 11701 TAB 1251 TAB 274
273156	The Doc. Amount to Link Letter field does not contain VAT on the Sales Adv. Letter Link. Card page in the Czech version.	Finance	COD 60 COD 70
273160	No validation is present in the user setup lines during the User Checks action in the Czech version.	Finance	TAB 11796
273069	Doc. Line description is deleted for the sales advance letters when you use the Unlink Current Line action in the Czech version.	Sales	COD 31030
273103	If item charge has an assignment during receive or shipment, then shipped orders cannot be invoiced in the Czech version.	Sales	COD 80
273208	The VAT Entry Document No. field is incorrect when the sales credit memo is automatically created in the Czech version.	Sales	PAG 123 PAG 315 REP 11775
271135	If you make a VAT correction in the statistics in the local currency, the VAT amount is different after posting in the Czech version.	VAT/Sales Tax/Intrastat	COD 90 TAB 39 TAB 49

 

DACH

ID	Title	Functional area	Changed objects
271889	"The operation cannot complete because it uses a feature that is not supported (.NET Framework Interoperability)" error message if you use the drill-down functionality in the XSL-Filename field on the Sales Vat Adv. Notif Card page in the DACH version.	Finance	PAG 11016
271910	Item attributes are not copied when you use the Copy Item function in the DACH version.	Inventory	REP 11511

 

ES - Spain

ID	Title	Functional area	Changed objects
270953	"The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table" error message if you try to settle a posted bill group with currencies in the Spanish version.	Finance	COD 7000006 REP 7000098
271645	The Document Status field should change from Rejected to Honored if you pay completely a rejected invoice that is included in a bill group through a journal in the Spanish version.	Finance	COD 7000006 REP 7000097
270837	The Make 349 Declaration Disk report includes lines with zero amount for customers and vendors if you include partial corrections for other customers or vendors in the Spanish version.	VAT/Sales Tax/Intrastat	REP 10710
270952	Foreign operations with the No Tax VAT field should be excluded from the Make 349 Declaration report in the Spanish version.	VAT/Sales Tax/Intrastat	REP 10710 TAB 113 TAB 123 TAB 9
272854	"Código[4102].El ML no cumple el esquema. Falta informar campo obligatorio: Pago" error message if you try to post a VAT cash payment for a VAT cash invoice that involves cartera and bills in the Spanish version.	VAT/Sales Tax/Intrastat	COD 10750

 

FR - France

ID	Title	Functional area	Changed objects
270440	The amount text appears incorrect in the Check report when you use the application language English in the French version.	Cash Management	REP 1401
271358	The number of invoices is missing in the report for the payment deadlines in the French version.	Finance	REP 10887

 

IT - Italy

ID	Title	Functional area	Changed objects
270696	Error message when you use the Related Entry No. field on the Purchase Invoice page in the Italian version.	Purchase	TAB 254
271855	The and tags are not reported in the PA invoice XML file in the Italian version.	Sales	COD 12179
273566	The discount or the increase amount reported in the PA invoice should be always reported as unit amount in the Italian version.	Sales	COD 12179
270796	If you get service invoices entries in an Intrastat journal, the intrastat entry does not report the Customer VAT Registration No. field in the Italian version.	VAT/Sales Tax/Intrastat	REP 594
270902	The tag of the Periodic VAT Settlement Communication field is wrongly reported in the Italian version.	VAT/Sales Tax/Intrastat	COD 12150 COD 12151
270907	If the VAT Settlement Period field is set to Quarter, the Periodic VAT Communication field must report the tag and the number of the quarter in the Italian version.	VAT/Sales Tax/Intrastat	COD 12150 COD 12151
273312	The tag should report the value 0 or value 1 in the Italian version.	VAT/Sales Tax/Intrastat	COD 12150
273491	Incorrect labels and translation of the Periodic VAT Settlement Request page fields In the Italian version.	VAT/Sales Tax/Intrastat	REP 12150

 

NA - North America

ID	Title	Functional area	Changed objects
271092	Bank account ledger entries still show applied after a bank reconciliation has been deleted in the North American version.	Cash Management	TAB 10121
273130	Consistent error when you try to post a purchase document that contains negative lines with the Expense/Capitalize field set to true in the North American version.	Finance	COD 398

 

NL - Netherlands

ID	Title	Functional area	Changed objects
270714	Global dimension is deleted from the Proposal Line table when you look up the dimensions for the proposal in the Dutch version.	Cash Management	PAG 11000001 TAB 11000000
271072	"The field No. of table CBG Statement Line contains a value (x) that cannot be found in the related table (CBG Statement)" error message when you create a new Bank/Giro journal in the Dutch version.	Finance	PAG 11400 PAG 11401 TAB 11400
273528	If the user specifies a common country code, such as GR for Greece, the ICP declaration cannot be processed successfully in the Dutch version.	Finance	REP 11404

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 20 for Microsoft Dynamics NAV 2017

Which hotfix package to download

This cumulative update has multiple hotfix packages. Select and download one of the following packages depending on the country version of your Microsoft Dynamics NAV 2017 database:

Country	Hotfix package
AT - Austria	Download the CU 20 NAV 2017 AT package
AU - Australia	Download the CU 20 NAV 2017 AU package
BE - Belgium	Download the CU 20 NAV 2017 BE package
CH - Switzerland	Download the CU 20 NAV 2017 CH package
CZ- Czech	Download the CU 20 NAV 2017 CZ package
DE - Germany	Download the CU 20 NAV 2017 DE package
DK - Denmark	Download the CU 20 NAV 2017 DK package
ES - Spain	Download the CU 20 NAV 2017 ES package
FI - Finland	Download the CU 20 NAV 2017 FI package
FR - France	Download the CU 20 NAV 2017 FR package
IS - Iceland	Download the CU 20 NAV 2017 IS package
IT - Italy	Download the CU 20 NAV 2017 IT package
NA - North America	Download the CU 20 NAV 2017 NA package
NL - Netherlands	Download the CU 20 NAV 2017 NL package
NO - Norway	Download the CU 20 NAV 2017 NO package
NZ - New Zealand	Download the CU 20 NAV 2017 NZ package
RU - Russia	Download the CU 20 NAV 2017 RU package
SE - Sweden	Download the CU 20 NAV 2017 SE package
UK - United Kingdom	Download the CU 20 NAV 2017 UK package
All other countries	Download the CU 20 NAV 2017 W1 package

 

How to install a Microsoft Dynamics NAV 2017 cumulative update

See How to install a Microsoft Dynamics NAV 2017 cumulative update.

Prerequisites

You must have Microsoft Dynamics NAV 2017 installed to apply this hotfix.

See more information about software update terminology and Microsoft Dynamics NAV 2017.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.