NAV2015 累计更新-19#

2016年5月25日 没有评论

发布版本号 Build No. 45813

发布日期 Release Date May, 2016

下载链接

更新项:

ID

Title

378793

Calculation inside a decimal field shows divided by 0 if statement 1/0.00001 is used.

378605

Caption is corrupted after you customize the ribbon.

378795

The filter-as-you-type search cannot find strings that contain character ‘]’.

378726

Accessing the Table Information virtual table is too slow if you have a lot of companies in the database.

378543

Grid layout makes page customization wrong.

378941

The Restore Defaults option that is used when you customize the Role Center page also resets the navigation pane.

379050

Data export can lead to deadlock.

378669

Dynamics NAV cannot validate date formats in the Czech version.

379038

Add-in cannot open page if the called page is modal.

378511

If you filter the Detail Trial Balance report by ">31/12/16", the entries that are posted on 31st of December are not included in the starting balance.

378102

The Debugger stops being triggered after CurrReport.SKIP.

378080

C\Side opens a new session and a new instance of the Windows client.

378943

The ListPart pages do not display on the Role Center when the UI Elements Removal option in the administration console is set to LicenseFileAndUserPermissions or LicenseFile.

379171

The new Activity buttons cannot be fully removed from the Navigation pane in the Windows client unless you choose the Restore Defaults action.

379221

Add new methods to Dynamics NAV OpenXml add-in(s).

378900

The system makes the wrong selection although you select a different record.

分类: Uncategorized 标签:

NAV2013 R2累计更新-31#

2016年5月25日 没有评论

发布版本号 Build No. 45822

发布日期 Release Date May, 2016

下载链接

更新项:

ID

Title

378763

Removing and re-creating a ribbon group removes captions.

378934

The Restore Defaults option that is used when you customize the Role Center page also resets the navigation pane.

377334

The Dynamics NAV windows client fails to connect after failover when you use a SQL Server Always On High Availability cluster unless the NST has been restarted.

378056

The Debugger stops when it is triggered after CurrReport.SKIP.

378149

Import navdata cmdlet fails.

379212

Add new methods to Dynamics NAV OpenXml add-in(s).

379168

The new Activity buttons cannot be fully removed from the Navigation pane in the Windows client unless you choose the Restore Defaults action.

379047

Excel add-in(s) crashes Excel when the server is limited during export to Excel.

分类: Uncategorized 标签:

NAV2013 累计更新-38#

2016年5月25日 没有评论

发布版本号 Build No. 45787

发布日期 Release Date May, 2016

下载链接

更新项:

ID

Title

Functional area

Changed objects

378393

No empty-element tags should be exported for SEPA according to ISO20022 rules.

Cash Management

XML 1000 XML 1010

378901

The Start balance (LCY) field on the Bank Acc. – Detail Trial Balance report is not shown.

Cash Management

REP 1404

378903

"SWIFT Code must have a value in Bank Account: No.=XXX. It cannot be zero or empty." error message when you try to export a SEPA file and you do not inform the SWIFT code in the Spanish version.

Cash Management

COD 1221 COD 1223 COD 1230 TAB 1226

378852

There is a VAT entry missing after you use the Unapply functionality.

Finance

COD 12

379040

Auto transfer from G/L leads to double cost ledger entries.

Finance

COD 1105

分类: Uncategorized 标签:

How-To设计并维护物料状态信息

2016年5月15日 没有评论

在ERP中,我们需要对系统的基础资料进行合理的管理,特别是物料基础资料,在经过数年运作后,可能我们的部分物料将呈现多种状态,如下面状态等:

呆滞/退市、不允许采购和生产

余下残次品、不允许采购和销售、生产

研发状态、不允许销售

 

那么在NAV中,我们如何合理的设计并实现这种管理呢,下面简要列举。

1. 新增物料状态表

Enabled

Field No.

Field Name

Data Type

Length

Yes

1

Code

Code

20

Yes

2

Description

Text

50

Yes

10

Purchase Orders Blocked

Boolean

 

Yes

11

Purchase Receipt Blocked

Boolean

 

Yes

12

Purchase Return Blocked

Boolean

 

Yes

13

Return Shipment Blocked

Boolean

 

Yes

20

Sales Orders Blocked

Boolean

 

Yes

21

Sales Shipment Blocked

Boolean

 

Yes

23

Sales Return Blocked

Boolean

 

Yes

24

Return Receive Blocked

Boolean

 

Yes

30

Positive Adjmt. Blocked

Boolean

 

Yes

31

Negative Adjmt. Blocked

Boolean

 

Yes

32

Transfer Blocked

Boolean

 

Yes

99

All Blocked

Boolean

 

 

2. 在物料卡片上,增加属性字段Item Status Code, 关联到上表

 

3. 在Codeunit  21 Item Jnl.-Check Line中 增加过账检测

IF Item.GET( "Item No." ) THEN BEGIN
  CASE "Entry Type" OF
    "Entry Type"::Purchase:
      CASE "Document Type" OF
        "Document Type"::"Purchase Receipt":
          Item.TestItemStatus("Item No.",’1′);
        "Document Type"::"Purchase Return Shipment":
          Item.TestItemStatus("Item No.",’3′); // Check Return Shipment blocked
      END;
    "Entry Type"::Sale:
      CASE "Document Type" OF
        "Document Type"::"Sales Shipment":
          Item.TestItemStatus("Item No.",’5′);
        "Document Type"::"Sales Return Receipt":
          Item.TestItemStatus("Item No.",’7′); // Check Return Receive block
      END;
    "Entry Type"::"Positive Adjmt.":
      Item.TestItemStatus("Item No.",’8′);
    "Entry Type"::"Negative Adjmt.":
      Item.TestItemStatus("Item No.",’9′);
    "Entry Type"::Transfer:
      Item.TestItemStatus("Item No.",’A’);
  END;
END;

 

4. 在Item表增加TestItemStatus函数,参数为物料代码和检测类型

代码如下:

// TestItemStatus(ItemNo,’01’)  <– Check for Purchase and receipt blocked

ItemStatusErrorText := ”;
StatusOk := TRUE;
IF NOT _Item.GET(ItemNo) THEN
  EXIT;
ItemStatus := _Item."Item Status";

IF NOT ItemStatus.GET("Item Status") THEN
  EXIT;

WITH ItemStatus DO
  WHILE StatusOk AND (STRLEN(CheckFor) > 0) DO BEGIN
    CASE COPYSTR(CheckFor,1,1) OF
    ‘0’: // "Purchase Orders Blocked"
       IF "Purchase Orders Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Purchase Orders Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘1’: // "Purchase Receipt Blocked"
       IF "Purchase Receipt Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Purchase Receipt Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘2’: // "Purchase Return Blocked"
       IF "Purchase Return Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Purchase Return Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘3’: // "Return Shipment Blocked"
       IF "Return Shipment Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Return Shipment Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘4’: // "Sales Orders Blocked"
       IF "Sales Orders Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Sales Orders Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘5’:  // "Sales Shipment Blocked"
       IF "Sales Shipment Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Sales Shipment Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘6’: // "Sales Return Blocked"
       IF "Sales Return Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Sales Return Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘7’: // "Return Receive Blocked"
       IF "Return Receive Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Return Receive Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘8’: // "Positive Adjmt. Blocked"
       IF "Positive Adjmt. Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Positive Adjmt. Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘9’: // "Negative Adjmt. Blocked"
       IF "Negative Adjmt. Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Negative Adjmt. Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");
    ‘A’: // "Transfer Blocked"
       IF "Transfer Blocked" THEN
         ItemStatusErrorText :=
           STRSUBSTNO(
             Text10001,FIELDCAPTION("Transfer Blocked"),
             TABLECAPTION,Code,_Item.TABLECAPTION,_Item."No.");

    END;
    IF ItemStatusErrorText <> ” THEN BEGIN
      StatusOk := FALSE;
        ERROR(ItemStatusErrorText);
    END;
    CheckFor := COPYSTR(CheckFor,2);
  END;

 

至此, 我们就添加好了物料状态检测,接下来在Item卡片PAGE/FORM上拖出Item Status Code字段,并进行数据更新即可。

 

欢迎大家到群中讨论。

分类: Uncategorized 标签:

NAV2016 累计更新-6#

2016年4月26日 没有评论

发布版本号 Build No. 45480

发布日期 Release Date Apr, 2016

下载链接

更新项:

ID

Title

378195

Data is lost after you move data to a non-compiled object.

378316

The Export Translated Profile Resources feature does not include all resources for the specified profile in the output *.resx file.

378497

JavaScript add-in crashes the Dynamics NAV client.

378519

The Dynamics NAV universal app does not work with Dynamics NAV 2015 from an iPad Pro device.

分类: Uncategorized 标签:

NAV2015 累计更新-18#

2016年4月26日 没有评论

发布版本号 Build No. 45483

发布日期 Release Date Apr, 2016

下载链接

更新项:

ID

Title

377764

When you use a SQL Server Always On High Availability cluster, the Windows client fails to connect after failover unless the NST has been restarted.

378469

"Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideRecordNotFoundException" error message and the Windows client crashes when you try to release an order.

分类: Uncategorized 标签:

NAV2013 R2累计更新-30#

2016年4月26日 没有评论

发布版本号 Build No. 45487

发布日期 Release Date Apr, 2016

下载链接

更新项:

ID

Title

378165

The Send to Excel function results in a blank Excel workbook if the Excel Add-In is disabled.

378465

"Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideRecordNotFoundException" error message and the Windows client crashes when you try to release an order.

分类: Uncategorized 标签:

NAV2013 累计更新-37#

2016年4月26日 没有评论

发布版本号 Build No. 45477

发布日期 Release Date Apr, 2016

下载链接

更新项:

ID

Title

378108

The Send to Excel function results in a blank Excel workbook if the Excel Add-In is disabled.

378257

"Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideRecordNotFoundException" error message and the Windows client crashes when you try to release an order.

分类: Uncategorized 标签:

NAV RTC之菜单配置

2016年4月23日 没有评论

在NAV 2016中,默认提供有24个角色中心, 分别按照不同的模块定制左侧菜单。

 

在此基础上,我们仍有可能需要由用户完全自定义整个系统的菜单,下面介绍定制方式。

1. 新建Page 50001  CustRC, 指定Page类型为RoleCenter. 不创建任何对象

2. 在角色管理中心中注册Page 50001, 比如命名为CustBaseRC

3. 基于CustBaseRC复制角色,比如命名为 "Accounting Manager"

4. 配置模式启动NAV, 命令行: Microsoft.Dynamics.Nav.Client.exe -configure -profile:"Accounting Manager"

5. 在角色中心上右键,自定义。完毕后保存即可。

6. 重复3-5步,依次建立多个角色

7. 设置用户角色为相应的Profile即可。

 

如果需要更改Profile, 按照第四步、第五步操作即可,在角色中心定制菜单时,亦可移除Department菜单,这样用户将只能应用设置的菜单项。

 

欢迎到群内讨论。

分类: Uncategorized 标签:

NAV2016 累计更新-5#

2016年3月25日 没有评论

发布版本号 Build No. 45243

发布日期 Release Date Mar, 2016

下载链接

更新项:

ID

Title

377345

Error occurs when you create Treeview structures.

377577

A security filter does not allow you to create new records.

377849

Extended text lines are not deleted when you delete the related sales line on the Sales Order page.

377874

Table column width is incorrect after the Word to PDF conversion.

377911

There are no permissions in the Cronus database for objects in the 12xxx range.

377949

Debugger crashes when more than one NST is running.

377950

User personalization stops saving data.

377964

Pressing the Arrow key deletes a whole line.

377989

"Microsoft.Dynamics.Nav.Client has stopped working. The user must close or debug the program" error message when you add a new link on the Registered Absences page.

377992

The Web client crashes.

378012

TreeView on subpages does not work if Dynamically Visible is not set as OnOpen (VISIBLE = variableSetToFalse).

378030

MaxNoOfXMLRecords-Setting is ignored by the Dynamics NAV client.

378033

Error occurs when you try to evaluate a record ID.

378036

OnValidate subscriptions are not called if there is no code on the OnValidate trigger.

378040

The Intellisense menu only displays the record’s fields for the FromValue when SETRANGE is used.

378059

REPORT.SAVEAS overwrites the last error text and GETLASTERRORTEXT leads to a misleading error text.

378068

iOS 9.2.1 has rendering issues in Dynamics NAV comparing to other OS and versions.

378074

Option strings are not displayed by using Intellisencse unless the field name is fully qualified through the Rec global variable.

378103

Error occurs when you send pages to Word and then save it.

378110

PerrsonalizationStore.xml file is purged after an unsuccessful connection.

378144

The client crashes when you create a note on a page that is opened through page.runmodal.

378152

Configuration-defined actions on the ribbon loose their caption when you customize them.

378154

SaveFilter throws an error when an object is saved.

378161

CU 3 and later CUs break custom Control Add-In functionality in the Web client.

378189

Normal user personalization could not be overridden if super user configuration changes.

378205

You cannot uninstall an extension with data archival if the primary key has sum index fields defined.

378210

The first parameter of the GET method is treated as a field instead of a record.

378288

Table field structure still has the AltSearchField property.

分类: Uncategorized 标签: