存档

2017年10月 的存档

NAV2017 累计更新- 11#

2017年10月29日 没有评论

 

Cumulative Update 11 for Microsoft Dynamics NAV 2017 (Build 18609)

发布版本号 Build No. – 18609

发布日期 Release Date – 2017年10月

下载链接

更新项:

ID

Title

Functional area

Changed objects

225334

The Suggest Vendor Payments action does not use the Message to Recipient field that is set on the Vendor Ledger Entries page.

Cash Management

REP 393

227412

Reversed bank ledger entries are available on the Bank Reconciliation page.

Cash Management

PAG 379

224785

If you set the Dimension filter field on the Account Schedule Overview page and drill down on the values, the filter on the drill down page is incorrectly set if you use the “*” criteria.

Finance

COD 408 PAG 490

226068

An error message displays when you filter G/L budget entries.

Finance

TAB 96

226928

You cannot use a keyboard to open workflow template records.

Finance

PAG 1505

227987

A VAT entry is missing in an apply scenario with a payment tolerance and the Adjust for Payment Disc. option is enabled.

Finance

COD 12

229045

A Country/Region is not specified for VAT entries that are created from reminder fees.

Finance

COD 393

228081

An image is missing in an action item on the FA Depreciation Books Subform page.

Fixed Assets

PAG 5666

225989

The Item list is blank when you filter the list by attributes and use three different attributes.

Inventory

COD 7500

226030

Item availability displays incorrect information in the Sales FactBox when you enter a sales line with a quantity that is not an integer.

Inventory

PAG 9087

226997

The value in the value record of an item attribute is incorrect when there are different users with different regional settings.

Inventory

TAB 7504

227028

"The value "2,4" cannot be evaluated into the type Decimal" error message when you validate the Default Value column on the Item Category page.

Inventory

PAG 5734

227249

The IncludeItemWithNoTransaction option is missing in the InitializeRequest function on the Calculate Inventory report.

Inventory

COD 7380 REP 790

225344

If you use the Copy Job Planning Lines action for a job that has job ledger entries, the Ledger Entry No. field and the Ledger Entry Type field are filled in.

Jobs

COD 1006

228304

The Transferred Date and Invoiced Date fields are blank on the Job Invoices page.

Jobs

COD 1002

220589

Routing with a send-ahead quantity causes inaccurate capacity need and capacity allocation.

Manufacturing

COD 99000774 COD 99000810

223521

"Cannot match item tracking" error message when you post an inventory put-away on a transfer order.

Manufacturing

COD 99000831

224311

You can clear the Quantity Per field in the Production Order Component list, and change the component item to another item number after the consumption been posted.

Manufacturing

TAB 5407

225032

The BOM Cost Share page does not consider the ending date of the component stated on the Prod. BOM page.

Manufacturing

COD 5870 PAG 5870 PAG 5872

226947

The bin code from the work center in an active routing version is not recognized when you create the production order from the Planning Worksheet page.

Manufacturing

COD 7302 COD 99000854 TAB 246

227211

The Prod. Order – Shortage List page does not recognize a shortage for an item that occurs on several component lines.

Manufacturing

REP 99000788

228096

When you post a higher consumption than expected, and sort consumption journal lines by quantity, redundant item ledger entries are created.

Manufacturing

COD 23

227819

When you create a sales order from an opportunity on the Opportunity Card page, the Sales Document Type field states "2" instead of "Order."

Marketing

PAG 5124

228567

The Team Name (Text 30) field on the To-do table has a lookup to the Name (Text 50) field on the Team table.

Marketing

TAB 5080

224262

The Carry Out action does not combine drop shipments into one purchase when the vendor and location are the same.

Purchase

COD 333

225494

The Post and Print action for Return Order prints the invoice instead of the credit memo.

Purchase

COD 92

225653

The tooltip for the No. field on the Purchase Quote page and the Purchase Order page is incorrect.

Purchase

PAG 49 PAG 50

226016

"The total item tracking quantity 2 exceeds the line quantity 1. The changes cannot be saved to the database" error message when you get bin contents from the transfer header.

Purchase

REP 7391

223815

For drop shipments, a sales order archive is not created when Blank is chosen in the Default Qty. to Ship field on the Sales & Receivables setup page.

Sales

COD 80 COD 90

224140

If you change the VAT Amount field on the Sales Invoice Statistics page, the Total VAT Amount field and the Total incl. VAT field are incorrect on the Sales Invoice Page.

Sales

COD 414 COD 415 COD 57 PAG 402 PAG 403

225395

When you enter a name in the Customer field in a sales order, and select a customer that has the same name as several others, the selection will be overruled and the first customer in the list is assigned to the sales order.

Sales

TAB 36 TAB 38

225594

Last Submitted to Back Office (lastbackofficesubmit) is not populated when you submit a sales order from CRM to NAV.

Sales

COD 5343

225644

The Payment Discount Amount field and the Balance Amount Total field are incorrect on the Apply Customer Ledger Entries page if you apply a payment, invoice, or credit memo with a payment discount.

Sales

PAG 232

226062

For drop shipments, the sales order archive is not created when Blank is chosen in the Default Qty. to Ship field on the Sales & Receivables setup page.

Sales

COD 80 COD 90

226699

The tooltip is incorrect for the Card (Shift+F7) action on the Sales Order, Blanket Sales Order, and Sales Return Order pages.

Sales

PAG 41 PAG 42 PAG 43 PAG 44 PAG 50 PAG 507 PAG 509 PAG 6627 PAG 6630

227181

Performance issue with sales invoices when you choose a customer after you enter the name of a customer who is not registered.

Sales

COD 9990 TAB 18

228033

When you use the Create Return-Related Documents action from a sales return order to create a new sales order, the ship-to address is incorrect.

Sales

COD 6620 TAB 36

228108

When you create a sales return order by using the Get Posted Document Lines to Reverse action, and you choose the posted shipments, the system does not check whether prices include VAT.

Sales

COD 6620

228378

CC and BCC email addresses are not reset on the Send Email page.

Sales

PAG 9700

229699

Performance issue for purchase invoices when you choose a vendor after you enter the name of a vendor who is not registered.

Sales

COD 9990 TAB 18

223551

Pick worksheet line is created with a negative value in the Qty. to Handle field if the quantity on the inventory is partially reserved, and the quantity on pick bins is less than the reserved quantity on the inventory.

Warehouse

COD 7312

223800

"Quantity (Base) available must not be less than Quantity in Bin Content Location Code=Y,Bin Code=Z,Item No.=A,Variant Code=B,Unit of Measure Code=C" error message when you post a warehouse shipment for an assembly order where components are fully registered.

Warehouse

TAB 7302

224568

Filtering by item attributes can be slow.

Warehouse

COD 7500 PAG 31

225420

The Available Qty. to Pick field is not recognized on the Pick Worksheet page if there are reservations, and Yes is chosen in the Always Create Pick Line field on the Location card.

Warehouse

COD 7312 TAB 7326

226023

The Create Pick action from the Warehouse Shipment page creates a warehouse activity when there is no stock available to pick.

Warehouse

COD 7314

226124

The Cross-Dock Opportunity page does not show the sales order behind the calculated quantity to cross-dock.

Warehouse

COD 5780

227199

When an item is picked for a service order and partially shipped, all items are removed from ship bin.

Warehouse

COD 5980 COD 5988 COD 6500

分类: Uncategorized 标签:

NAV2016 累计更新- 24#

2017年10月29日 没有评论

 

Cumulative Update 24 for Microsoft Dynamics NAV 2016 (Build 49326)

发布版本号 Build No. – 49326

发布日期 Release Date – 2017年10月

下载链接

更新项:

ID

Title

Functional area

Changed objects

224078

If you enter an approval comment, the posted approval comment line is empty and the Comment field on the Posted Approval Entries page shows No.

Administration

COD 1535

226257

Some workflow events are not available in the When Event field on the Workflow Steps page.

Administration

TAB 1507

224784

If you set the Dimension filter field on the Account Schedule Overview page and drill down on the values, the filter on the drill down page is incorrectly set if you use the “*” criteria.

Finance

COD 408 PAG 490

225135

An error message displays when you filter G/L budget entries.

Finance

TAB 96

226689

You cannot open workflow template records by using a keyboard.

Finance

PAG 1505

227986

A VAT entry is missing in an apply scenario with a payment tolerance and the Adjust for Payment Disc. option is enabled.

Finance

COD 12

228341

A Country/Region is not specified for VAT entries that are created from reminder fees.

Finance

COD 393

227233

An image is missing in an action item on the FA Depreciation Books Subform page.

Fixed Assets

PAG 5666

228303

The Transferred Date and Invoiced Date fields are blank on the Job Invoices page.

Jobs

COD 1002

226946

The bin code from the work center in an active routing version is not recognized when you create the production order from the Planning Worksheet page.

Manufacturing

COD 7302 COD 99000854 TAB 246

227210

The Prod. Order – Shortage List page does not recognize a shortage for an item that occurs on several component lines.

Manufacturing

REP 99000788

228566

The Team Name (Text 30) field on the To-do table has a lookup to the Name (Text 50) field on the Team table.

Marketing

TAB 5080

223887

"The total item tracking quantity 2 exceeds the line quantity 1. The changes cannot be saved to the database" error message when you get bin contents from the transfer header.

Purchase

REP 7391

225456

Last Submitted to Back Office (lastbackofficesubmit) is not populated when you submit a sales order from CRM to NAV.

Sales

COD 5343

227460

For drop shipments, the sales order archive is not created when Blank is chosen in the Default Qty. to Ship field on the Sales & Receivables setup page.

Sales

COD 80 COD 90

228107

When you create a sales return order by using the Get Posted Document Lines to Reverse action, and you choose the posted shipments, the system does not check whether prices include VAT.

Sales

COD 6620

224091

The Cross-Dock Opportunity page does not show the sales order behind the calculated quantity to cross-dock.

Warehouse

COD 5780

227198

When an item is picked for a service order and partially shipped, all items are removed from ship bin.

Warehouse

COD 5980 COD 5988 COD 6500

分类: Uncategorized 标签:

NAV2015 累计更新- 36#

2017年10月29日 没有评论

 

Cumulative Update 36 for Microsoft Dynamics NAV 2015 (Build 49321)

发布版本号 Build No. – 49321

发布日期 Release Date – 2017年10月

下载链接

更新项:

ID

Title

Functional area

Changed objects

225541

The analysis view budget entries are not updated when records in the G/L Budget Entries table are changed.

Finance

PAG 120 PAG 9203

226717

When you post a sales invoice with one line with a 100% discount, the VAT amount in G/L entries for the revenue account and the discount account is zero.

Finance

COD 80 COD 90 TAB 49

227985

A VAT entry is missing in an apply scenario with a payment tolerance and the Adjust for Payment Disc. option is enabled.

Finance

COD 12

225966

The Transferred Date and Invoiced Date fields are blank on the Job Invoices page.

Jobs

COD 1002

225889

The Prod. Order – Shortage List page does not recognize a shortage for an item that occurs on several component lines.

Manufacturing

REP 99000788

226945

The bin code from the work center in an active routing version is not recognized when you create the production order from the Planning Worksheet page.

Manufacturing

COD 7302 COD 99000854 TAB 246

228565

The Team Name (Text 30) field on the To-do table has a look-up to the Name (Text 50) field on the Team table.

Marketing

TAB 5080

220325

The Outlook add-in does not set the time correctly when the Services Default Time Zone field is set to Server Time Zone.

Sales

COD 5301 COD 5302

227182

For drop shipments, a sales order archive is not created when Blank is chosen in the Default Qty. to Ship field on the Sales & Receivables setup page.

Sales

COD 80 COD 90

224086

When an item is picked for a service order and partially shipped, all items are removed from ship bin.

Warehouse

COD 5980 COD 5988 COD 6500

分类: Uncategorized 标签:

NAV2013R2 累计更新- 48#

2017年10月29日 没有评论

 

Cumulative Update 48 for Microsoft Dynamics NAV 2013 R2 (Build 49317)

发布版本号 Build No. – 49317

发布日期 Release Date – 2017年10月

下载链接

更新项:

ID

Title

Functional area

Changed objects

225540

The analysis view budget entries are not updated when records in the G/L Budget Entries table are changed.

Finance

PAG 120 PAG 9203

225868

The bin code from the work center in an active routing version is not recognized when you create the production order from the Planning Worksheet page.

Manufacturing

COD 7302 COD 99000813 COD 99000854 TAB 246

226344

When you un-apply a payment that closed multiple invoices with payment discount, a VAT entry is missing.

Finance

COD 12

226716

When you post a sales invoice with one line with a 100% discount, the VAT amount in G/L entries for the revenue account and the discount account is zero.

Finance

COD 80 COD 90 TAB 49

227348

A VAT entry is missing in an apply scenario with a payment tolerance and the Adjust for Payment Disc. option is enabled.

Finance

COD 12

228376

An error occurs when you use the Split Line feature on a warehouse pick with more than 15 lot numbers.

Warehouse

PAG 5771 PAG 5780 PAG 7316 PAG 7376 PAG 7378 PAG 7383 TAB 5767

228564

The Team Name (Text 30) field on the To-do table has a look-up to the Name (Text 50) field on the Team table.

Marketing

TAB 5080

分类: Uncategorized 标签:

NAV2013 累计更新 – 55#

2017年10月29日 没有评论

 

Cumulative Update 55 for Microsoft Dynamics NAV 2013 (Build 49316)

发布版本号 Build No. – 49316

发布日期 Release Date –  2017年10月

下载链接

更新项:

ID

Title

Functional area

Changed objects

221273

When you post a sales invoice with one line with a 100% discount, the VAT amount in G/L entries for the revenue account and the discount account is zero.

Finance

COD 80 COD 90 TAB 49

226683

If you un-apply a payment that closed multiple invoices with a payment discount, a VAT entry is missing.

Finance

COD 12

227380

A VAT entry is missing in an apply scenario with a payment tolerance and the Adjust for Payment Disc. option is enabled.

Finance

COD 12

227906

The Team Name (Text 30) field on the To-do table has a look-up to the Name (Text 50) field on the Team table.

Marketing

TAB 5080

分类: Uncategorized 标签:

NAV2018将发布

2017年10月22日 没有评论

 

千呼万唤始出来,在之前年度10月,NAV将迎来新版本发布,但本月却并无风吹草动,终于等来MS将于2017年12月份发布NAV2018的消息, 大概率将基于现在的NAV2017FP1 版本转为NAV2018.

 

NAV2018

分类: Uncategorized 标签:

Dynamics365 Tenerife界面预览

2017年10月18日 没有评论

 

本月,MS公布了Dynamics 365 Tenerife功能与相关界面,如下:

##1.PNG

 

##2.PNG

 

##3.PNG

 

##4.PNG

 

##5.PNG

 

##6.PNG

 

从以上界面可知, PowerBI将会深度与NAV云端版本集成,在随时可以分析的数据界面,将由PowerBI驱动。

 

大家由什么感想,欢迎在QQ群/微信群中讨论。

分类: Uncategorized 标签:

NAV项目升级之Entry Dimension调整

2017年10月15日 没有评论

 

在升级项目中,由于业务的调整,伴随着需要对Entry Dimension进行调整,在早期版本中,对于Entry Dimension调整,仅需要针对Ledger Entry Dimension 和 Posted Document Dimension调整即可,但从NAV2013开始,启用了Dimension Set ID, 便不能随意进行调整,下面介绍我总结的调整方法。

 

主要包括四个方面:

1. 创建NAV早期版本的Ledger Entry Dimension等表, 不需要这些表的触发器,仅结构即可。

ID

Name

355

Ledger Entry Dimension

356

Journal Line Dimension

357

Document Dimension

358

Production Document Dimension

359

Posted Document Dimension

 

2. 执行Dimension Backup, 具体功能就是根据Ledger Entry系列表的Dimension Set ID, 获取相应的Dimension Set Entry, 将相应值重新写回到上述Entry Dimension中,涉及的表如下:

G/L Entry

Cust. Ledger Entry

Vendor Ledger Entry

Item Ledger Entry

Res. Ledger Entry

Bank Account Ledger Entry

FA Ledger Entry

Maintenance Ledger Entry

Ins. Coverage Ledger Entry

Value Entry

Service Ledger Entry

 

3. 在Entry Dimension中进行Dimension Value调整,增加/修改等。

 

4. 对Leger Entry系列表遍历,比较Dimension Set ID对应的Dimension Set Entry与Entry Dimension数据中的Dimension Value Code是否一致,如果不一致,建议将Dimension Set ID设置为0,然后用系统DimMgt管理功能生成Dimension Set ID. 代码如下:

以G/L Entry中的Dimension Set ID为例

IF "Dimension Set ID" >0 THEN EXIT;

_dimSetID := getDimSetID(DATABASE::"G/L Entry", "Entry No.");

IF ("Dimension Set ID" = 0) AND (_dimSetID <> 0) THEN
BEGIN
  "Dimension Set ID" := _dimSetID;
  MODIFY(FALSE);
END;

 

LOCAL getDimSetID("Table ID" : Integer;"Entry No." : Integer) DimSetID : Integer
tempDim.DELETEALL;
tempDim.RESET;

LedgEntryDim.SETRANGE("Table ID", "Table ID");
LedgEntryDim.SETRANGE("Entry No.", "Entry No.");
IF LedgEntryDim.FINDFIRST THEN REPEAT
  tempDim.INIT;
  tempDim.VALIDATE("Dimension Code", LedgEntryDim."Dimension Code");
  tempDim.VALIDATE("Dimension Value Code", LedgEntryDim."Dimension Value Code");
  tempDim.INSERT(TRUE);
UNTIL LedgEntryDim.NEXT = 0;
DimSetID := DimMgt.GetDimensionSetID(tempDim);

分类: Uncategorized 标签: