存档

2016年6月 的存档

一步一步跟我实现 由Azure SQL驱动的NAV

2016年6月30日 没有评论

自NAV2016开始,支持由Azure驱动的SQL, 下面分享实施步骤与过程。

1. 移除现有NAV数据库中的所有Windows登陆帐号, 特别是Network Service帐号。 参考下面T-SQL语句

DROP USER [NT AUTHORITY\NETWORK SERVICE]
GO

 

2. 在SQL Server管理器上执行Export Data-tier Application操作.

   注意: SQL2014需要打CU8补丁,当然最佳建议还是直接用SQL2016. (SQL 2016 Developer 版本用于开发用途已经完全免费)

 

3. 使用SQL Server管理器连接到Azure SQL. 执行Import Data-tier Application操作

    注意:导入过程中有数据库类型套餐选择(小/标准/豪华),不同套餐其性能与最大容量,付费金额都不同。

   如果使用SQL Server管理器不能连接到Azure SQL, 请检查Azure SQL的安全配置 (即允许访问的IP)

 

4. 使用Dynamics NAV 2016 Administration Shell创建Azure SQL登陆密钥.

    注意:在NAV2016中使用密钥连接到MSSQL Server数据库. 如果密码发生改变,需要重新生成密码/导入密钥。

 

5. 使用Dynamics NAV 2016 Administration Shell导入第四步生成的密钥到NAV Instance中。

 

6. 配置NAV Instance数据库登陆方式为SQL 认证方式。 录入用户名/密码,保存即可。

  

7. 重新启动NAV Instance

 

至此,完成将现有的本地数据库迁移到Azure SQL, 并由Azure SQL驱动运行NAV.

 

当然,国内腾讯云亦提供MSSQL Server 2012数据库托管服务,朋友们亦可进行尝试和分享。

 

Azure SQL的好处是:

1. 伸缩架构,可以随时按需扩容, 按使用付费

2. 异地备份, 独有的Geo-Replication服务,轻松实地异地备份,特别针对跨国企业有益(不过目前异地备份的数据库可选择只读方式访问,比如核心数据库位于HK, 异地备份位于US/JP, 都可实现。

3. 数据访问Audit, 启用Audit后,对于数据库每一次变更均可进行相应审计,安全又方便。

分类: Uncategorized 标签:

NAV2016 累计更新-8#

2016年6月26日 没有评论

发布版本号 Build No. 46045

发布日期 Release Date June, 2016

下载链接

更新项:

ID

Title

376725

The Windows client has configuration instabilities during test.

377915

You cannot set the Editable property for an action dynamically with the Tablet and Phone clients.

378334

When you use the Quick Entry feature on sales order lines, the cursor jumps to the next tab.

378496

"Object reference not set to an instance of an object." error message when the Windows client crashes due to declaring a .net variable on a page that runs on the client with events.

379084

A page opens very slowly if a filter is set.

379127

A page is empty in the Web client although it has records in the Windows client.

379163

"ErrorParameterMismatch" error message when you use the Event Subscriber functions with variables of datatype records.

379216

Pages that are shown embedded on the desktop should not control the expand/collapse state of the ribbon.

379242

An OData URL with $Orderby clause crashes the service tier.

379278

The Dynamics NAV Phone client crashes.

379299

A Dynamics NAV extension only processes the first MenuSuite object if multiple are included in a package.

379379

Navsip.dll crashes Microsoft Endpoint Protection.

379381

DoS attack through WCF health service can cause NST to be unresponsive for about 10 minutes for any incoming connection.

379455

NAVX cop does not prevent adding code to actions on modified objects.

379464

The CALCFIELDS function does not work correctly with a reverse sign and permission filter.

379470

Translation error of the term Groupe prix client in the French language

379472

Code fields that have data beginning with a comma cause an error.

379480

You cannot delete the last two characters on the last line in CSIDE.

379512

The Set-NavServerUser and Set-NavSingleSignOnWithOffice365 sample scripts do not set the user object ID.

379531

Right-clicking the Go to line or the Go to definition in the C/AL Editor returns no results.

379541

"AllObjWithCaption" error message when you look up a permission.

379708

Make sure you can manage the ClientKeepAlive setting from the server.

分类: Uncategorized 标签:

NAV2015 累计更新-20#

2016年6月26日 没有评论

发布版本号 Build No. 46054

发布日期 Release Date June, 2016

下载链接

更新项:

ID

Title

378900

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

379057

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

378335

When you use the Quick Entry feature on sales order lines, the cursor jumps to the next tab.

379513

The Set-NavServerUser and Set-NavSingleSignOnWithOffice365 sample scripts do not set the user object ID.

378839

"The Company in Key does not exist. Identification fields and values: Company=’testcompany’, No.=." error message when you try to rename a company.

379675

The SaveValues function only works randomly.

分类: Uncategorized 标签:

NAV2013 R2累计更新-32#

2016年6月26日 没有评论

发布版本号 Build No. 46057

发布日期 Release Date June, 2016

下载链接

更新项:

ID

Title

379058

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

378861

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

378336

When you use the Quick Entry feature on sales order lines, the cursor jumps to the next tab.

378594

The UseFilters parameter for the GETURL function is not available.

377830

The wildcard search does not work on the Web client.

分类: Uncategorized 标签:

NAV2013 累计更新-39#

2016年6月26日 没有评论

发布版本号 Build No. 46056

发布日期 Release Date June, 2016

下载链接

更新项:

ID

Title

378318

When you use the Quick Entry feature on sales order lines, the cursor jumps to the next tab.

378478

Memory spike when using PS cmdlet

378906

Dynamics NAV crashes after the timeout.

379054

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

分类: Uncategorized 标签:

"Madeira"项目介绍

2016年6月12日 没有评论

Microsoft officially announced Project “Madeira” including a preview in the last month. a completely reinvented business management solution for small and midsize businesses (SMBs).

微软在4月12日发布了"Madeira"项目. 是服务于中小企业的完整ERP解决方案.

 

Project "Madeira" connects business processes with the productivity tools in Office 365 to help SMBs grow sales, manage finances and streamline operations. Project "Madeira" is public cloud service (Software as a Service) running on Microsoft Azure. Customers can access the service on the Web, or using apps for Windows, iOs or Android devices.

"Madeira"项目通过Office365集成,直接在线管理财务,销售. 属于运行在微软Azure上的公有云服务(SaaS模式). 用户可以在Web, App, iOS, Android设备上访问"Madeira"。

 

Project "Madeira" preview is available in the United States market today. The service is scheduled to become generally available in the U.S. during the second half of 2016, with other countries to follow.

"Madeira"项目目前在美区Office365中已经上架. 最终将在2016年中上架.

 

So what do Microsoft mean by completely reinvented? 

完整ERP解决方案的定义?

 

·A new level of productivity – Project "Madeira" reduces time wasted switching back and forth between business applications and email. It automatically identifies business context such as invoices and quote requests within Outlook, and presents the user with the tools and data needed to take immediate action – all without leaving Outlook. If you know how to use Office, then you know how to use Project "Madeira." 

生产力的新阶段 – "Madeira"项目在业务和邮件等传统业务中无缝集成大量解决时间. 自动在Outlook邮件中识别出发票/报价需求等. 接下来无需离开Outlook即可采取行动进行业务操作. 会用Office, 就会使用"Madeira"项目.

 

·Cloud first – Project "Madeira" is designed from the ground up as a true multi-tenant public cloud service on Microsoft Azure, meaning SMBs can get up and running quickly, manage costs and rest assured knowing their data is more protected in hyper-scale, enterprise-class datacenters.

云为先 – "Madeira"项目按照在微软Azure云平台下的多租户公有云服务来设计,中小企业可以快速使用,飞速运行,管理成本,对数据进行多重保护, 伸缩架构等让企业更加安心.

 

·Mobile first – Project "Madeira" is built for a mobile workforce, with a consistently great user experience across almost any device or form factor. Customers can access the service through a Web browser, or using apps for Windows, iOS or Android devices.

移动为先 – "Madeira"项目专为移动进行优化, 用户可以在任意设备上访问.

 

·Built for growth – Project "Madeira" is a comprehensive business management solution for growing companies with roughly 10 to 100 employees. These are companies that need more than the simple financial and accounting tools they started with, but aren’t yet ready to make a big investment in a customized enterprise resource planning (ERP) system.

持续提升 – "Madeira"项目适用于于10到100位员工的高速增长型企业. 企业不仅需要一套财务和会计软件, 但目前企业规模可能还没有做好对ERP的投入。则"Madeira"是最佳建议平台.

 

注: "Madeira"项目由Dynamics NAV 2016驱动, 运行于Microsoft Azure云平台。

分类: Uncategorized 标签:

快速检查含有回车符的物料

2016年6月3日 没有评论

在一次NAV项目升级中,出现物料代码中存在回车符,导致相关数据升级不成功的情况,下面简要介绍如何快速检测含有回车符的物料。

首先,创建Dataport, 并添加"No."字段到DataItem中。

 

chr13[1] := 13;

ItemNo := DELCHR("No.",’=’,chr13);

if ItemNO = "No." then

    CurrDataport.skip;

 

chr13即为回车符定义

ItemNo 为删除回车符以后的物料代码。

 

运行上面Dataport, 选择方式为Export, 即可获得存在回车符的物料列表。

分类: Uncategorized 标签: