Cumulative Update 05 for Microsoft Dynamics NAV 2017 (Build 16177)

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
200823	OData filters using the StartsWith() method fail to return qualifying records if the EnableODataStrictFiltering value is set to TRUE.
202751	Cannot include menu suites across dependencies in extensions V1.
203220	Record selection selects an incorrect record when you perform a deselection action after having selected multiple lines.
204107	Multiple rows from Excel cannot be copied to the General Journal page without validation errors or warnings.
204518	Query columns are bound to a reverse-sign FlowField and the sign is ignored.
204989	The Post & Print to PDF function from the request window does not allow you to save PDF files.
205092	Compilation of assembly error is displayed when you assign the return value of a Try function to a table field.
205162	The Apply Customer Entries page does not respond well on a small screen.
205165	UNBINDSUBCRIPTION in the OnBeforeCompanyOpen function crashes the client.
205247	Error when logging in as a O365 user where the full name contains Hebrew characters.
205336	The Excel Add-In does not correctly identify shown data as temporary and open to a data export leak.
205841	Runtime error if the Mediaset is included in a query.
205844	The color of the Subordinate Style property is too light compared with NAV 2013 R2 or earlier versions and cannot be easily read in lists and FactBboxes.
205981	The field IDs in a dev environment only show 2 digits.
206147	The Mediaset Item function does not work.
206487	The Cross-Process (Multi-NST) lock that is utilized by an extension install does not handle SQL responses.
206541	The task scheduler causes orphaned jobs and stops running failing jobs if the failure count exceeds a limit.
206853	The client crashes when you select the Customize This Page function on the Extension Management page.

Application hotfixes

ID	Title	Functional area	Changed objects
204167	"Metadata was unable to be retrieved for entity No__Series as it was not found" error when you use the Edit in Excel function on the No. Series page.	Administration	COD 6710
205100	When you create a new G/L account with a blank account category, the name of the G/L account that has just been entered is deleted unexpectedly.	Finance	TAB 15
205313	"The Assembly Header does not exist" error message on the Pick Worksheet page after you process a partial pick of a component of an assembly item by using a basic-warehouse location with the Require Shipment, Pick, and Bin Mandatory settings.	Finance	COD 900
206568	The Standard Sales - Invoice report shows incorrect figures when you use the Price Incl. VAT and Invoice Discount functions. The Total Incl. VAT value is missing and the Total Excl. VAT is shown twice.	Finance	REP 1306
206717	When you use both deferral code and currency code with a currency exchange rate that has been changed on the purchase header, Dynamics NAV creates unexpected G/L and VAT entries.	Finance	COD 12
206827	G/L inconsistency error message appears on posting a sales order with 100% prepayment, price incl. VAT, and partial shipment.	Finance	COD 80 COD 90
207186	"Date is not valid" error message when you try to run the Close Income Statement report. The error message does not point to the reason for the error.	Finance	REP 94
207289	The SetControlAppearance function is called from the OnAfterGetRecord trigger on several pages.	Finance	PAG 255 PAG 256
207622	The consolidation currency adjustment for closing rate accounts due to the change in exchange rate are posting with a global dimension and a dimension value inherited from other consolidated entries incorrectly.	Finance	COD 432
207797	The quantity invoiced on a purchase order is not updated after you create the invoice through intercompany and there is item tracking.	Finance	COD 427
208625	Sales and purchase budgets are mixed up on the Sales and Purchase Analysis By Dimensions pages.	Finance	COD 7150
208920	Analysis View Budget entries are not deleted after you delete budget lines.	Finance	TAB 96
208925	If you use the Apply Entries function and validate the Amount to Apply value, the Applies-to ID field is set but the Applies-to ID value is not deleted when you set the Amount to Apply value to 0.	Finance	PAG 232 PAG 233
209068	The Make Diskette action should be renamed by the Create File action because the term Diskette is outdated.	Finance	PAG 311
210074	Rename the default dimension is not updated on the Cash Flow Manual Expenses or Revenue page.	Finance	TAB 352
205169	When you record an undo shipment or receipt, the user ID of the original shipment or receipt is recorded on the value entry, but not the user ID for the user who posts the undo shipment or receipt.	Inventory	COD 22
205546	The item number on the Post Inventory Cost to G/L report spans to multiple lines after seven or eight characters.	Inventory	REP 1002
205548	Unreadable amounts on the Post Inventory Cost to G/L report span to multiple line unless there is wasted free space.	Inventory	REP 1002
205617	Waste of space on the Picking List report because of large line spacing and big fonts.	Inventory	REP 5752
208672	Slow performance when you run the Whse. Calculate Inventory report.	Inventory	TAB 7312
206819	"The currency exchange rate on all planning lines will be updated based on the exchange rate on the sales invoice." error message if you create a sales invoice from the Job Planning Lines page with a currency even if the exchange rate does not change.	Jobs	COD 1002 REP 1094
204230	Dimensions-single in the Work Center List page does not filter by the selected work center.	Manufacturing	PAG 99000755
205176	The Calc. Regenerative plan is suggesting a line based on the Components at Location option when the item is an assembly item and not a component.	Manufacturing	COD 99000854
205943	When a Capable-To-Promise calculation is accepted from a sales order, for the suggested planned production orders in the planning worksheet, the Ref. Order No. field is incremented by more numbers (9) than what is defined in the number series line (1).	Manufacturing	COD 99000886 TAB 246
206576	"The length of the string is 11, but it must be less than or equal to 10 characters. Value: '200.000'' error message when you delete a line on the Planning Worksheet page.	Manufacturing	COD 99000778
206650	Absent registration is not considered when you use constrained capacity.	Manufacturing	COD 99000810
207782	Inconsistent results in the requisition worksheet depending on whether a calculate plan is run for each location separately or in one run.	Manufacturing	COD 99000854 REP 699
208092	A send-ahead quantity is not considered when a production order is created through the Calc. Regenerative Planning function on the Planning Worksheet page.	Manufacturing	COD 99000810
203300	"Interaction Template does not exist. Identification fields and values code='' error.	Marketing	COD 5051
205004	It is not possible to create a sales quote from an opportunity without a customer.	Marketing	PAG 5124 TAB 5092
208255	The attachment is not embedded in the email body when you log an interaction with the Send Word Docs. as Attmt. option.	Marketing	COD 5054
205113	The Archive Document option is missing in the Standard Purchase – Order report.	Purchase	REP 1322
208171	The Payment Total field on the Vendor - Payment Receipt report should have a different caption to make clear that its purpose is for payment tolerance totals.	Purchase	REP 411
209762	The Buy-from Vendor No. Field is deleted after you post the receipt and re-open a drop shipment purchase order.	Purchase	TAB 38
202838	Sales quotes and sales orders are not automatically archived when you invoice or delete the quotes or orders.	Sales	COD 5063 COD 80 COD 90 TAB 36 TAB 38
203951	Inconsistent availability warnings for a sales order line.	Sales	COD 311 COD 5790
205056	"Quantity Invoiced must not be greater than the sum of Qty. Assigned and Qty. to Assign" error message when you try to print a blanket order with item charges which has been partially shipped and invoiced.	Sales	TAB 37 TAB 39
205130	"An attempt was made to change an old version of a Sales Line record. The record should first be reread from the database. This is a programming error" error message when you post a sales order shipment and the item is reserved and the Calc. Inv. Discount option is enabled.	Sales	COD 86 PAG 498 TAB 1003 TAB 37
205217	The Release action in the Assembly Order List page does not change assembly order status when the list is opened from the sales order.	Sales	PAG 42 PAG 902
205340	The Sales Invoice report does not print the totals section correctly when an invoice discount is involved and the last line is not a normal item line. In addition, the subtotal and the invoice discount are missing.	Sales	REP 206
205345	The Sales Invoice report does not print the totals section correctly when the last line is an item line without an item number.	Sales	REP 206
205848	When you post a batch for sales invoices, the Replace Posting Date value does not work with a certain Sales & Receivables setup.	Sales	COD 80 COD 90
207988	A reservation entry is not deleted when the assembled item with a lot number is deleted from a sales line when you use Explode BOM function.	Sales	COD 63
208812	The Update action does not update item budget entries in on the Sales Analysis by Dimension page.	Sales	TAB 7134
209663	The Contact - Cover Sheet report does not print correctly and truncate values.	Sales	REP 5055
210199	The Delete Invoiced Sales Orders function does not delete all lines and sales orders.	Sales	REP 299 REP 499
210214	The invoice discount is not distributed to the document lines correctly in scenarios with partial invoicing, and no confirm message is shown.	Sales	PAG 46 PAG 54
210956	The Show Matrix function does not show correct values when you run the Sales Analysis by Dimensions report.	Sales	PAG 7158 PAG 9227
204975	"The Troubleshooting Setup already exists" error message when you set up troubleshooting for an item.	Service	PAG 5993
206386	When you use the functionality to undo consumption for posted service shipment lines, Dynamics NAV reverses consumption in service ledger entries, however the reversal is not reflected in the general ledger.	Service	COD 5819
206652	"Select a Dimension Value Code for the Dimension Code XX for G/L Account XX." error message if you try to post a service order which will create some rounding, and one of the dimensions on the Invoice Rounding G/L Account page is set to Code Mandatory.	Service	COD 5986
208909	The Undo Shipment and Undo Consumption functions on the Service Shipment Lines page creates new entries with the posting date from the Service Shipment header and not from the original posting date.	Service	TAB 83
206229	On the Service Contract page, the Create Service Credit action is not displayed correctly.	Service	PAG 6050
205167	"An attempt was made to change an old version of a Warehouse Activity Line record. The record should first be reread from the database. This is a programming error" error message when you change the unit of measure on a warehouse pick.	Warehouse	REP 7314
207231	"Qty. to Handle (Base) in Tracking Specification for Item No. X, Serial No.: Y, Lot No.: Z is currently A. It must be B" error message when you post a warehouse shipment.	Warehouse	COD 7307
207780	Large warehouse receipts with item tracking has posting performance problems when you create a warehouse put-away.	Warehouse	COD 5760 COD 6500
207799	For a warehouse employee, it is necessary to have the permission that allows changes on item cards or modifications in sales and purchase documents. This should not be necessary.	Warehouse	COD 5804 COD 5895
204332	When you replenish the Open Shop Floor Bin Code value for the first time through a movement, the Max. Qty. field on the Bin Content page is set to equal the quantity of the movement in the Canadian version.	Warehouse	COD 7301

Local application hotfixes

AT - Austria

ID	Title	Functional area	Changed objects
210195	Although 1000 lines with 0,16 kg exist in the Intrastat journal, the total weight in the file appears with 0,00 when the authorities expect 160 kg in the Austrian version.	VAT/Sales Tax/Intrastat	REP 11106
203900	The item tracking that has been picked is not updated on the Item Tracking Lines page after you update the Quantity per field on the Prod. Order Component List page in the Austrian version.	Warehouse	COD 6500

BE - Belgium

ID	Title	Functional area	Changed objects
206382	"The operation cannot complete because it uses a feature that is not supported (.NET Framework Interoperability)" error message when you try to select a file name on the EB Payment Journal page by using the Web client in the Belgian version.	Finance	REP 2000005
205106	If you export documents with the PEPPOL 2.1 format, the document cannot be validated in the Belgian version.	Sales	XML 1600
208892	VAT settlement creates wrong entries in case of non-deductible reverse charge VAT in the Belgian version.	VAT/Sales Tax/Intrastat	REP 20

CH - Switzerland

ID	Title	Functional area	Changed objects
208076	The Import Post Code report cannot be used anymore after a format change in the Swiss version.	Administration	REP 11502

DACH

ID	Title	Functional area	Changed objects
208581	The SetGLAccountNoInVATEntries function slows down the posting routine significantly in the DACH version.	Finance	COD 12 PAG 315 TAB 254
207617	The Sales VAT Adv. Not. Acc. Proof report is even slower after the performance update in the DACH version.	Finance	REP 11009 TAB 254

DE - Germany

ID	Title	Functional area	Changed objects
207617	The Sales VAT Adv. Not. Acc. Proof report is even slower after the performance update in the German version.	Finance	REP 11009 TAB 254
205952	It is possible to create an intrastat file although the weight mandatory information is missing in the German version.	Finance	COD 2
206401	Test report does not check the missing Intratstat Code value on the Country/Region Code page in the German version.	Finance	COD 2

DK - Denmark

ID	Title	Functional area	Changed objects
208678	"The Payment Type Validation in Payment Method, FIK 71 must be Domestic or International." error message when you try to apply a payment to an invoice in the Danish version.	Cash Management	TAB 21

ES - Spain

ID	Title	Functional area	Changed objects
203453	The Total VAT Amount value is not printed correctly in the VAT Declaration page if you use the Two Columns Report option for the Template Type field in the Spanish version.	Finance	REP 12
206340	The New Page field does not have any effect in the VAT Statement report preview and print if the VAT Statement Name value is set up with the two-column report template in the Spanish version.	Finance	REP 12
207999	The opening and closing entries are not shown in the Account - Official Acc. Book report if there is only one transaction posted on the 1. January and it does not involve G/L accounts of groups 6 or 7 in the Spanish version.	Finance	REP 10706
203849	The Bills Account value is used incorrectly if you unapply a payment and a refund for a customer which uses the payment method that creates bills in the Spanish version.	Sales	COD 12
206545	The Make 347 Declaration report takes a long time to export the file in the Spanish version.	VAT/Sales Tax/Intrastat	REP 10707

FI - Finland

ID	Title	Functional area	Changed objects
205808	If you use the Suggest Vendor Payments function to create payments in the future, the suggested posting date does not match the date used by the Bank Payments to Send function in the Finish version.	Cash Management	REP 32000003 REP 393

FR - France

ID	Title	Functional area	Changed objects
206410	The conditions in a workflow are not kept if you switch to another language in the French version.	Finance	COD 1530
208540	The G/L Detail Trial Balance report does not show entries when they have the same G/L Account, Document No., Posting Date, and Amount values in the French version.	Finance	REP 10804
208795	The general ledger entries with zero amount should be excluded from the Export G/L Entries - Tax Audit report in the French version.	Finance	REP 10885
209012	When you group entries in the Intrastat journal, the result is not correct in the French version.	VAT/Sales Tax/Intrastat	REP 594

IT - Italy

ID	Title	Functional area	Changed objects
203084	If you export the SEPA CT file from the payment journal, and the vendor payment lines are two or more for each payment line of the batch, the system exports the same information in the file in the Italian version.	Cash Management	COD 1221 XML 12100
206932	The Certification Utica 2017 declaration file structure has been modified and the file is no longer accepted in the Italian version.	Finance	COD 12132
204009	A production order line is not removed when you delete a given production order line with dependent (make-to-order) lines in the Italian version.	Manufacturing	TAB 5407

NA - North America

ID	Title	Functional area	Changed objects
205958	The beginning balance line is listed twice on the Trial Balance Detail/Summary page in the American version.	Administration	REP 10021
205877	The description from the Cross Reference No. value does not populate correctly on the purchase order when it is created from the Planning Worksheet page in the American version.	Inventory	COD 76 TAB 246 TAB 5717
206360	A negative lead time calculation is allowed (for example, 6W-8W) and it causes the planning system to hang and not respond in the American version.	Inventory	COD 5404 TAB 23 TAB 27 TAB 38 TAB 39 TAB 5700 TAB 99
208266	"There are multiple expiration dates registered for Lot ....." error message when you post a reclassification journal to change the expiration date in the American version.	Inventory	COD 6500 COD 6501
207916	Printing an order with 28 lines within a range by using the Purchase Order report will cause header values to be out of sync in the North American version.	Purchase	REP 10122
210377	IRS rejected a Magnetic Media file due to an invalid amount code for record A in the North American version.	Purchase	REP 10115
204914	Incorrect G/L deferral entries are created when a sales tax is included on a sales document in the North American version.	Sales	TAB 37

NL - Netherlands

ID	Title	Functional area	Changed objects
206277	The calculated amount of VAT in the Doc. Amount VAT field of the Purchase Invoice header is not correct if the VAT calculation of one of the invoice lines is set to No VAT in the Dutch version.	Finance	TAB 38

NO - Norway

ID	Title	Functional area	Changed objects
204944	If you export the SEPA CT file for a vendor whose payment is set to Remittance, and the Remittance Account is set to Foreign, the content of the Recipient Ref. Abroad field of the Payment Info page are not exported to the file in the Norwegian version.	Cash Management	COD 1221

RU - Russia

ID	Title	Functional area	Changed objects
207730	The system does not allow consecutive filling of fields in the general journal for vendors or customers who use agreements in the Russian version.	Finance	TAB 81
209179	The system blocks the Sales Corrective Credit Memo and Get Corr. Doc. Lines process when the Enable Red Storno value is set to Yes and you use the Customs Declaration feature in the Russian version.	Inventory	COD 12422

Local regulatory features

RU - Russia

ID	Title	Functional area	Changed objects
202215	Changes in VAT Declaration (2017)	Financial Management	TAB12405, TAB12411, REP12455, REP12456, REP12461, REP14962, REP14963, COD12423, PAG12413, PAG12443