Cumulative Update 12 for Microsoft Dynamics NAV 2016 (Build 47042)

This article applies to Microsoft Dynamics NAV 2016 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 2016, 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 2016, see released cumulative updates for Microsoft Dynamics NAV 2016. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2016.

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
378951	Filters and parameters are not visible in web services
380086	Unexpected results when you use Limit Totals filter on a FlowFilter that references fields with the SQL Data Type value set to Variant.
380342	Pages that have the Page Type value set to NavigatePage and contain a repeater group will not save column width personalization.
380559	The cursor is moved to a random place when you delete lines from a large document.
380568	"Method 'PageNN.a60ActionNNNNNN_a45_OnAction' not found" error message when you try to reopen a released purchase order or sales order for users with the RapidStart Services profile.
380596	The client behaves unexpectedly when you make modifications on filtered purchase (or sales) order lines.
380617	The Euro sign, ↺, is not saved properly in the development environment and it is replaced with the question mark, ?.
380669	Disable colorization in the documentation block in CSIDE.
380688	A disabled field is still shown on a page if the Caption ML property is filled in on the source table.
380718	NavNCLDialogException in the web client with blank error.
380757	A page with SourTableTemporary enabled gives strange results when it has an action.
380827	Performance issue during lookup of sales or purchase unit of measure.
380901	Export to a data file throws SqlNullValueException.
380955	Enable Windows client control add-in to run in legacy IE7 mode.
380964	w3wp IIS worker process crash CLR_EXCEPTION_System.NullReferenceException.
380965	Sessions that time out with a modal dialog open may not close all associated threads.
380983	NST health improvements.

Application hotfixes

ID	Title	Functional area	Changed objects
380755	Job WIP calculation is incorrectly calculating a negative job WIP value under cost value even though job usage is positive and no invoice has been posted, so all usage cost should be posted as positive WIP.	Jobs	COD 1000
380695	Wrong general ledger entry number is shown in the job ledger entry.	Jobs	COD 1001 COD 1012 COD 80 COD 90
380627	Item tracking lines are required when posting a job journal even though a reservation exists that should automatically provide the necessary information.	Jobs	COD 1004 TAB 1003 TAB 210
380473	When you post a line with line type Blank in the job journal, no related job planning line is created.	Jobs	COD 1026
380717	"The file that you are trying to import...is different from the specified Payroll Import" error message if you try to import a txt file with the Fixed Text file type and the Payroll Import type.	Administration	COD 1202
380826	"An attempt was made to change on old version of a Sales Invoice Header record. The record should first be reread from the database" error message if you send a OIOUBL sales invoice through the document exchange service to Tradeshift in the Danish version.	Sales	COD 1411
380693	"The type NavBoolean is unknown" error message if you create a workflow to control the changes over a boolean field.	Administration	COD 1531
380752	Wrong filter expression in Codeunit 1535, approvals Mgmt in the DeletePostedApprovalCommentLines function.	Finance	COD 1535
380753	Issues with comments in document approvals and workflows.	Finance	COD 1535 PAG 41 PAG 42 PAG 43 PAG 44 PAG 49 PAG 50 PAG 507 PAG 509 PAG 51 PAG 52
380648	When you export a positive pay file with no header defined, a blank row is displayed before the transaction detail.	Cash Management	COD 1700 COD 1711
380838	The Last Direct Cost field on the item card is inaccurately updated with the value of the cost adjustment.	Inventory	COD 22
380591	"Amount must be negative in Gen. Journal Line Journal Template Name" error message when you void a payment with a credit memo involved.	Purchase	COD 367
380579	If you change a standard text in a document the extended text is not deleted.	Sales	COD 378
380874	Mistakenly open and overdue customer ledger entries are missing on the reminder.	Sales	COD 392
380810	CU418 is missing permissions on tables where the user table is involved.	Client	COD 418
380215	CRM integration does not map the extended amount or total amount for posted invoices.	Sales	COD 5334 COD 5341 COD 5342
380646	CRM integration does not consider blocked or active/retired status for items and products.	Administration	COD 5334 COD 5341 COD 5342 COD 5343
380128	CRM sync may be blocked if someone updates a non-synced record.	Client	COD 5335
380575	"You do not have the following permissions on TableData Sales Invoice Header: Modify" error message when you use a customer license with CRM Integration.	Server	COD 5341 COD 5342 PAG 132 PAG 143
380831	For a sales order with an open released warehouse shipment header, shipment date(s) can be changed on the sale order without a warning. The warehouse shipment remains without that change.	Sales	COD 5777 TAB 37
380520	The application is not considering already calculated and assigned cross-dock opportunities.	Inventory	COD 5780 PAG 5783 TAB 5768
380496	Service items created have no serial tracking when two sales orders are on the same drop-shipment purchase order.	Service	COD 5920 COD 90
380819	Item reclassification journal does not raise an error when you reclassify a new lot with no lot information card and the Lot No. Info Must Exist check box is selected for the item tracking code.	Inventory	COD 6500
380764	The allow line discount information of a customer price group is not considered for jobs prices.	Jobs	COD 7000
380725	No values are shown on the Sales Analysis Matrix page if you change the Analysis Column Template value for a Sales Analysis report.	Sales	COD 7110 PAG 7117 PAG 7118 PAG 7119
380814	The Source Document Line function on the Warehouse Shipment page does not open the relevant source document when this is a service order.	Warehouse	COD 7302 PAG 7341
380556	“Nothing to Handle” error message when you create a pick where the first expired FEFO item is in a bulk bin, but there is enough quantity in a pickable bin. Requesting a better error message.	Warehouse	COD 7312
380793	Wrong entries amount when you switch to ARC on the Acc. Schedule page.	Finance	COD 8
380573	If you create a credit memo when you use the Copy Document functionality from an invoice where the posting group was modified after posting it, the wrong posting group is used in the posted credit memo.	Sales	COD 80 COD 90
380611	The notes are not correctly transferred to the posted sales shipments and posted purchase receipts if you use the Drop Shipment functionality.	Sales	COD 80 COD 90
381030	Realized Gains/Loss entries are not created when you post a purchase invoice using get receipt lines created for a purchase order with prepayment in FCY.	Prepayments	COD 80 COD 90
381004	The assembly order is recreated when this is an assembly-to-order and the sales order was created from a sales quote.	Inventory	COD 86 TAB 904
380850	When you post partial deferrals, a wrong VAT amount is calculated for whole document.	Finance	COD 90
380652	"The Bin does not exist. Identification fields and values: Location Code = X, Code=''" error message when you post a purchase receipt with negative quantity, bin content, and the job is validated.	Purchase	COD 90 TAB 83
380815	Wrong filter on the Sales Analysis page by dimension when you use the Show Column Name option.	Finance	COD 9200
380315	When you use the Calculate Bins function from the bin creation worksheet, letters in the From No. field and the To No. field appear to be overlooked by the process.	Warehouse	N/A
380508	Miscellaneous errors cause the standard C/AL test tool to fail out of the box with the standard Cronus database.	DEV Environment (C/SIDE)	N/A
380767	Text constants are not translated when you use the Get Posted Document Lines to Reverse function.	Sales	N/A
380560	"None of the items in the filter have a BOM" error message when you filter by product on the BOM Cost Shares page.	Inventory	PAG 5872
380668	If you export all fields in a RapidStart package including the Dimension Set-ID field and you add a custom field, the data is not imported back correctly.	Administration	PAG 8626
380945	It is possible to post a sales order with a dimension combination that is set to Blocked.	Finance	PAG 9252 PAG 9253
380585	The Delayed page does not show all delayed sales lines.	Sales	QUE 9060 TAB 9053
380615	The DataItemTableView property not defined in ItemErrorLoop dataitem from report 1004.	Inventory	REP 1004
380775	When you create a line in a journal from the direct debit collection, the Document No. field contains incorrect values if there are more than one document in the direct debit collection.	Cash Management	REP 1201
380770	The Double Underline option within the account schedule prints a single underline when the New Page check box is selected.	Finance	REP 25
380953	Error appears when you update an existing Excel spreadsheet.	Finance	REP 29
381022	If the TableRelation property in the Job Usage Link table does not relate to the Job No. field, all job usage link records with the same job task number will be renamed regardless of the job number when a given job task is changed.	Jobs	TAB 1020
380565	"You cannot change osting Method because there is at least one outstanding Purchase Order that include this item" error message when you configure a master template for an item card when purchase order lines with blank Item No. field exist at the same time.	Inventory	TAB 27
380749	"There are no items with cross reference: X" error message when an IC transaction is completed.	Inventory	TAB 37 TAB 39
380976	The variant code is not validated into the purchase line when you look up into the blanket Order No. field to validate blanket order data.	Purchase	TAB 37 TAB 39
380744	Backlog request to allow processing interaction templates without Word .NET usage on the client side.	Sales	TAB 5062 TAB 5077 TAB 5103
380686	Missing table relations on some tables.	Client	TAB 5107 TAB 5109 TAB 9650
380644	The location code is not correctly set after making a service item replacement for an item with item tracking in use.	Service	TAB 5902
380716	"Quantity (Base) available must not be less than nn in Bin Content Location Code = 'AAAA' ,Bin Code ='XX-XX-nnnn', Item No. = 'YYYY' Variant Code ='',Unit of Measure Code='BBB'" error message when you register a pick.	Warehouse	TAB 7302

Local application hotfixes

AT - Austria

ID	Title	Functional area	Changed objects
380789	An incorrect error message is displayed in the VAT Statement AT report in the Austrian version.	Finance	REP 11110

AU - Australia

ID	Title	Functional area	Changed objects
380947	The BAS Adjustment field is not updated on the GST Entry table when you post a sales CR/ADJ with a note applied to an invoice in the Australian version.	Finance	COD 12

BE - Belgium

ID	Title	Functional area	Changed objects
380723	"A call to System.IO.Directory.CreateDirectory failed" or "A call to System.IO.File.Copy failed" error message if you try to export an EB payment to SEPA by using a non-available location or folder where you do not have permissions to operate in the Belgian version.	Cash Management	REP 2000005
380864	"The path XXXXXX does not exist. Do you want to add it now?" error message should be displayed if you try to export an EB payment to SEPA by using a non-available location or folder in the Belgian version.	Cash Management	REP 2000005

CH - Switzerland

ID	Title	Functional area	Changed objects
380849	The IBAN only contains 17 spaces instead of 21 in the layout of the LSV Collection Authorization report in the Swiss version.	Cash Management	REP 3010836

CZ- Czech

ID	Title	Functional area	Changed objects
380785	Intrastat - Changes relating to the exchange rates in the Czech version.	Finance	PAG 31065 PAG 473 REP 594 TAB 31065 TAB 325
380791	An error appears when you print a domestic payment order from the Issued Payment Order page in the Czech version.	Finance	PAG 11721 PAG 11724
380794	The Turnover report by global dimension does not print the entire landscape in the Czech version.	Finance	REP 11772
380795	The Sales Advance Letter List report and the Purch. Advance Letter List report do not print the document numbers with 10 characters in the Czech version.	Finance	REP 31010 REP 31030
380798	The check of commodity limit amount LCY is incorrect in sales orders in the Czech version.	Sales	COD 80
380799	There is missing differentiation service of Intrastat on the VAT Posting Setup page in the Czech version.	Finance	T325 P473 R594
380801	The documentation for VAT report displays incorrect amount if I use the Reverse Register action for VAT entries with non-deductible VAT in the Czech version.	Finance	REP 11764
380802	Incorrect calculation of cost amount on the value entries if you use non-deductible VAT for charges in the Czech version.	Purchase	COD 90
380803	An error appears when you edit a purchase document that is in foreign currency and is missing an exchange rate for the VAT date in the Czech version.	Purchase	TAB 36 TAB 38
380805	The base and the amount are calculated incorrectly for the VAT Control report for reverse charges when you do not use the Merge VAT Entries function in the Czech version.	VAT/Sales Tax/Intrastat	COD 31100
380822	The lines from the bank statement or payment reconciliation journal are not correctly linked to the advance letter, although there is a clear connection in the Czech version.	Finance	COD 1255
380913	From the Adv. Payment Selection - Purch page and the Adv. Payment Selection – Sales page the reports for printing the Purchase Advance Letters page and the Page Sales Advance Letters page are not used in the Czech version.	Prepayments	PAG 31003 PAG 31023
380925	The filter for global dimension is used only for the first account in the Turnover report by global dimensions in the Czech version.	Finance	R11772
380927	The customer title and the vendor title have been switched in the Vendor - Bal. Reconciliation report in the Czech version.	Purchase	REP 11787
380930	If you use the Undo Shipment function from the posted transfer shipment, then you get message that the bin does not exist in the Czech version.	Warehouse	COD 31070 COD 7320
380934	The Cash Desk Account Book report is not sorted by date but by entry number and shows incorrect balances in the Czech version.	Cash Management	REP 11741
380937	The VAT Registration No. field is not filled in a document if the Bill-to/Sell-to VAT Calc. field contains Sell-to/Buy-from No. on the General Ledger Setup page in the Czech version.	Finance	TAB 36 TAB 38
380941	The IBAN and SWIFT fields are not transferred to the payment reconciliation journal in the Czech version.	Cash Management	REP 11701 TAB 270
380942	The Service - Invoice CZ report and the Sales - Invoice CZ report may be displayed on two pages and the second page is empty in the Czech version.	Sales	REP 31088 REP 31096
380943	If you set up the custom report layout for invoices, then the report is printed although it is the advance invoice in the Czech version.	Prepayments	TAB 9657

DACH

ID	Title	Functional area	Changed objects
380875	Incorrect special characters in the Create XML-File VAT Adv. Notif report in the DACH version.	REP 11016

ES - Spain

ID	Title	Functional area	Changed objects
380747	Credit memos with no taxable VAT for EU operations are not included in the 349 Declaration file in the Spanish version.	VAT/Sales Tax/Intrastat	PAG 10736 REP 10710 TAB 113 TAB 123
380645	The Posted Payment Orders Maturity page only shows the right information for the first payment order in the list in the Spanish version.	Purchase	PAG 7000050 PAG 7000054 PAG 7000055
380766	The Payment Order Maturity functionality is duplicated on some purchase documents in the Spanish version.	Purchase	PAG 7000050 PAG 7000054 PAG 7000055
381041	The Payment Order Maturity functionality is duplicated on some sales documents in the Spanish version.	Sales	PAG 7000050 PAG 7000054 PAG 7000055
380841	"Index out of bounds" error message if you include more than one credit memo correcting a previous period in the Make 349 Declaration functionality in the Spanish version.	VAT/Sales Tax/Intrastat	REP 10710
380664	The paydays are not correctly calculated in the Vendor - Overdue Payments report if the document is paid after the due date in the Spanish version.	Purchase	REP 10748
380773	If you settle a payment order with a currency in an earlier date than the documents associated, the Adjust Exch. Rates G/L entries created uses the document dates and not the payment order dates in the Spanish version.	Purchase	REP 7000082
380651	"Attempted to divide by zero" error message when you validate the Applies-from Entry field on the Job Journal page in the Spanish version.	Jobs	TAB 210

IT - Italy

ID	Title	Functional area	Changed objects
381048	If the Allow Issue field of the bill code is set to false, when I recall more than one customer bill the second recalled bill is applied to the wrong entry in the Italian version.	Finance	COD 12
380696	If you post a sale or a purchase invoice and a deferral code is used, the G/L entries of deferred transactions are not reflected on the G/L Book entries page in the Italian version.	Finance	COD 12 TAB 12144
380553	If you post a partial payment for an unrealized VAT sale invoice that contains multiple lines, the reversal as realized VAT is not correct in the Italian version.	VAT/Sales Tax/Intrastat	COD 12 TAB 254
381023	The threshold amount set for Black List transactions is wrongly calculated. It is compared with every single sale or purchase document instead of being compared to the annual total amount posted for a customer or vendor in the Italian version.	VAT/Sales Tax/Intrastat	COD 12130
380629	If the related date of withholding tax entries are set at the previous year in relation to the year of the Certificazione Unica declaration period, the base amounts are included in the Record H field in the Italian version.	Finance	COD 12132
380800	If a purchase invoice is posted with a payment term code that includes a payment discount, when this invoice is paid through a vendor bill list the payment discount amount is calculated and deducted two times in the Italian Version.	Finance	COD 12173
380781	If you post a vendor bill list, the Vendor Bill List and Vendor Bill No. fields are missing in the Vendor Ledger Entry table and is it not possible to see the data on the Vendor Bill List page in the Italian version.	Cash Management	PAG 29 TAB 12182

NA - North America

ID	Title	Functional area	Changed objects
380763	The Action Image property is missing in the North American version.	Finance	PAG 36629 PAG 36630 PAG 36631 PAG 9000 PAG 9002 PAG 9003 PAG 9005 PAG 9006 PAG 9008 PAG 9020
380868	When you print the Sales Invoice report for a sales invoice that only has a G/L account on the line, the report prints with #ERROR for the amounts on the report in North American version.	Sales	REP 10074
380817	Wrong G/L entries are created when a purchase line contains a deferral code and a sales tax jurisdiction contains a tax detail using the Expense/Capitalize Sales Tax functionality in the North American version.	Purchase	TAB 37 TAB 39

RU - Russia

ID	Title	Functional area	Changed objects
380873	Strange difference in initial and reverse sides of G/L Corresp. Entry records in the Russian version.	Finance	COD 12404
380889	The VAT Settlement process does not copy dimensions that are set on purchase invoice lines in the Russian version.	Finance	COD 12411
380804	The G/L Account filter does not work on the Vendor and Customer Accounting Card pages in the Russian version.	Finance	N/A
381009	The Vendor G/L Turnover report does not show all data on printouts and previews in the Russian version.	Finance	REP 12443 REP 12444 REP 12447 REP 12450 REP 12451 REP 12464
380811	The Vendor G/L Turnover report shows unexpected results in the Russian version.	Finance	REP 12451
380977	The FA Turnover report shows unexpected results on direct printouts in the Russian version.	Finance	REP 12466
380978	The FA Turnover report does not fill the header for the first page in the Russian version.	Finance	REP 12466
380954	The Customer - Reconciliation Act report shows unexpected results in scenarios with invoices, credit memos, and payments in the Russian version.	Finance	REP 14910
381017	The Customer - Reconciliation Act report shows unexpected results in scenarios with sales corrective credit memos when you decrease the unit price and mark the credit memos as corrections in the Russian version.	Finance	REP 14910
381049	The Customer - Reconciliation Act report wrongly shows closed entries of previous period in scenarios with two invoices and two payments in the Russian version.	Finance	REP 14910

SE - Sweden

ID	Title	Functional area	Changed objects
380812	When you use both a deferral code and an automatic account code on vendor invoice lines, the system posts unexpected G/L entries in the Swedish version.	Finance	COD 12

UK - United Kingdom

ID	Title	Functional area	Changed objects
380866	The auto matching functionality for bank reconciliation is not working with the GB BACS functionality in the British version.	Cash Management	COD 10550 COD 1252 PAG 379
380754	CRM Integration depends on the External Document No. field in Dynamics NAV in the British version.	Marketing	COD 5330 COD 5341 COD 5343 COD 80 PAG 5330 TAB 5330

Resolution

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 2016

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 2016 database:

Country	Hotfix package
AT - Austria	Download the ATKB3193868 package
AU - Australia	Download the AUKB3193868 package
BE - Belgium	Download the BEKB3193868 package
CH - Switzerland	Download the CHKB3193868 package
CZ- Czech	Download the CZKB3193868 package
DE - Germany	Download the DEKB3193868 package
DK - Denmark	Download the DKKB3193868 package
ES - Spain	Download the ESKB3193868 package
FI - Finland	Download the FIKB3193868 package
FR - France	Download the FRKB3193868 package
IS - Iceland	Download the ISKB3193868 package
IT - Italy	Download the ITKB3193868 package
IN - India	Download the INKB3193868 package
NA - North America	Download the NAKB3193868 package
NL - Netherlands	Download the NLKB3193868 package
NO - Norway	Download the NOKB3193868 package
NZ - New Zealand	Download the NZKB3193868 package
RU - Russia	Download the RUKB3193868 package
SE - Sweden	Download the SEKB3193868 package
UK - United Kingdom	Download the GBKB3193868 package
All other countries	Download the W1KB3193868 package

How to install a Microsoft Dynamics NAV 2016 cumulative update

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

Prerequisites

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

More Information

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

Status

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