EMEADAXSupport, Author at Microsoft Dynamics 365 Blog

We have moved to a new blog site – http://blogs.msdn.com/axsupport/

EMEADAXSupport — Tue, 03 Jan 2012 06:26:00 +0000

Hello all viewers

Thank you for the great support you have shown us. All the blog writers in EMEA are now moving over to post on our Global Microsoft Dynamics AX Support Blog Site http://blogs.msdn.com/axsupport/.

Add this new site to your favourites and spread the word.

Best regards

EMEA Dynamics AX Technical Support Team

The post We have moved to a new blog site – http://blogs.msdn.com/axsupport/ appeared first on Microsoft Dynamics 365 Blog.

AIF: How to add extra non database field into XSD.

EMEADAXSupport — Thu, 08 Dec 2011 05:04:06 +0000

The idea is to add new extra field into schema definition and into whole AIF process but do not have this field part of table or query. It could be simple “counted” field.

For now, we will start with new table and new query. When you generate document services by wizard, make sure that Generate AxBC class is checked.

The new project is now generated. Part of this project is a class with name Ax

. This Class is inherited from AxInternalBase and there are method parm. Here you can add a new virtual method with name you want and with type you want. Datetype will be generic on in XSD (for example xs: string).

In my example I added field “Field8Extra”.

public str parmField8Extra(str _field8extra = '')
{
    return "Modified field " + testTable.Field7;
}

Now you can regenerate XSD by job file to check result.

My XSD file now have one more line with new field inside:

--author:	Karel Fischl
--ediror:	Karel Fischl
--date:	8/Dec/2011

The post AIF: How to add extra non database field into XSD. appeared first on Microsoft Dynamics 365 Blog.

New Content for Microsoft Dynamics AX 2012 : November 2011

EMEADAXSupport — Sun, 04 Dec 2011 16:04:10 +0000

One of our technical writers, Margo Crandall, has posted the list of new and updated content for Dynamics AX on TechNet and MSDN for the month of November 2011.

For a list of topics consult her blog post at http://blogs.msdn.com/b/axsupport/archive/2011/12/02/content-news-november.aspx

October 2011

September 2011

The post New Content for Microsoft Dynamics AX 2012 : November 2011 appeared first on Microsoft Dynamics 365 Blog.

New Content for Microsoft Dynamics AX 2012 : October 2011

EMEADAXSupport — Thu, 27 Oct 2011 01:19:00 +0000

Hi everyone,

Updated and new content for Microsoft Dynamics AX has been posted to TechNet and MSDN.

We have published many new topics again this month. The following table contains links to each group of topics within the post.

Audience	Approximate number of topics published
Security role reference	88
System Administrator topics	35
Application User topics	135
Developer topics	105
Topics published on both MSDN and TechNet (Reporting and Services)	35
Report Catalog topics	126
License and Configuration Key Reference	61
White papers	2

Note that for brand new sections like the Security Role Reference, we provide a link to the top-level topic. For existing sections that contain new or updated topics, we link you to specific topics.

As always, if you are curious about our general content strategy, where you can find our content, and how to give us feedback, see the post on Inside Dynamics AX: Official Dynamics AX 2012 Content.

Security Role Reference

The newly-published Security role reference contains 88 topics that describe the security roles that are available by default in Microsoft Dynamics AX 2012.

System Administrator topics

Architecture and planning

Deployment

Upgrade to Microsoft Dynamics AX 2012

Verify that you have the required permissions for installation

Clients

.NET Business Connector

Security

System maintenance tasks

Verify system settings using the Microsoft Baseline Configuration Analyzer

Enterprise Search

Application User topics

The following topics in the application user help on TechNet have been updated or added:

Common tasks

Open another company

Global address books and address reference data

Using document management

Records and record templates

Reporting and analytics

Using questionnaires

Accounts payable

Accounts receivable

General ledger

Fixed assets

About consumption depreciation

Cash and bank management

Procurement and sourcing

Human resources

Sales and marketing

Compliance and internal controls

Project management and accounting

Inventory and warehouse management

Set up dimensions display
About output orders
Change the reservation on a single order
Unpick items before loading

Product information management

Master planning

Production control

Service management

Developer topics

The following topics have recently been published or updated on MSDN.

Getting Started with Microsoft Dynamics AX

Microsoft Dynamics AX IDE

Layers

Application Object Tree (AOT)

MorphX Development Tools

Shortcut Keys: Code Editor

Microsoft Dynamics AX Debugger

Debug in Interpreted Mode Your X++ Code that Runs as .NET CIL

Database for Microsoft Dynamics AX

Tables, Views, and Maps

Data Integrity

Deadlocks

Application Object Server (AOS)

AOS Overview

Time Zone Overview and Terminology

Number Sequence Framework

Client

Forms in Microsoft Dynamics AX

Navigation Forms

Lookup Forms

Action Panes and Action Pane Strips

How to: Add an Image to an Action Pane Button

Form Classes and Methods

Methods on a Form

Controls in Microsoft Dynamics AX

Form Controls

Implementing Workflow for Microsoft Dynamics AX

Role-based Security in the AOT for Developers

X++ Language Programming Guide

Variable Names

Data Types in X++

Statements and Loops

Operators

Data Selection and Manipulation

Aggregate Functions: Differences Between X++ and SQL

Classes and Methods

Classes in X++

Methods in X++

Microsoft Dynamics AX Class Overview

Substitute Application Classes for System Classes

X++, C# Comparisons

Functions and Macros

Best Practices for Microsoft Dynamics AX Development

Enterprise Portal

Reference

Visual studio integration

Walkthrough: Adding an X++ Object to a Visual Studio Project

Xpp Reporting

Version control

How to: Set up Developer Computers for Version Control Using Team Foundation Server

Topics on Both TechNet and MSDN

The following topics have been added or updated on both TechNet and MSDN.

Services and Application Integration Framework (AIF)

Reporting

Upgrading Reports

Guidance when Upgrading Reports

Developing Reports for Microsoft Dynamics AX in Visual Studio

Working with Reporting Projects

Creating Reports Overview

Deploying Reports

Analytics

Getting started with analytics

Report Catalog

The following report topics are now available:

Accounts payable reports

Accounts receivable reports

Cash and bank management reports

Deposit summary by customer report (BankDepositByCustomer)

Fixed assets reports

General ledger reports

Home reports

Missing timesheets report (ProjMissingHourReg)

Procurement and sourcing reports

Project management and accounting reports

Sales and marketing reports

(CAN, USA) Sales analysis by invoice report (CustSalesAnalysisByInvoice_NA)

License and Configuration Key Reference

The following license code and configuration key topics are now available:

Cost accounting I license code (COSCostCenter)

Cost accounting II license code (COSOpenDim)

Unlimited Dimensions configuration key (COSOpenDimension)

Cost accounting III license code (COSIntCostAlloc)

Internal Cost Allocation configuration key (COSWorkAllocation)

Cost accounting IV license code (COSPlanCostCalc)

Flexible Budget configuration key (COSPlanCostCalc)

Electronic banking license code (BankElectronicBanking)

Financials III license code (LedgerAdvanced2)

Fixed assets license code (Asset)

Lean manufacturing license code (LeanManufacturing)

Lean manufacturing configuration key (LeanManufacturing)

Process manufacturing logistics license code (ProcessIndustriesDistribution)

Process manufacturing production license code (ProcessIndustriesManufacturing)

Production I license code (Prod)

Production Series I configuration key (Prod)

Production II license code (ProdRouting)

Production III license code (ProdShop)

Production Series III configuration key (ProdShop)

Project III license code (Project3)

Time and attendance license code (SFC1)

Time and attendance Enterprise Portal configuration key (JmgEPSFCEmployee)

Trade and logistics license code (LogisticsBasic)

Users license code (SysUsers)

White Papers

The following white papers were published in October:

Microsoft Dynamics AX 2012 “Day in the life” benchmark (CustomerSource/PartnerSource). Both detailed results and four-page summary are available.
Implementing the Global Address Book Framework for Microsoft Dynamics AX 2012 (Microsoft Download Center). This white paper has been updated since it was originally published. The updates are described fully in the paper.
Customer returns in Microsoft Dynamics AX 2009 (Microsoft Download Center)

–author:	Margo Crandall
–editor:	Margo Crandall
–date:	27/Oct/2011

The post New Content for Microsoft Dynamics AX 2012 : October 2011 appeared first on Microsoft Dynamics 365 Blog.

Unable to deploy AX 2012 default SRS reports – Error: The network path was not found

EMEADAXSupport — Thu, 13 Oct 2011 00:16:00 +0000

Problem:
Recently we ran into a strange issue where we were unable to deploy the AX 2012 default SRS reports. Attempting to do so from the AX development client or through the AX management Shell returned the error below.

The network path was not found.
If User Account Control (UAC) is enabled on the machine, close the application, right-click the application, and then click Run as administrator.

Although the error suggest the issue to be caused by not having administrative permission when deploying the reports. We found this not to be the case.

Cause:
Through taking a network trace and reviewing the source code we found the issue to be caused by the “Remote Registry Service” being stopped.

Resolution:
After starting the “Remote Registry Service” through “Start/Administrative Tools/Services” deployment of AX 2012 default SRS reports was successful.

The post Unable to deploy AX 2012 default SRS reports – Error: The network path was not found appeared first on Microsoft Dynamics 365 Blog.

How to remove notifications (EventInbox) older than one month

EMEADAXSupport — Mon, 10 Oct 2011 03:23:29 +0000

In previous post the solution was to run batch job Administration > Periodic > Notification clean-up as a part of your maintenance plan. Now we have follow up question: how to set up this batch job to remove messages older than 1 month.

To achieve it we can use static function monthRange (public static str monthRange(int relativeMonthsFrom = 0, int relativeMonthsTo = 0)) of class SysQueryRangeUtil. So now we can schedule Notification clean-up to run every month with following parameters:

It will delete all notification between 2 month ago till 1 month ago.

The post How to remove notifications (EventInbox) older than one month appeared first on Microsoft Dynamics 365 Blog.

Performance (Timeout) Problem with Microsoft Dynamics AX Enterprise Portal

EMEADAXSupport — Mon, 10 Oct 2011 02:54:16 +0000

Some time ago we got problems with performance on Microsoft Dynamics Ax Enterprise Portal. The Microsoft Dynamics AX client was working perfectly fine and the were no delays. But as soon we got to an Enterprise Portal the issue started. Enterprise Portal Role Center was opening very slowly. First of all we always advise to install following hotfix: KB 2587754: You experience slow performance when you run a request in the Enterprise Portal in Microsoft Dynamics AX 2009 Service Pack 1 to avoid that we running into the same problem.

The issue still occurred. What is strange when we had debugging disabled we got always the same error trying to enter Role Center page:

An unexpected error has occurred.
Please check the event log or contact your administrator.

And in event log:

From: Microsoft.Dynamics.Framework.BusinessConnector

Dynamics Object Adapter Call failed.
Thread was being aborted.
System.Threading.ThreadAbortException
at AxCore_Call(UInt64 , Char* , tagVARIANT* , Int32 , tagVARIANT* )
at Microsoft.Dynamics.BusinessConnectorNet.AxaptaObject.Call(String methodName, Object[] paramList)
at Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsObjectAdapter.Call(String methodName, Object[] paramList)

And:

No .NET Business Connector session could be found.
Microsoft.Dynamics.Framework.BusinessConnector.Session.Exceptions.NoKernelSessionException
at Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsSession.get_AxaptaAdapter()
at Microsoft.Dynamics.Framework.Portal.AxWebSession.WebSessionClientRemove()
at Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsSession.Release(ICacheContext context)

Followed by ASP.NET warning

Exception information:
Exception type: HttpException
Exception message: Request timed out.

What make sense, setting property debug=true in web.config cause IIS to ignore timeout settings this is why we got page up and running. What is more accessing any other page beside Role Center work very fast. After log investigation we found out that the issue was on Work List Web Part. Removing this web part allowed the Role Center to load slowly. This Web Part is used in every Role Center this is why we got into the problem every time we tried to open any Role Center.

It happens that issue was connected with the volume of table EvenInbox assigned to user (field USERID) who tried to access Role Center page. There were more than 10000 records.

Table EventInboxs contains:

– Alerts set up for user

– Workflow communication (request for approval, completion information etc)

– Errors (ie. Workflow execution errors, Project synchronization errors etc)

– Batch alerts (depended on batch job settings)

If user is administrator and a lot is happening then we can end up with lots of records in table EventInbox which leads into problems on Role Center page.

The good practice is to schedule batch job provided to clean this table which you can find: Administration > Periodic > Notification clean-up as a part of your maintenance plan to make sure it will not grow too much.

The post Performance (Timeout) Problem with Microsoft Dynamics AX Enterprise Portal appeared first on Microsoft Dynamics 365 Blog.

New Content for Microsoft Dynamics AX 2012 : September 2011

EMEADAXSupport — Thu, 22 Sep 2011 03:33:21 +0000

One of our technical writers, Margo Crandall, has posted the list of new and updated content for Dynamics AX on TechNet and MSDN for the month of September.

For a list of topics consult her blog post at http://blogs.msdn.com/b/axsupport/archive/2011/09/20/content-news-september.aspx

The post New Content for Microsoft Dynamics AX 2012 : September 2011 appeared first on Microsoft Dynamics 365 Blog.

How to reduce the file size of PDF files generated by AX 2009

EMEADAXSupport — Mon, 19 Sep 2011 01:42:00 +0000

PDF files generated from Microsoft Dynamics AX can get quite large in size. In this thread I share some hints on how you can potentially reduce the size of the generated PDF file.

Images
During PDF generation each image will be temporarily converted to a 24bit BMP file and afterwards stored as a JPG. So it does not really depend how good compressed the file is (JPG vs BMP), but the image size can make a difference. The suggestion is to keep the size (width/height) as small as possible but not smaller than the size it has to be on the document.

For example, if the size of your logo on the document is 60×20 mm then avoid using an image whose original size is, say, 240×80 mm. In this case use a logo with exactly the same size of 60×20 mm.

Compression Level
There is a parameter in the ClassDeclaration of the PDFViewer where you can set the compression level of the binary streams used for text and images within the PDF file:

#define.COMPRESSIONLEVEL(12)    //LZ77 Compression setting

As far as I could find out the levels are like this:
1 – best speed
to
15 – best compression

Setting the compression level to 15, I have observed the size to be smaller (about ~10% smaller in size). However this may slightly affect the speed of PDF generation due to the higer compression.

Using predefined PDF fonts
Embedding fonts ensures that the document will display using the fonts used to create the document. However this can cause the PDF file generated to be quite large. An alternative is to not embed any fonts but create the document using fonts that will already be available on the system where it will be viewed.

Furthermore, another alternative could be to use one of the predifined fonts during PDF generation which are supported by all PDF Viewers. This means that these fonts can be displayed regardless of being installed on the machine where the PDF file is being viewed. You do not have to embed the font (‘PDF embed fonts’ option) when generating a PDF file from AX. This later option will probably give you the smallest generated file size.

List of predefined fonts, supported by all PDF viewers

Courier
Courier-Bold
Courier-Oblique;
Courier-BoldOblique
Helvetica
Helvetica-Bold
Helvetica-Oblique
Helvetica-BoldOblique
Symbol
Times
Times-Roman
Times-Bold
Times-Italic
Times-BoldItalic
ZapfDingbats

Especially the Helvetica font might be of interest, as the Arial font is very similar to the Helvetica font. However this font is not a Microsoft Windows standard font and has to be installed separately.
If you search for the Helvetica font on the internet you be pointed to multiple site where you can buy this font.

Note
When you consider to use a predefined font then you have to do the following code change in the endReport method of PDFViewer class:

…

// Delete the fonts stored in the fontdescrs map

mapEnumerator = fontDescrs.getEnumerator();

while (mapEnumerator.moveNext())

{

font = mapEnumerator.currentValue();

//->Begin

if(font.isTrueType())

//<-End

font.deleteFont();

}

The post How to reduce the file size of PDF files generated by AX 2009 appeared first on Microsoft Dynamics 365 Blog.

A CLR error occurred while invoking the scheduling engine

EMEADAXSupport — Thu, 08 Sep 2011 09:47:00 +0000

We came across this issue recently. When running the Production Job scheduling process you experience error “A CLR error occurred while invoking the scheduling engine.” and the exception details look like this

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation —> Microsoft.Dynamics.AX.ManagedInterop.ContainerNotValidException
The Microsoft Dynamics container being referenced is not valid at Microsoft.Dynamics.AX.ManagedInterop.Container.get_Count()

The issue in this was caused by the AOS Server configuration option “Enable the hot-swapping of assemblies for each development session” being enabled on the server. This option should NOT be activated on production environments.Disabling th eoption resolved the issue

However there are other causes of production job scheduling issues, and this are mentioned in the Microsoft Dynamics AX 2012 Release Notes. One of them being: “The resource scheduling engine uses a hard-coded resource name for jobs that do not include a resource or calendar. The hard-coded resource name is “EmptyRes”. This hard-coded name might conflict with actual resource names. There is no workaround for this issue.” The solution for this is to create a new resource: “emptyres”.

The post A CLR error occurred while invoking the scheduling engine appeared first on Microsoft Dynamics 365 Blog.