Cumulative Update 12 for Microsoft Dynamics NAV 2017 (Build 18976)

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.

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
223242 The Saved Settings FastTab should not be shown when the SavedValues value is set as No or False.
223910 The progress indicator does not close and the page is not updated.
225363 Virtual database tables are not supported in Azure.
225592 Inserting lines causes the client to crash with AutoKeyException.
225601 Menu items are lost when you add them to a user with specific permissions.
225603 Changing the database collation can show the database as operational even when collation change has failed.
227094 CaptionClass makes a page be drawn twice.
227096 Problems with saved views when filters are defined for filter group 2.
227114 The Customize This Page option does not show all fields that are currently shown on the Sales Order page.
227782 Extension permissions are not shown correctly in the User Group Permission Sets list.
227868 No rollback when an XMLport is called with a return value.
228032 Events are not fired when you save a codeunit.
228849 The web client crashes when you cancel an approval request.
228852 The Windows client replaces backslashes with forward slashes when you import a control add-in which includes JavaScript in a manifest.xml.
228854 The web client shows UTC time and but not the server or instance time zone time.
229290 CRM integration with OAuth (AD + Claim Based authentication) fails in connection string parsing and cannot connect to the CRM instance.
229689 Add a missing index to the Active Session table.
229778 How to open a non-modal Word document and retrieve when closed runtime.
229805 The Request page that saves a GUID variable crashes the client.
229827 Modify a record in the User table causes an error when you use a job queue.
231031 Excel Add-In Manifest deployment is broken since September CU for Localized versions.
231032 JS Control Add-In disappears in the client when you select the Show More Fields button.

Application hotfixes

ID Title Functional area Changed objects
228130 You can't create the transformation rule type of REPLACE. Administration PAG 1238 TAB 1237
228778 The notification entries table fills with incorrect entries after an error occurs. Administration COD 1509
229591 Can't set filters when you try to export permission groups. Administration TAB 9000
229947 Indirect table permissions do not work as expected. Administration TAB 273 TAB 270
230831 If you use temporary variables with events, the temporary changes are written to the database. Administration COD 9150
231155 The supplied field number 1 cannot be found in the Manufacturer table. Administration COD 8611
227089 General journal workflows cause restrictions in bank reconciliations. Cash Management COD 367
225921 Default cash flow statement calculates numbers incorrectly by using the M-CASHFLOW account schedule. Finance COD 571
226063 Comparison Period Formula is not converted to any language. Finance TAB 334 TAB 7118
226697 When you drill down into the Source No. value for a customer ledger entry on the Cash Flow Entries page, the customer list opens instead of the list of the customer ledger entries. Finance TAB 847
227854 Default Dimensions are not copied in a sales order created from IC transactions. Finance COD 427
227897 "You cannot correct this posted purchase invoice because the purchase invoice line ..." error message if you try to correct a posted purchase invoice with a G/L account in it. Finance PAG 132 PAG 138 PAG 143 PAG 146
229786 Mistakenly G/L entries are created when unapplying EU customer or vendor entries when you use the Adjust for Payment Discount feature. Finance COD 12
230566 IC Partner OnDelete refers to the Customer No. field instead of the Vendor No. field. Finance TAB 413
231119 Payment tolerance warning message is not displayed when you apply a payment in LCY to an invoice in FCY. Finance COD 226 COD 227 COD 426
228141 The Base Unit of Measure field is blank on lookup from a sales order line. Inventory TAB 37 TAB 39
228474 The translation record of an item attribute value is not deleted when an item attribute is deleted. Inventory TAB 7500
229088 Item attribute value is not deleted when it was set in a parent item category and any item is using any given child category for this parent. Inventory COD 7500
229810 Variable is not named following best practices. Inventory COD 7500
229798 Invoicing value entry for a job related item ledger entry is assigned to an incorrect parent item ledger entry. Jobs COD 90 COD 22
230235 "The Job Planning Line No. field must have a value when reservation entries exist. Journal Template Name=TemplateName, Job Journal Batch Name=BatchName, Line No.=LineNumber. It cannot be zero or empty" error message when post a job journal and reservation entry exists for the job. Jobs COD 1012
230130 Item ledger entry record is posted when you post an output journal line for an operation which is not the last operation which has the Routing Status field validated to Finished. Manufacturing COD 7324 COD 99000772 TAB 83
230255 The Planning Worksheet function does not create a production order with the bin specified on the Work Center page. Manufacturing COD 99000773 COD 99000854
230873 Error message "The value of ROUND parameter 2 is outside of the permitted range. The current value is: 0. The permitted range is: from 1 to 2.147.483.647" shows when you run the Calc. Regenerative Planning function on the Planning Worksheet page. Manufacturing COD 5431 REP 99001017
228840 The GetFirstBusUnit function has a return value of Code 10 on the G/L Budget Entries page. In this function, the return value is filled with table 120 Business Unit field 1 Code (Code 20). Marketing PAG 120
220733 On the Vendor List page, there is a link to the Payment Journal page but not to the Purchase Journal page instead. Purchase PAG 26 PAG 27
228519 The Vendor No. and Vendor Item No. columns are not validated from the Stockkeeping Unit Card page when you manually enter a line on the Requisition Worksheet page. Purchase TAB 246
228770 The Vendor Invoice No. field has a length of 20 with an incoming document while the Vendor Invoice No. and External Document No. fields have a length of 35 on the Purchase Header and Item Journal Line pages. Purchase TAB 130
230232 "The date formula '+WD5' should include a time unit" error message when you approve a purchase invoice. Purchase TAB 1513
225990 "No approval requests exists" error message when you try to send the approval request for a sales order. Sales COD 1535
226028 A Service Charge G/L sales line is created on first sales line but not at the end of the document when the sales order is released. Sales COD 56 COD 57 COD 60 COD 66 COD 70
226743 "Deleting this document will cause a gap in the number series for posted invoices. An empty posted invoice" message is not displayed when you delete a sales invoice. Sales TAB 36 TAB 38
227359 Error message "COGS Account must have a value in General Posting Setup: Gen. Bus. Posting Group=DOMESTIC, Gen. Prod. Posting Group=MANUFACT. It cannot be zero or empty." shows when you post an undo shipment for an item which is set to inventory value zero. Sales COD 22
228763 If you send the Customer Statement report by using the SMTP email function, customer statements is deleted without any email bodies are sent. Sales COD 8800 COD 9651
229699 Performance issue with sales invoices when you select a customer after checking that the customer is not registered. Sales TAB 23
229829 "Qty. to Assemble to Order must be equal to X in Sales Line: Document Type=Order, Document No.=Y, Line No.=Z. Current value is '0'" error message when you post sales order with the Assemble-to-Order Link option. Sales TAB 36
230194 The assembly order is not created while the Qty. to Assemble to Order field is validated when you explode BOM in a sales order line. Sales COD 63
230824 Drop shipment data from the Purchase Order No. and Purchase Order Line No. columns in the Sales Order Line table are removed when you invoice sales order through a sales invoice document. Sales COD 80 TAB 37
230828 Error message "Amount must be positive in Gen. Journal Line Journal Template Name..." shows when you post a sales order with prepayments and sales tax. Sales COD 60 COD 70
231338 Dimensions on the sales line are lost in case of using item substitution. Sales COD 5701
227995 Inventory setup options are changed when you cancel a RapidStart run. Upgrade COD 22 COD 8611
228953 "Quantity available to pick is not enough to fill in all the lines." error message when you autofill pick worksheet and the available units in stock are reserved for the sales order. Warehouse TAB 7326
229183 An error is displayed when you use the Split Line feature on a warehouse pick and using lot numbers with more than 15 lot numbers take and place lines. Warehouse PAG 5771 PAG 5780 PAG 7316 PAG 7376 PAG 7378 PAG 7383 TAB 5767
230837 Create Put-Away creates an empty record in the Bin Content table which is no longer removed later in the process if you set the bin code to blank. Warehouse COD 5760 COD 7307 COD 7313 REP 7305 TAB 5767
231619 You can't validate imported data for the From Bin Code and From Zone Code fields from the Warehouse Journal Line table by using the Rapid Start function. Warehouse TAB 7311

Local application hotfixes

CH - Switzerland
ID Title Functional area Changed objects
229531 "The Document Type must be Invoice" error message if you post a payment journal with the Reference No. field filled in the Swiss version. Cash Management COD 3010541
CZ- Czech
ID Title Functional area Changed objects
230164 Some reports have the Custom paper size instead of A4 in the Czech version. Administration REP 11706 REP 11709 REP 11710 REP 11711 REP 11763 REP 11765 REP 11767 REP 11771 REP 11773 REP 11774 REP 11775 REP 11777 REP 11778 REP 11779 REP 11780 REP 11781 REP 11789 REP 11796 REP 31011 REP 31030 REP 31031 REP 31039 REP 31041 REP 31042 REP 31049 REP 31059 REP 31061 REP 31063 REP 31068 REP 31070 REP 31075 REP 31076 REP 31082 REP 31101
228761 You can post a cash document with the resulting minus amount in the Czech version. Cash Management COD 11731
228811 The Transfer Difference to Account function does not respect the currency code on journal lines on the Payment Reconciliation Journals page in the Czech version. Cash Management COD 1255 COD 370 TAB 1294 TAB 274
230339 Error message "There is no Bank Stmt Multiple Match Line within the filter... " shows if you use the Apply Automatically function on the Payment Reconciliation Journal page in the Czech version. Cash Management COD 1255
231741 When you delete a cash document, unlink payment to advance letter is not done in the Czech version. Cash Management TAB 11730 TAB 11735
228241 The Interest Amount field on the Reminder Lines page is calculated incorrectly if you use the Suggest Reminder Lines function for partially paid invoices in the Czech version. Finance TAB 296
228654 The dimension in the GL entries record differs from the G/L Entry dimension record in the Czech version. Finance TAB 31051
228666 Performance issues for the VAT Control report in the Czech version. Finance COD 31100
229346 The Compensation field on the Customer Ledger Entries page is not filled in correctly if you post credits in the Czech version. Finance COD 11 COD 12 COD 31052 TAB 81
231747 Error with the No. Series Mask Generator function if the mask does not contain year in the Czech version. Finance REP 11768
231704 The FA Posting Group field can be changed even though a FA ledger entry already exists in the Czech version. Fixed Assets TAB 5612
228669 Incorrect VAT date in the VAT entry on the Payment Discount page in the Czech version. Purchase COD 227
227898 Incorrect vendor VAT Reg. ID is displayed on the Advance Letter page in the Czech version. Sales REP 31000 REP 31001 REP 31002
228814 VAT amount cannot be negative for purchase order statistics in the Czech version. Sales TAB 39
228836 If the Allow Document Deletion Before field is not filled, then you can delete posted document in the Czech version. Sales COD 31000 COD 31020 COD 363 COD 364 PAG 42 PAG 43 PAG 44 PAG 50 PAG 51 PAG 52 PAG 6630 PAG 6640 REP 840
231708 All lines with currency %1 must have the same currency factor for credits in the Czech version. Sales COD 31053
229227 Convert uppercase letters to lowercase for the Export VAT Control report in the Czech version. VAT/Sales Tax/Intrastat XML 31100
229367 VAT statement is exported incorrectly when you export total fields in the Czech version. VAT/Sales Tax/Intrastat XML 11762
DACH
ID Title Functional area Changed objects
229890 "You cannot post and apply general journal line %1, %2, %3 because the corresponding balance contains VAT" error message does not appear mistakenly in a certain scenario in the DACH version. Finance COD 13
232472 The Order Confirmation report lines are overlapping with VAT lines section in the DACH version. Sales REP 205
DE - Germany
ID Title Functional area Changed objects
228431 The Place of Dispatcher field and the Place of Receiver field are not used anymore for company information in the German version. Finance PAG 1
ES - Spain
ID Title Functional area Changed objects
228996 The BaseImponible, CuotaSoportada and CuotaDeducible fields on SII xml fields are not calculated correctly on purchase credit memo with the Correction type set as blank in the Spanish version. Finance COD 10750
229400 If you set the EU Service field on the Vat Posting Setup page and export a sales invoice or a credit memo with the SII interface, lines with the No Sujeto type are in an incorrect section in the Spanish version. Finance COD 10750
229913 If you create sales or purchase credit memo and post lines with equivalence charge, the equivalence charge is calculated incorrectly if you have multiple lines in the document in the Spanish version. Finance COD 10750
230519 If you issue a sales credit memo with VAT exemption code for credit memos of type difference or empty, the Base Importable amount is positive in the Spanish version. Finance COD 10750 COD 10755
230524 Some fields in the initial upload of invoices are not filled correctly in the Spanish version. Finance COD 10750 COD 10755
230471 If you print the Sales Invoice Book report, the External Document Number field is always empty in the Spanish version. Sales REP 10704
FI - Finland
ID Title Functional area Changed objects
228855 Auto Acc. Group is not considered for purchase invoices in the Finish version. Finance COD 12 TAB 81
230919 It is possible to work around a blocked situation in the Finish version. Finance COD 12 TAB 81
FR - France
ID Title Functional area Changed objects
227779 SEPA vendor payment file cannot be validated successfully if the Summarize per vendor field is used and a certain number of invoices is applied in the French version. Cash Management XML 1000
IT - Italy
ID Title Functional area Changed objects
227457 If you run the Create file function on the Intrastat Journal page, the amount and statistical values must be rounded by the Document and by total Tariff No. value in the Italian version. Finance REP 593
228118 The reverse charge VAT sale invoice entry has not to be included in the VAT report in the Italian version. Finance COD 12182 REP 12195
228588 If you post non-deductible VAT purchase invoices, the VAT report proposes only the deductible base and amount part of the transaction in the Italian version. Finance COD 12182 REP 12195
229012 The Dati Fattura communication must be split in two files DTE (sales invoices/credit memos) DTR (Purchase invoices credit memos) in the Italian version. Finance COD 12182 REP 12195
229213 "00200 - Cannot find the declaration of element 'DatiFattura'. Line  2 - Column 31" error message is displayed by the tool of Agenzia delle Entrate when you try to upload the DatiFattura exported file in the Italian version. Finance COD 12182 REP 12195
229565 The Dati Fattura communication file name format is not compliant to the requirements in the Italian version. Finance COD 12182 REP 12195
229881 The DatiFattura communication file must not contain more than 1000 occurrences. The system should create as many files as are the total occurrences to be reported with the same file name in the Italian version. Finance COD 12182 REP 12195
229943 The split payment sale invoices are not correctly declared in the DatiFattura communication in the Italian version. Finance COD 12182 REP 12195
230054 The customers or vendors entries posted without VAT registration no. or/and fiscal code suggested in the VAT report are exported without any problem, the system does not gets any error message in the Italian version. Finance COD 12182
230084 The system gets an error message that is not correct when you insert the VAT registration number of a customer per vendor in the Italian version. Finance COD 12104
231229 The Dati Fattura communication files the tags DTE (sales invoices/credit memos) or DTR (Purchase invoices credit memos) are missing in the Italian version. Finance COD 12182
231593 The DatiFattura file must report the CededentePerstatore Node in the DTE file and the CessionarioCommittente node in the DTR file only once per file exported in the Italian version. Finance COD 12182
NA - North America
ID Title Functional area Changed objects
228827 The Default Sales Order Confirmation report is set to Report ID 1305 instead of Report 10075 in the North America version. The issue is that 1305 does not subtotal correctly for sales tax when more than one Tax Jurisdiction exists. VAT/Sales Tax/Intrastat PAG 41 PAG 42 PAG 43 PAG 44 PAG 46 PAG 47 PAG 49 PAG 50 PAG 507 PAG 508 PAG 509 PAG 51 PAG 510 PAG 52 PAG 54 PAG 55 PAG 6630 PAG 6631 PAG 6640 PAG 6641 PAG 95 PAG 96 PAG 97 PAG 98 REP 10075 REP 1305
229792 The sales tax calculation on the Sales Order sub-page below the sales lines is incorrect when a sales tax area code and tax liable flag are set after the sales lines are created. The sales order statistics show correctly but do not match the sub-page in the North American version. VAT/Sales Tax/Intrastat PAG 41 PAG 42 PAG 43 PAG 44 PAG 46 PAG 47 PAG 49 PAG 50 PAG 507 PAG 508 PAG 509 PAG 51 PAG 510 PAG 52 PAG 54 PAG 55 PAG 6630 PAG 6631 PAG 6640 PAG 6641 PAG 95 PAG 96 PAG 97 PAG 98 REP 10075 REP 1305
231826 The posting of a purchase invoice with provincial tax in Canada generates an inconsistency error when a mix of expense/capitalize and recoverable tax is used in tax details in the North American version. VAT/Sales Tax/Intrastat COD 90
NL - Netherlands
ID Title Functional area Changed objects
229427 The calculated amount of VAT in the Doc. Amount VAT field of the Purchase invoice header is not correct if the VAT calculation and one of the invoice line is set to NO VAT in the Dutch version. Purchase TAB 38
229824 REP 11000000 does not consider the currency amount rounding precision in the Dutch version. Cash Management REP 11000000
230912 If you post the vendor ledger entries with the same foreign currency code, they are not combined in the telebanking proposal in the Dutch version. Cash Management REP 11000000
NO - Norway
ID Title Functional area Changed objects
229307 The About Remittance information should be removed for SEPA NO payment journals in the Norwegian version. Cash Management COD 15000002 PAG 256
232140 The File Export Errors FactBox field is missing on the Payment Journal page in the Norwegian version. Cash Management COD 10635 COD 10637
232151 An overflow error message ("The length of the string ...") that is related to the document number appears when you import the return file for a SEPA payment in the Norwegian version. Cash Management COD 10636
RU - Russia
ID Title Functional area Changed objects
226079 The Resp. Employees, Buy-from Vendor History FactBox, and Pstd. Invoices page displays incorrect result of drilldown in the Russian version. Finance PAG 9095
226361 The Customer (Vendor) G/L Turnover report shows unexpected total result in the Russian version. Finance REP 12450 REP 12451
229926 System does not save the New CD No. field in direct transfer tracking lines in the Russian version. Inventory PAG 6510
230245 System use un-existing page as LookupPageID for the CD Tracking Setup table in the Russian version. Inventory TAB 12410
SE - Sweden
ID Title Functional area Changed objects
228855 Auto Acc. Group is not considered for purchase invoices in the Swedish version. Finance COD 12 TAB 81
230919 It is possible to work around a blocked situation in the Swedish version. Finance COD 12 TAB 81

Local regulatory features

IT - Italy
ID Title Functional area Changed objects
232507 New setup field to control inclusion of VAT exempt entries on the VAT Settlement comms. report Financial Management COD12151 PAG472 PAG473 TAB325

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 12 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 12 NAV 2017 AT package
AU - Australia Download the CU 12 NAV 2017 AU package
BE - Belgium Download the CU 12 NAV 2017 BE package
CH - Switzerland Download the CU 12 NAV 2017 CH package
CZ- Czech Download the CU 12 NAV 2017 CZ package
DE - Germany Download the CU 12 NAV 2017 DE package
DK - Denmark Download the CU 12 NAV 2017 DK package
ES - Spain Download the CU 12 NAV 2017 ES package
FI - Finland Download the CU 12 NAV 2017 FI package
FR - France Download the CU 12 NAV 2017 FR package
IS - Iceland Download the CU 12 NAV 2017 IS package
IT - Italy Download the CU 12 NAV 2017 IT package
IN - India Download the CU 12 NAV 2017 IN package
NA - North America Download the CU 12 NAV 2017 NA package
NL - Netherlands Download the CU 12 NAV 2017 NL package
NO - Norway Download the CU 12 NAV 2017 NO package
NZ - New Zealand Download the CU 12 NAV 2017 NZ package
RU - Russia Download the CU 12 NAV 2017 RU package
SE - Sweden Download the CU 12 NAV 2017 SE package
UK - United Kingdom Download the CU 12 NAV 2017 UK package
All other countries Download the CU 12 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.