Ax 2012 install & config exam

Hi all, managed to pass the AX 2012 installation and configuration exam last friday.  my first baby steps into the world AX

Organization Hierarchies -- Management Reporter 2012 Feature Highlight

Organization Hierarchies -- Management Reporter 2012 Feature Highlight


Great video showing how Organizational Hierarchies can be used as trees in Management Reporter 2012

Please note that the video is nothing to do with me and I am simply pointing the reader to this great vid

http://www.youtube.com/watch?v=sKHGAFa29sM

Dynamics GP 2010 Financials Exam passed

MBS-859 Microsoft Dynamics GP 2010 Financials Exam passed today, do I dare do one more? 

Dynamics GP 2013 Beta Released

Microsoft Dynamics GP 2013 Beta has been released for partners and the full product should be available by December 2012

In the Shed - Cambridge Web Design

Cambridge based company for Web Design and Practical Print Solutions. Their excellent personal touch and attention to detail is superb.

http://www.in-the-shed.co.uk/ 

https://twitter.com/in_the_shed 

Modelling of their organization for business units, and associating released products to specific Business Units

Great article about Organization Modelling

Modelling of their organization for business units, and associating released products to specific Business Units. 

http://dynamics-ax.blogspot.co.uk/2012/09/a-question-around-organization-modeling.html 

Dynamics GP 2010 Installation and Configuration exam passed

Hi all
Passed my Dynamics GP 2010 Installation and Configuration exam 

A little late but unfortunately busy schedules at work for the past few years has kept me away from the exams

MDGP 2013 Feature of the Day: Named System Database Architecture

MDGP 2013 Feature of the Day: Named System Database Architecture

T-SQL triggers on a table

 
Finding what triggers on a table using t-sql can be performed in T-SQL using the following Query

select t.*

from sysobjects s

inner join sys.triggers t on t.parent_id=s.id

where s.name = '<>'

SQLSTATE=08501 - OR - Communication Link Failure

Hi
I came across a great newsgroup response that I wished to share with others regarding SQLSTATE=08501 - OR - Communication Link Failure

http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/40eededa-752a-4445-8fa4-a023df69031f

The Active Directory user or group does not exist. Contact yout network administrator

Error when enabling a new user or group in Dynamics AX 2012: "The Active Directory user or group does not exist.  Contact yout network administrator"

Resolution
To get round the issue it appears that all fields need to be populated.  By populating the Alias field in my scenario to match the user id field it appeared to then allow me to enable the user

GP 2010 Word template issue and Office 2010

Recently got a horrible but non-intrusive error when trying to print a word template from a batch (i.e. more then one transaction).  The error presented was

Unspecified error Location: Part: /Word/header5.xml, Line: 1, column:0

Click OK 

Word Found Unreadable content in "Check Remittance~5docx".  Do you want to recover the contents of this document?  IF you trust the source of this document, click Yes.

A fantastic article from the wonderful David Musgrave helped me out

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2010/12/08/word-templates-office-2010-and-the-maintain-compatibility-option.aspx?CommentPosted=true#commentmessage

The template worked fine for one transaction but presented error when printing from a batch. The reason was because I did not mark the Maintain Compatibility with previous versions of Word option when clicking Save As

Instead of recreating from scratch I did the following:

1. Create a new report template based on the default template.
2. Export the Template to Word 2010
3. Highlight all and delete the body
4. Open a backup of my previous Word Template, highlight all and click copy
5. In the new word template paste the body into it
6. Repeat steps 3 to 5 for the Header and Footer.
7. Import the report back in and test 

This method allowed me to quickly recreated a heavily formated design without having to tell the client and my boss that I need more time.

Thank you David

Installing AX 2012 with SQL Server 2012 - Model store schema creation or update failed

When trying to install Microsoft AX 2012 on Windows 2008 R2 running SQL Server 2012 I received a problem installing the Database element

The error in the Windows Application View was as follows:

AXUtil operation failed : Schema

Model store schema creation or update failed.
　

"FASTFIRSTROW" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.

Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.


To resolve a Hotfix was required to be installed and a patch copied to the updates folder where the AX 2012 Installation files are kept. This updates the AXUtil version to 6.0.1108.152

Request and download the Dynamics AX hotfix  2680186 from Microsoft using the link below.  You will need a login to the Microsoft Partnersource website

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;2680186

VM Player - Perfect for loading 64bit OS

Using Virtual PC I was unable to load up 64 bit operating system such as Windows 2008 R2.  However using VMWare Player this was all solved and runs great.  I use this on my Apple imac to load a windows enviroment.

Download the product using the link below
https://my.vmware.com/web/vmware/free#desktop_end_user_computing/vmware_player/4_0

Trying to load Windows R2 on a new VMWare Image

I received the following error whe trying to load Windows R2 on a new VMWare Image

The buslogic SCSI adapter is not supported for 64-bit guests in this release. Please consult the documentation for the appropriate type of SCSI adapter to use with 64-bit guests.
Failed to configure virtual device scsi0.

The problem was due to me having a default image created as Windows XP so already a 32bit. 

To correct I setup a new image and specified the Windows R2 Standard as the operating system.

Free E-Books

Hi
A number of free e-books have been made available and collated by Eric Ligman of the MSDN Blog.  Please take a look at the MDSN links below

http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx

http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/30/another-large-collection-of-free-microsoft-ebooks-and-resource-kits-for-you-including-sharepoint-2013-office-2013-office-365-duet-2-0-azure-cloud-windows-phone-lync-dynamics-crm-and-more.aspx?wa=wsignin1.0

Failed to decrypt protected XML node DTS:Password with error 0x8009000B

Unable to use a SQL job to execute a package designed in SSIS however it runs fine in Integration Services.  It reports the following error:
"Error Loading <>.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".  You may not be authorized to access this information.  This error occurs when there is a cryptographic error.  Verify that the correct key is available "

Problem was due to the username set against the SQL Server Agent being different to the username used to designed the SSIS package.  To resolve this we left the Package default protectionlevel to "EncryptSensitiveWithUserKey".  When adding the SQL Server agent job we should set the protection level to be "Rely on Server Storage and roles for access control"

The following website was an excellent resource and help me understand the error:

http://www.mssqltips.com/sqlservertip/2091/securing-your-ssis-packages-using-package-protection-level/

eConnect - There was an error writing to the pipe: Unrecognized error 232 (0xe8) when importing

eConnect error: There was an error writing to the pipe: Unrecognized error 232 (0xe8) when importing

Resolution:

Add receiveTimeout="infinite" to the Microsoft.Dynamics.GP.eConnect.Service.exe.config file for the eConnect Integration service.

The binding section should resemble this:

Data type STR15 does not exist in the dictionary. Parameter name: datatypeName

I received the following error whe launching Dynamics GP 2010 R2 SP3 for the first time after upgrading from Dynamics GP 10 SP 5

".DLL: Data type STR15 does not exist  in the dictionary.  Parameter name: datatypeName"

It turns out my non-upgraded forms and reports were causing this issue. 

1. Remove FORMS.DIC and REPORTS.DIC not yet upgraded
2. Launch Dynamics GP 2010 and register etc
3. Upgrade Forms and reports using Dynamics Uttilites

or
1. Upgrade Forms and reports using Dynamics Uttilites
2. Launch Dynamics GP 2010 and register etc

Advanced ODBC Source - IM 11

Recently I had pulled my hair out with the issue of using Advanced ODBC in Integration Manager 11.   A client we were performing an upgrade to GP2010 for had an integration setup to pull in data from a CSV file and the update did not seem to work correctly for this source and had to be updated again.

An external system was creating unchangeable CSV files which was then used to create sales transactions in Dynamics GP 2010 The nature of the text file meant that a grouping of data was required for the header source and a sum of an amount column.

Sample file
InvoiceNo, description, Amt1,Amt2
100,sales 1,100.00,0.00
100,sales 1,55.00,0.00
101, sales 2, 88,76,10

The result of previewing the file should return the following results

InvoiceNo, description, Net,VAT
100,sales 1,155.00,0.00
101, sales 2, 88,76,10

Using the Advanced Query I was unable to build a query with the Query Builder.  The advise is to not bother if you are pulling from a text driver. 

I have found the following rules apply
1. Simply enter the query in the SQL Statement field
2. save changes and then preview

SSIS - Error Column "XXX" Cannot convert between unicode and non-unicode string data types

When building an SQL Server Integrastion Services package to import data from AS400 Database to SQL Server 2008 database I receive an error

"Error Column "XXX" Cannot convert between unicode and non-unicode string data types"

Create data conversion specify column, add new column alias (i.e. new column name).  Be sure to specify enough length.

Afterwards remap to new Output alias in the destination

SSIS - Could not open global shared memory to communicate with performance DLL

When testing my SSIS package I received the following message:

Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.  To resolve, run this package as an administrator, or on the system's console.

My package takes data from one source to a database destination using SQL Server Destination.

I corrected this by using OLE DB Destination instead of SQL Server Destination as my target detination object. 

MCTS: Microsoft SQL Server 2008, Implementation and Maintenance

Passed the 070-432 Microsoft SQL Server 2008, Implementation and Maintenance exam today. Next step upgrade to SQL 2012 at the end of the year

http://www.microsoft.com/learning/en/us/certification/cert-sql-server-mcsa.aspx

Generating a new GUID value for insert

The other day I needed to insert some records into a table but I received an error on a column called GUID.  This unique reference column required a value similar to the following: 1A2BBCA2-7D80-4F34-9EDF-025203A721A3. 

For a 100 records what on earth was I going to enter.  With a bit of searching on internet I found that using the command newid() allowed me to create new value (Thank you Devx.com http://www.devx.com/tips/Tip/13951)

So for example

insert into tableA
select newid(), column 1, column 2 from tableB

Dynamics GP 2010 SP 3 is now available

Dynamics GP 2010 SP 3 is now available to download.  Becareful if you download the EConnect SP 3 for 32bit it has a problem with the link and will actually download SP 3 Webservices

VAT DayBook reporting VAT amounts for EU transactions using 0% Tax Detail ID after upgrade to GP 2010 R2

After a client upgraded to GP 2010 they noticed that the VAT DayBook was reporting VAT amounts for EU transactions using 0% Tax Detail ID.  This was of course incorrect and required this fixed.

Resolution
This was a problem with GP 2010 R2 core and was fixed by applying Hotfixrollup 2682502 taking the version to 11.00.1935(SP2)

Cached SID of Old Windows Domain User Account

My company has a web application that utilises windows authentication in order to validate users.  This offers a quick method of end users to become authorised without the burden of remembering muliple passwords.  The other day a client contacts me saying that when they launched the web application a different user name was being displayed to the windows domain user account logged in.

So for example Bertie wooster would login to the workstation with domain user account Corpdomain\bertiewooster.  When they launched the application started up it stated it could not find the login for Corpdomain\jeeves.

Running Excel Data connections and also ODBC administrator (testing data source) presentd the same issues and so it was not an application issue but the way windows was viewing the current logged on windows domain user account

Cause
The client using this particular software had a process of renaming the windows domain user account each time a new end user joined the company.  The windows domain user account will be renamed from the old domain user account to the new domain user account instead of creating a new account.   So in our example Corpdomain\jeeves had left the company and Corpdomain\bertiewooster took over.

New workstations did not experience the problem but if the previous end user had logged onto the machine previously then this problem would be apparant. So the problem appeared to be profile related and a Cached SID.

Problem seen on Windows XP and Windows 2003 servers.  We do not seem to experience the issue on Windows 2008 servers and Windows 7.

Workaround
To correct the issue the following was performed:

1. Remove for the windows profile created fo rthe previous domain user name

2. Remove the registry entry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\xxx (replace xxx with the key for the user

In some cases running point 1 was enough to correct the issue.

Negative amounts display #NAME? in Smartlist export

An end user the other day stated that a Dynamics GP Smartlist Builder report that was not exporting data for some rows.  Negative amounts were displaying #NAME? in Microsoft Excel.

To correct the issue for each Amount field I changed the properties in thge Field Optons window (Click Blue arrow next to field to open).  I then unmarked the Show currency Symbol and Show Thousands Separator fields in the Display tab.

Unable to cast COM object of type 'System.__ComObject' to interface type 'System.EnterpriseServices.IRemoteDispatch'

Users were receiving the following error when submitting a transaction in a econnect application.

Unable to cast COM object of type 'System.__ComObject' to interface type 'System.EnterpriseServices.IRemoteDispatch'.

This operation failed because the QueryInterface call on the COM component for the interface with

IID '{6619A740-8154-43BE-A186-0319578E02DB}' failed due to the following error:

Illegal operation attempted on a registry key that has been marked for deletion. (Exception from HRESULT: 0x800703FA).

Reviewing the systems event log we also saw the following error

The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

{46063B1E-BE4A-4014-8755-5B377CD462FC}

and APPID

{FAAFC69C-F4ED-4CCA-8849-7B882279EDBE}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

To correct the problem IISRESET works but the problem then comes back after a while.  We have added the Network Service to have local launch permission for the APP ID

{FAAFC69C-F4ED-4CCA-8849-7B882279EDBE} which is MsDTSServer100

Dynamics GP 2013 New Features

Dynamics GP 2013 New Features

•Excel Export Using Open XML

• Enable printing of SSRS report from forms

• Navigation Lists for Web Client (BA Functionality)

• Re-architect home pages to WPF

• New SSRS reports to support Web Client templated forms

• Business Analyzer WPF upgrade

• Additional Word Templates for SOP

• Single Email with multiple attachments

• SRS Reports

• Print Customer Items option

• Select invoice on one-off Email window

• Notes on Credit Documents

• Document Attach

• Item Standard Cost adjustment post to GL

• Multi-S/N select

• Inactivate a Site and Item Site

• Reason Codes for stock movements/adjustments

• Inactive Items - Inventory Status enhancements

• Bin Transfer History

• Tolerance Handling

• Track Serial Numbers for Drop Ship items

• Allow prepayments on a PO

• Prevent PO close prior to Invoice Match

• Print Button on Pick List Shortage Inquiry

• Ship to Address has different Company Name

• Relate / Link Items for suggestions on Sales

• Integrate AA with Copier Series SOP/POP and GL Copy

• Add Field Service Allocations to Item Allocation Inquiry Window

• Update Back Order Quantity in Item Maintenance

• RMA Entry - Update Contact & Address ID

• Consolidate Revenue Recognition

• Item Description from RMA Credit

• Multi-User check in RMA Entry

• Equipment Super Session

• Hotline Update

• RMA Return Quantity and Type

• Ship to Address Integration to SOP

• Cross Ship RMA consolidation

• Honor Discontinued Item Status

• Auto Populate Customer ID

• Add a Contract Number search in Revenue recognition window

• Allow contract line to be moved to another contract even if on an open service call

• Option to have an equipment card created when manufacturing receives a serialized item into inventory

• Contract Workflow

• Add BAI2 format support to eReconcile

• FA Calendar Setup

• FA Intercompany Asset Transfer

• FA Historical Depreciation Report

• Lock Current FA Year and Mass Backout

• FA to GL posting process updates

• FA Updates for MACRS

• Integrate Fixed Assets with AA

• GL Journal Entry Inquiry for History

• Reconcile Bank Reconciliation with GL

• Year End Close Options

• Subledger Reconcile IV to GL

• Calculate Average Exchange Rate for Currency Translation

• Integrate GL with encumbrance

• Enable Enc to assign Multiple GL Budgets for Fiscal Year

• Encumbrance Cost Diff Notification

• Restrict Void of reconciled check, display reconcile status in Check Inquiry

• Void of check returns applied Credits

• Void credit card payment vendor invoice - void to original vendor

• EFT add settlement date option

• EFT Field Length and Delimitation Options

• Edit Payables Transactions: Remit to Address, 1099 information, Edit Description

• PM Reprint Checks/Remittance forms

• Need a 1096 Form

• Allow renaming of user-defined fields on Customer Address

• Multicurrency apply in cash entry

• Database multi-tenancy (named system database)

• Application multi-tenancy

• Report deployment and retrieval for multi-tenant

• Multi-tenant Applications - tenant service

• Multi-tenant Integration Manager

• Multi-tenant web service

• Life Insurance enhancements

• Check Build Exception Report

• Stop Duplicate Checks

• Paycode History Edit

• Paycode, Deduction, Benefit Modifier

• FICA TSA Deductions

• Customer Fields

• Advanced Warning Notice and Delete History Records

• Mandatory Arrears Template and Reminders

• DIA Reporting

• Voucher Description and Voucher Document Number

• Voucher Consolidation

• HR Calendar

• Negative Carryover

• PTO Detail and History

• PTO Manual Checks

• Year End PTO

• Office Presence in Advanced HR, Advanced Payroll, Payroll Extensions & PTO Manager

• HR Requisition List View

• Consolidated Invoicing

• Additional String Resources (Dex)

• Key Relations tracked in index file for source control(Dex)

• Update VBA Components

• Enhance the AltMod windows with a mark all/unmark all functionality

• 64 Bit Support for Email (Dex)

• Default sort for Customer and Vendor lookups

•Email Indicators in Transaction lists

•Save batch approval information

•Select Printer at time of print AND Support for http:// on the Report Destination window

•Adding support for the Business Analyzer to NLB

•Grouped Reports

•SmartList Builder - remove dependency on having an Admin login after new install

•Extender Window export/import to include Smartlist integrations

•Add Extender & SmartList Builder Default Security

MR Report stuck in Report queue - startIndex cannot be larger than length of string

Management Report 2012
Trying to generate a report copied over from FRX 6.7 I experienced a problem.  What was happening is that the report would sit there stuck with a status of queued.  Looking in the event viewer application log on the server I saw the following error

System.ArgumentOutOfRangeException: startIndex cannot be larger than length of string.
Parameter name: startIndex
   at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.Row.HandleRelatedRow()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.Row.Load(XElement element)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.RowFormat.DeserializeRows(XElement xElement)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.RowFormat.Load(XElement element)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.ComponentKeyedCollection`2.Load(XElement element)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.Load(XElement element)
   at Microsoft.Dynamics.Performance.Reporting.Scheduler.ReportRunner.RunReport(String reportDefinitionXml, Guid repositoryId, Guid generatedByPrincipalId, Guid reportFileId)

No idea so took a smaller sample of the report and this work.  so I slowly added sections of the report until I found the problem.

The error was appearing due to two of the rows in the report contained a tree reference in the Related Formulas/Rows/Units  but had no reference in the Link to Financial Dimensions column
Once I removed the tree reference and changed the rows to be DES  type (so that the client could map the information at a later date), it then worked

Wrong number of parameters sent to script 'eiPROC_SOP_DP_Update_Header_Sub1'

An old problem came to revisit me today.  A client running Dynamics GP 10 Service Pack 5 (1685) was experiencing the following issue when printing Dispatch Notes for more then one sales order using the Navigation List window. 

Unhandled script exception:
Wrong number of parameters sent to script 'eiPROC_SOP_DP_Update_Header_Sub1'.

EXCEPTION_CLASS_SCRIPT_BAD_PARAM
SCRIPT_CMD_CALL


The problem is experienced when then client is setup to use Enhanced Intrastat.  A call logged with Mcirosoft previously stated that it had been fixed in Dynamics GP 10 SP5 and also Dynamics GP 2010 SP1.  It appears even with latest hotfix 10.00.1835 it is also still an issue.

I have now told the client to use the Print Sales Documents window in order to print multiple documents and abandon the new features they liked in Dynamics GP 10.  Not every one can afford the time to upgrade to the latest version

kind regards
Michael Nunes

Play Capoeira

Play Capoeira
Saturdays 11:30am - 13:00

www.PlayCapoeira.co.uk

In Cambridge there aren't many classes where you can get fit, learn a new language, brush up on your singing skills and play an instrument all at the same time. Play Capoeira is open to all ages and aims to connect and inspire people through the philosophy of Capoeira, an exhilarating and elegant dance, fight, game from Brazil.
The Bodywise Studio
Unit 4 Dales Brewery
Gwydir Street (off Mill Road)
Cambridge CB1 2LJ
Classes cost £5 For more information call Richard on 07878 093830  #Cambridge #Capoeira