存档

2015年3月 的存档

NAV2015 累计更新-5#

2015年3月31日 评论已被关闭

发布版本号 Build No. – 40262

发布日期 Release Date – March, 2015

下载链接

更新项:
——————————————————————————————————————–

ID Title
363073 The system becomes unresponsive and crashes when you rename double-byte characters to single-byte characters.
363130 The COPYLINKS function does not work for a table with DataperCompany set to No.
363294 The client is disconnected from the server with an unhandled exception (System.NullReferenceException) when you run a codeunit with a DotNet variable.
363045 The Debugger does not show some breakpoints.
363134 After switching language, not all system fields change correctly.
363447 “Unknown error” message during translation import
363466 Client Service Assemblies for Capacity Testing.
363288 Using BigInteger with AutoSplitKey fails when you try to insert a line before the first line.
363361 DelayInsert is not supported on web services.
363537 You encounter a runtime error when you save changes to an OData set in a company with 30 characters in the company name.
363535 The Windows client crashes if there is no default printer.
363423 The RUNREQUESTPAGE function is not multilanguage enabled.
362513 Applying a value to a DataItemTableView removes the actual field from the request page.
363601 “The server <servername> was unable to process the request” error message when you try to open a sales order.
361712 The Customer Statistics FactBox is not translated correctly.
361025 Wrong values exported to Excel when you use a style sheet and fields are blank.
363320 Printing Word Layout error messages are not displayed correctly.
363484 The Note View control does not display the complete note.
363485 It is not possible to change sorting in reports.
363580 If you select one record and use the Setselectionfilter command, the first record is always returned.
363553 If you use the Merge-NAVApplicationObject powershell cmdlet, the Word layout may be deleted from the resulting object.
363381 If a field with ExtendedDataType exists on a FastTab, the color of the progress bar is removed after you collapse and expand the FastTab.
361224 Icon font is not loaded for Web\Tablet client.
363603 Microsoft Dynamics NAV does not see all printers on a terminal server.
363491 Query fails when you filter on FlowFields with SQLDataType variant.
363490 The DataItemLinkReference property cannot be updated in a report.
361145 Incorrect Uri on the HelpServer will make the client crash.
363938 “‘SortTable’ kann ‘.’ nicht mehr als einmal enthalten” error message when opening Microsoft Dynamics NAV Development Environment after applying CU 4.
364362 “Microsoft Dynamics NAV Excel Add-in encountered an external error: Invalid URI: The URI scheme is not valid” error message when you try to export to Excel.
364310 Double-clicking on the AL editor line should select the current word, not the whole line.
363897 “The record that you tried to open is not available. The page will close or show the next record.” error message if any Get statement fails in the OnInsert trigger.
363867 If you specify a filter on an option string field, it will be ignored if the filter value includes an ‘&’ character when you call a page with a filtered record set.
363591 The web service does not show any error if the web service exposes a table field with BLOB.
364298 Rename-NAVCompany generates errors when you call GetDatabaseTableTriggerSetup().
364358 ISEMPTY always returns true when using Security filters.
363866 Properties works differently in different languages.
363790 Microsoft Dynamics NAV does not refresh printer information after it has started.
分类: Uncategorized 标签:

NAV2013R2 累计更新-17#

2015年3月31日 评论已被关闭

发布版本号 Build No. – 40076

发布日期 Release Date – March, 2015

下载链接

更新项:
——————————————————————————————————————–

ID Title
363240 “Microsoft Dynamics NAV Excel Add-in encountered an external error: Invalid URI: The URI scheme is not valid” error message when you try to export to Excel.
363285 The client is disconnected from the server with an unhandled exception (System.NullReferenceException) when you run a codeunit with a DotNet variable.
363248 The Save View As feature does not save filter values in some cases.
363107 The COPYLINKS function does not work for a table with DataperCompany set to No.
363072 The system becomes unresponsive and crashes when you rename double-byte characters to single-byte characters.
362855 “Unknown error” message during translation import
363349 The client crashes when you close a drill-down page.
363259 Using BigInteger with AutoSplitKey fails when you try to insert a line before the first line.
363360 DelayInsert is not supported on web services.
363446 It is not possible to create a record using an OData service.
363307 Sending PDF files with Dynamics NAV 2015 running on Azure does not work and no mails are generated.
363433 You encounter a runtime error when you save changes to an OData set in a company with 30 characters in the company name.
362493 Applying a value to a DataItemTableView removes the actual field from the request page.
363465 Client Service Assemblies for Capacity Testing
363602 Microsoft Dynamics NAV does not see all printers on a terminal server.
363392 The DataItemLinkReference Property cannot be updated in a report.
363376 If a field with ExtendedDataType exists on a FastTab, the color of the progress bar is removed after you collapse and expand the FastTab.
363380 It is not possible to change sorting in reports.
363670 If you select one record and use the Setselectionfilter command, the first record is always returned.
363432 The Note View control does not display the complete note.
分类: Uncategorized 标签:

NAV2013 累计更新-24#

2015年3月31日 评论已被关闭

发布版本号 Build No. – 40118

发布日期 Release Date – March, 2015

下载链接

分类: Uncategorized 标签:

NAV中的过账组在程序上是如何运转的

2015年3月21日 评论已被关闭

在NAV中, 我们知道业务模块与财务模块的联系纽带是过账组. 那么过账组是如何运作的, 我们可否在过账组上进行开发实现自定义功能呢? 下面以销售业务的过账组运行进行分析和介绍.

 

1. 我们首先来看销售订单的过账过程. 发货与开发票的执行都指向Codeunit 80 Sales-Post.

2. 在Sales-Post中, 首先将当前过账单据通过PostItemJnlLine() 将当前过账行创建为物料日记账待过账行.

3.  接着运行ItemJnlPostLine()过账物料日记账行.  这时转入Codeunit 22 Item Jnl.-Post Line进行过账操作.

4. 这时重点看Codeunit 22中的InvtPost在过程PostInventoryToGL()中的执行. 这时我们看到系统已经完成Item Ledger Entry的创建, Value Entry的创建. 即将进入General Journal Line的创建. 这时系统应该会要去找寻相应的过账组了.

5. 切换到Codeunit 5802, 我们看到SetAccNo(), 这里就是一系列的存货/成本相关过账组来源.

6. 我们返回到Codeunit 80 Sales-Post中, 看接下来系统的FillInvPostingBuffer(), 这里可以查看到销售收入/折扣这些的过账组来源.

7. 经过上面5/6两个步骤, 系统已经完成General Journal Line的创建. 这时的General Journal Line基本结构如下:

行1/2, 成本借贷分录

行3, 销售收入科目

行4, 客户科目. (注意, 这里的行4 如同我们平时日记账记账中的科目类型=客户一样, 这里的客户编号等于当前客户号)

8. 接着在Codeunit 80中转到Codeunit 12 Gen. Jnl.-Post Line的GenJnlPostLine.RunWithCheck. 即总帐过账操作.

9. 在Codeunit 12 Gen. Jnl.-Post Line中, 行1/2/3, 已经指定科目, 即可自动生成相应的G/L Entry. 而行4, 则通过PostCust()过程获得相应的AR科目. 同时生成相应的Cust. Ledger Entry/ Detailed Cust. Ledg. Entry / G/L Entry.

10. 以上步骤执行完毕, 则相应的日记账分录生成完毕. 这时系统还将把Sales Header/Sales Line复制为相应的Sales Shipment Header/Sales Shipment Line. Sales Invoice Header/Sales Invoice Line.

 

Tips-利用内部错误, 实现禁止用户登录到NAV中的指定公司

2015年3月10日 评论已被关闭

NAV Classic版本中, 有时我们会遇到一些未知错误, 通常原因是相应的Object异常所致. 如使用了高版本的Object(NAV5.0 用了2009Object, 2009用了2013Object). 那么我们利用此未知错误, 可以构建一个特殊功能. 即拒绝用户登录到NAV中的指定公司.

下面介绍应用方法(场景: NAV5.0 Classic)

1. NAV2009中导出一个Report.  Report 26 Setup Checklist, 导入到当前NAV 5.0数据库中, 覆盖此Object.

2. User表或[Windows Login]表中增加Deny Company.  Code类型(250字符长度)

3. Codeunit 1 ApplicationManagementCompanyOpen()函数中增加代码.

isFound := False;

if User.[Deny Company]<>” THEN Begin

Comp.SetFilter(Name, User.[Deny Company]);

if Comp.find(‘-‘) Then Repeat

   isFound := (Comp.Name = COMPANYNAME);

Until Comp.Next=0 and isFound=True;

IF isFound THEN

BEGIN

  F.MsgBox(Text800,100,Text801,16);

  REPORT.RUN(26,FALSE,FALSE);

END;

END;

4. 完毕后, 关闭NAV, 并设置用户表的Deny Company.  即可看到, 当用户打开被拒绝访问的公司时, 系统会提示不允许登录. 然后提示系统执行了非法操作. 点击后确定后系统自动关闭并退出NAV.

分类: C/AL, System 标签: