存档

2016年5月 的存档

NAV2016 累计更新-7#

2016年5月26日 没有评论

发布版本号 Build No. 45834

发布日期 Release Date May, 2016

下载链接

更新项:

ID

Title

378244

"There is insufficient memory to execute this function" error message when you use the Reverse Register function.

378383

Merge cmdlet indicate conflicts but no conflicts are shown.

378437

The Details function always opens the first line of a list.

378547

The Copy Cell function adds double quotes to strings.

378548

Grid layout makes page customization wrong.

378670

Dynamics NAV cannot validate date formats in the Czech version.

378713

Copying a text constant into a parameter fails.

378799

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

378801

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

378802

Caption is corrupted after you customize the ribbon.

378821

Crash occurs in the development environment when you look up the Add-in method.

378845

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

378854

Inconsistent rollback behavior when failures occur during installation of an extension

378867

Possible data inconsistencies after a failed extension installation due to cache behavior

378940

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

379046

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

379062

Data export can lead to deadlock.

378751

"Unable to get property ‘get_ribbon’ of undefined or null reference" error message when you use a StandardDialog type page that has a subform in the Web client.

376933

Unlimited users can log in and active session records exist when the deleted record does not remove a user from Dynamics NAV.

377528

Converting creates a real table for event subscription instead of a virtual one.

378088

C\Side opens new sessions and new instances of the Windows client.

378101

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

378166

The FlowField Count function does not work if the SQL Data Type field is set to Variant.

378251

An add-in does not load when it is called from an Add-in event.

378361

You cannot cancel a report with an invalid filter when ProcessingOnly is enabled.

378484

Memory spike using PS cmdlet

378532

Reports are slow in connection with ClickOnce.

378899

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

378916

Add Retry logic to the Dynamics NAV application when connection to Azure SQL becomes unavailable.

378955

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

378979

Javascrip add-in(s) make the client or server crash.

379005

Exporting contact cards to Excel produces incomplete results.

379026

You cannot set a language in upgrade.

379035

[WCF Optimization] Sending a control add-in from the server to the client uses excessive bandwidth.

379042

GETVIEW(FALSE) is returning a language-dependent value for boolean fields rather than "1" or "0".

379044

Date formatting is inconsistent when you export analysis by dimensions if the regional settings are set to UK English.

379056

The "&" character is not displayed on the Caption page.

379110

Converting CU4 to CU5 rewrites the Profile table.

379131

Dynamics NAV Service tier crashes when you use a SOAP web services call with an xml file that contains whitespace or line-feed characters.

379132

Disabled menus may still be shown in the application if you disable them before installing the application.

379133

Extensions do not work if the tenant database and the application database are not synchronized.

379170

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

379194

Complex types that do not have M_AL_AutoWITH are still visible in the Intellisense global function list even though they are not compliable in CSIDE.

379195

The Number field and caption are missing on a record tooltip.

379196

Tooltip on a procedure call shows list of parameters that do not include VAR modifiers.

379216

Pages shown embedded should not control the ribbon state (expand or collapse) in the Web client.

379217

Add flexibility to ribbon-collapse rules.

379220

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

379283

The Dynamics NAV Service tier crashes when you use a SOAP web services call with an xml file that contains line-feed characters in a date-formula evaluation.

分类: Uncategorized 标签:

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 标签: