存档

‘Uncategorized’ 分类的存档

如何在NAV2016代码编辑器中使用Symbol Menu

2016年7月30日 没有评论

在NAV2016中, 启用了可折叠,智能提醒的全新代码编辑环境,但很多时候, 我们还是希望使用F5引入代码。

 

那么如何实现呢? 在finsql.exe 启动参数中, 添加 useoldeditor=yes

这时,再次启动编辑器将返回到传统classics开发环境中。就可以继续使用F5引入代码。

分类: Uncategorized 标签:

如何在NAV2016中沿用Dataport进行数据交换

2016年7月22日 没有评论

众所周知, 从NAV2013开始, 取消了原来Classics版本中的Dataport, 而官方建议使用xmlport 或 Rapid Start Service. 那么, 我们如何使用熟悉的Dataport进行数据交换呢?

请各位跟我操作, 使用熟悉的csv文本交换格式输入/输出客户数据.

1. 在NAV2016中, 启动开发环境, 创建xmlport 50001, 命名为 customer list

2. 进入xmlport属性设置, 选择Format为 Variable Text, TextEncoding 为 UTF-8 (这个在多语言符号处理中请务必选择) Direction 选择 Both ( 或者限制仅导出 export, 仅导入 import)

下面的4个选项, 可能用过Dataport的就很熟悉了

FieldDelimiter

<">

字段值间隔符 (默认使用 双引号 )

FieldSeparator

<,>

字段分隔符 (默认使用 逗号)

RecordSeparator

<<NewLine>>

记录分隔符 (默认使用 换行符)

TableSeparator

<<NewLine><NewLine>>

表分隔符 (默认使用 两个换行符)

3. 进入节点编辑.

首行, 请按照下表样式录入. 用于声明文件头信息 (默认xmlport 使用xml, 则需要强制为Root)

Node Name

Node Type

Source Type

Data Source

CustList

Element

Text

 

接下来, 第二行开始, 录入

Node Name

Node Type

Source Type

Data Source

Cust

Element

Table

请选择客户表

注意, 录入完毕第二行后, 请将此行下移一级, 表示从属于CustList节点.

录入完毕后, 在此节点上进行属性设置. 传统的dataport选项AutoSave / AutoUpdate 均可在此按需设置

再往下, 就是字段录入了.

Node Name

Node Type

Source Type

Data Source

No.

Element

Field

请选择 No. 字段

字段全部录入完毕后, 请将字段全部下移一级, 表示从属于Cust表节点.

4. 保存xmlPort, 接下来直接点击Run 运行, 在弹出的RTC客户端中选择 Direction 为 export. 确认后, 系统将弹出文件名保存对话框

5. 打开保存的文件名, 熟悉的dataport 输出数据即完成.

6. 导入数据操作方法和之前一致, 不过在节点Cust上注意选择属性, 确定导入数据的方法.

分类: Uncategorized 标签:

一步一步跟我实现 由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 标签:

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