Total Pageviews

Search This Blog

Loading...

Wednesday, April 2, 2014

Troubleshooting Tip Powershell how to delete CUS Model with a space in the name

Hi All,

Greetings!

Thought to share an useful time saving tip while writing Powershell scripts. I wanted to uninstall the default CUS Model in AX 2012 from one of my local development environments. And because of the space in the model name between the words CUS and Model I got this error

For sometime, I struggled with the below error as shown below.














Solution:

However the solution was to use the escape character (grave-accent) ` which is on the left hand side of your keyboard between CUS and Model as shown above.

i.e.

Uninstall-AXModel -Model CUS` Model


Thursday, March 20, 2014

Buy One, Get One Free on all of #Packt’s 2000 eBooks!

Packt Publishing are launching an exciting campaign to coincide with the release of their 2000th title.

During this offer Packt is giving its reader a chance to dive into their comprehensive catalog and Buy One, Get One Free across their entire range of eBooks.

The campaign begins on 18th-Mar-2014 and will continue until 26th-Mar-2014. Following are the benefits readers can avail during this campaign.


  • Unlimited purchases during the offer period
  • Offer is automatically applied at checkout



Here's the Link - http://www.packtpub.com/?utm_source=referral&utm_medium=marketingPR&utm_campaign=2000thTitle


Wednesday, March 19, 2014

My notes on Dynamics AX 2012 R3 Pre-Release Event at Melbourne

Dear Friends!

Greetings, It's been a while doing some posting here.  Had been super busy. But I took some time to attend this event and thought to share some notes here.

Couple of days ago I went to attend the pre-release launch of Dynamics AX 2012 R3 here in Melbourne. Last year, Microsoft had a similar launch for R2, but it was not a full packed one. this year I was surprised to see almost more than 100 people turned up for the launch so I believe all are as excited as I am :)

I should have gone the social media way but preferred dotting some quick notes the traditional way on my laptop while the events were taking place

All in All, it was a good 2 hours event and we got to hear from Christian Pederson (General Manager of Dynamics at Microsoft)

Some of the keynotes were:

1/ The 4 Upcoming growth trends: a. Cloud Computing, b. Social media c. Mobility and d. Big Data

2/ A demo was shown on how Lotus F1 were taking advantage of Dynamics AX 2012 R3 to improve their overall factory processes in manufacturing race cars. It was good to get some knowledge on the business about how they change the car designs for each race lap, and how the computations and strategies are fed into Azure and Dynamics and ultimately how they got a better ROI

3/ Also an example was discussed about Delta airlines and how they are leveraging Dynamics AX 2012 R3 where flight attendants have windows mobile devices to take the requests and how every thing is integrated using Azure and Dynamics AX

4/ The key message was how Dynamics AX 2012 R3 can deliver amazing customer experiences through Engagement with the customer, Running Operations and finally Expansion

5/ There was an interesting note on how AX 2012 R3 + Big Data will influence the customer and Big Data is not all about external data but how we can leverage the technology for data generated internally within the organization as well

6/ There was a talk about how the future releases of Dynamics AX will come up with out of the box tools for Big Data reporting

7/ The key deliverable in R3 as what I understand from the demo is all about mobility and mobile apps. Microsoft demoed some of the out of the box apps for Expense Reporting and Shop Floor Tracking. Microsoft is encouraging to design and develop more and more mobile apps as this is where the next boom is

8/ Also another key deliverable is about the LifeCycle Services i.e. how the Project Manager, Business Analyst, Developer, Administrator can benefit from this new set of tools. For me, specifically I was interested in the System Diagnostics, Usage Profiler, Infrastructure Estimation, License Estimator tools and how they work together

9/ There was an interesting question from an audience re. the change in data model in R3 to which Microsoft confirmed there's no significant change in data model or structure in R3

To conclude, Dynamics AX 2012 R3 will be a big release in terms of development of mobile apps, Azure Deployment, Lifecycle services

I'm all excited and looking forward for the release happening in May 2014.



Sunday, February 16, 2014

Tip Dynamics AX Batch Execution and Using the NOLOCK hint to read SQL Server uncommitted data

Dear All,

Hope you are doing well.

I thought to share here a quick handy tip which I have been using for quite a while now.

Scenario:

I have a batch job running in AX which loads thousands of rows into some AX tables based on a csv/txt file. Quite often, I would like to know how many rows have been inserted into the tables.
There are many ways to get this but a quick way without much development effort is to use SQL Server Query Hint NOLOCK

Explanation:

For e.g. I'm loading some data into smmActivites table via an AX Batch and I would like to know ant any point of time how many rows have been inserted via my batch.

So, I execute the below query via SQL Management Studio

select COUNT(*) from SMMACTIVITIES WITH (NOLOCK) where DATAAREAID = 'n000'


The above statement will show me the no. of rows inserted into the table

What is the role of NOLOCK?

NOLOCK is a SQL Table hint which reads uncommitted data from database - meaning

Specifies that dirty reads are allowed. No shared locks are issued to prevent other transactions from modifying data read by the current transaction, and exclusive locks set by other transactions do not block the current transaction from reading the locked data.

You can read more about NOLOCK hint from the MSDN Documentation here http://technet.microsoft.com/en-us/library/ms187373.aspx

Note - Support for use of the READUNCOMMITTED and NOLOCK hints in the FROM clause that apply to the target table of an UPDATE or DELETE statement will be removed in a future version of SQL Server. Avoid using these hints in this context in new development work, and plan to modify applications that currently use them.

Saturday, February 15, 2014

Troubleshooting Error uploading Invoice Journals Number Sequence "0" does not exist

Dear All,

Greetings and it's been a while since I did some real posting. Had been very very busy with go live and new projects.

Recently for one of our clients, we have setup centralized payments where we raise invoice and pay them across different entities.

For one of our newly created entities, the business had an issue when do an upload of Invoice Journal.

Error: The number Sequence "0" does not exist.

Solution: I found that the issue was with the number sequence setup.









So, for e,g, in Entity B, when I go to the Number Sequence main setup form, there's a scope tab so the scope was pointing to Company A. Changed the scope and re-imported the invoice journal. Now it works like a charm!


Happy Daxing and see you around :)