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

Applies to: Dynamics NAV 2017

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

Overview


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

Resolution


How to obtain the Microsoft Dynamics NAV update files

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

Download 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.

More Information


Status


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