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

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.

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

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

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.