Expressions in query ranges

http://www.axaptapedia.com/Expressions_in_query_ranges

Microsoft Dynamics AX 2012 Development Introduction Certification

Microsoft Dynamics AX 2012 Development Introduction Certification/Exam is here! Exam MB6-869
Just saw this in Microsoft Learning Site.
Exam MB6-869 (Microsoft Dynamics AX 2012 Development Introduction) Released

About this Exam

This certification exam measures your ability to understand and articulate how to use, maintain, and support Microsoft Dynamics AX 2012 development functionality including understanding Microsoft Dynamics AX 2012 architecture, managing the data dictionary, managing the user interface, managing security, working with X++ control statements, managing objects and classes, accessing the database, and handling exceptions.

Exam Topics Covered
The following list includes the topic areas covered on this exam.
Understanding Dynamics AX 2012 Architecture
Managing the Data Dictionary
Managing the User Interface
Managing Security
Working with X++ Control Statements
Managing Objects and Classes
Accessing the Database
Managing Exception Handling

Find more details regarding Exam/Preparation Materials in the below link

http://www.microsoft.com/learning/en/us/exam.aspx?ID=MB6-869&Locale=en-us#tab1

Global Axapta shortcut keys

Use global Axapta shortcut keys

Printing and saving Press
To save an application object CTRL+S
To print an application object CTRL+P

Cut, copy and paste Press
To cut an application object CTRL+X (SHIFT+DEL)
To copy an application object CTRL+C (CRTL+INS)
To paste an application object CTRL+V (SHIFT+INS)

Opening... Press
Open the drop-down list for a combo-box ALT+DOWN ARROW
Open the local menu for the current field SHIFT+F10
To open the Application Object Tree CTRL+D

Closing... Press
Close the active window F4
Exit Microsoft Axapta ALT+F4
Close form ESC
Close the drop-down list for a combo-box ALT+UP ARROW

Getting Help Press
To get Help on an application object F1
To display What's this? Help on an application object SHIFT+F1

Stop method execution Press
To stop method execution (break) CTRL+BREAK

Toggle.... Press
Toggle between CTRL+SPACE
Toggle between the insert and the overwrite settings INSERT

Docking windows.... Press
Toggle the docking feature for the window ALT+F5
Move focus to the next docking window ALT+F6
Move focus to the previous docking window SHIFT+ALT+F6

Clipboard... Press
Cut the selection and put it on the clipboard CTRL+X SHIFT+DELETE
Copy the selection, and put it on the clipboard CTRL+C CTRL+INSERT
Insert clipboard contents CTRL+V SHIFT+INSERT

Find Press
Repeat the last find F3

Navigation... Press
Move the cursor one line up UP ARROW
Move the cursor one line down DOWN ARROW
Go to the top of this page CTRL+PAGE UP
Go to the bottom of this page CTRL+PAGE DOWN
Go to the start of the line/page/file HOME
Go to the end of the line/page/file END
Move the cursor one line up, and block SHIFT+UP ARROW
Move the cursor one line down, and block SHIFT+DOWN ARROW
Move the cursor one character to the left, and block SHIFT+LEFT ARROW
Move the cursor one character to the right, and block SHIFT+RIGHT ARROW
Go to the top of this page, and block SHIFT+PAGE UP
Go to the bottom of this page, and block SHIFT+PAGE DOWN

Actions Press
Cancel changes CTRL+Q
Activate the local menu from the menu bar F10
Free all data and indexes saved in the computers storage system CTRL+O

Use shortcut keys in forms to locate records

Filter functions Press
Apply the value in the current field as a filter for the current data CTRL+K
To set up a filter CTRL+F3
To clear a filter CTRL+SHIFT+F3

Locating records Press
To create a new record CTRL+N
To find the first record CTRL+HOME
To find the last record CTRL+END

Deleting records
Delete the current line CTRL+L
To delete a record ALT+F9

Use shortcut keys to navigate in forms

Field navigation Press
Open a form where the related record is selected CTRL+ALT+F4
Show the previous page of records (only effective in grids) PAGE UP
Show the next page of records (Only effective in grids) PAGE DOWN
Display the previous page of records ALT+F7
Display the next page of records ALT+F8
Restore the active record F5
Open the node in edit/view mode CTRL+SHIFT+F2
Go to the last record CTRL+END
Go to the first record CTRL+HOME
To go to first field CTRL-SHIFT-HOME
To go to last field CTRL+SHIFT+END
To go to previous field SHIFT+TAB
To go to previous tab CTRL+SHIFT+TAB
To go to next tab TAB
To go to previous group CTRL+PAGE UP
To go to next group CTRL+PAGE DOWN

Use shortcut keys in the Application Object Tree

When you want to... Press
Extend , or reduce the selection CTRL+SPACEBAR
Open AOT CTRL+D
Rename an application object F2
Save as CTRL+ALT+S
Save all CTRL+SHIFT+S
Select all CTRL+A
Filter Records CTRL+F3
Edit node CTRL+SHIFT+F2
Jump to the next error message F4
Open an application object CTRL+O
Compile an application object F7
Go to the previous node UP
Go to the next node DOWN
Move the node up ALT+UP
Move the node down ALT+DOWN
Expand the current node RIGHT
Collapse the current node LEFT
Expand the current node as much as possible Keypad *
Expand or reduce the selection CTRL+SPACE
Collapse the current node as much as possible -

Use editor shortcut keys

To make it easier and faster to use the editor, use these shortcut keys:

When you want to... Press
Save as CRTL+ALT+S
Display Field Help ALT+DOWN ARROW
Delete Delete
Select all CRTL+A
Select area ALT+A
Select columns ALT+O
Select lines ALT+L
Delete line CTRL+L
Delete to end of line CTRL+SHIFT+L
Save text as ALT+S
Insert file CTRL+ALT+H
Run a script ALT+M
Delete word to the left CTRL+BACKSPACE
Abort Tab and discard all changes since the last save F6
Abort Tab and save changes F8
Remove all breakpoints CTRL+SHIFT+F9
Insert or remove a breakpoint F9
Enable or disable a breakpoint CTRL+F9
Remove all breakpoints CTRL+SHIFT+F9
Indent selection TAB
Extend selection/remove indent SHIFT+TAB
Open Help on a class F1
Delete the previous word CTRL+BACKSPACE
Open the Find/Replace dialog CTRL+F
Find the next occurrence F3
Compile F7
Compile and close a method F8
Set and delete a breakpoint F9
Replace CTRL+R
Jump to a method CTRL+SHIFT+SPACEBAR
Mark a column ALT+O

To undo and redo Press
Undo selection ALT+U
Undo CTRL+Z (latest ten actions)
Redo CTRL+Y (latest ten actions)

To go to... Press
Specified page or line CTRL+G
Next page PgUp
Previous page PgDn
Top CTRL+HOME
Bottom CTRL+END
Start of line/page/file HOME
End of line/page/file END
One word to the left CTRL+LEFT ARROW
One word to the right CTRL+RIGHT ARROW
Previous page, and block SHIFT+PgUp
Next page, and block SHIFT+PgDn
Top, and block CTRL+SHIFT+HOME
End, and block CTRL+SHIFT+END
Start of the line/page/file, and block SHIFT+HOME
End of the line/page/file, and block SHIFT+END
One word to the left, and block CTRL+SHIFT+LEFT ARROW
One word to the right, and block CTRL+SHIFT+RIGHT ARROW
The next method CRTL+TAB
The previous method CTRL+SHIFT+TAB

To look up... Press
Breakpoints SHIFT+F9
A label CTRL+ALT+SPACEBAR
A Definition CTRL+SHIFT+SPACEBAR
Properties and methods CTRL+SPACEBAR

To list... Press
Application Objects SHIFT+F11
Extended Data Types CTRL+T
Tables F2
Classes F12
Types F4
Enums F11
Reserved words SHIFT+F2
Built-in functions SHIFT+F4

Use shortcut keys in the reportviewer

Action Press
Go there the specified page or line CTRL+G
Go to the start of the line/page/file HOME
Go to the end of the line/page/file END
Go to the start of the line/page/file, and block SHIFT+HOME
Go to the end of the line/page/file, and block SHIFT+END
Go to the previous page SHIFT+PAGE UP
Go to the next page SHIFT+PAGE DOWN
Go to the first page CTRL+ PAGE UP
Go to the last page CTRL+ PAGE DOWN
Display the previous page of records ALT+F7
Display the next page of records ALT+F8

Use debugger shortcut keys

To make it easier and faster to use the system’s debugger, use these shortcut keys:

When you want to... Press
Go to a specified page or line CTRL+G
Enable or disable a breakpoint CTRL+F9
Remove all breakpoints CTRL+SHIFT+F9
Toggle exploded or unexploded source F3
Run the debugger F5
Set or delete a breakpoint F9
Show breakpoint table SHIFT+F9
Step into F8
Step over SHIFT+F8
Step return CTRL+F8
Open or close the variables window ALT+2
Open or close call stack window ALT+3
Open or close system variable window ALT+4
Switch line numbers on/off F4

Table Inheritance in ax 2012

http://axdaily.blogspot.com/2011/04/table-inheritance.html

MICROSOFT DYNAMICS AX FAQ'S

General Overview

1. Description of your projects, the challenges you faced and how you resolved it, should be able to tell everything confidently.
2. Functionality of the Modules on which you worked.
3. Main posting classes in AP, AR, IM, Ledger modules.

FAQ’s

Data dictionary

1. What is an EDT, Base Enum, how can we use array elements of an EDT,
2. Definition and use of Maps, how AddressMap (with methods) is used in standard AX
3. What is the difference between Index and Index hint?
4. Utility and use of find method.
5. How many types of data validation methods are written on table level?
6. How many types of relations are available in Axapta, Explain each of them.
7. When the recid is generated, what is its utility, what are the different types of Table groups defined on table properties.
8. Difference between Primary & Cluster index.
9. How many kind of lookups can be made and how.
10. How can we utilize field groups in forms
11. How many types of Delete Actions are there in Standard Ax and define the use of each
12. If any record is created in table I want to fetch the date & time stamp, how will you do that
13. What is the function of super()

Classes

1.      What is an abstract class, what is the utility of an abstract method

2.      Multiple inheritance possible or not, if not how can we overcome that.

3.      What is an interface, Why do we implement it

4.      Do we need to write main method, give reasons

5.      What is difference between new & construct method

6.      What is the utilty of the RunOn property

7.      What is main class used in batch process OR which class will you inherit to make a batch job

8.       How can we make a batch job occur at regular interval

9.      What is the main utility of classes in standard Ax

10.  Which class is called when we create a SO/PO

11.  What are classes used to write query.

12.  What is a static method, why do we make static methods and where can we write it.

13.  When do we make methods private or protected.

Forms

1.      What is the basic structure of a form

2.      Utility of init(), run(), wait() methods

3.       What are different types of Link Types available in a form datasource, justify each of them

4.      Properties of a form datasource

5.      validateWrite() method can be written in form datasource as well as table level, when should we write it in form DS and when in table. Similar in case of write() method

6.      How can we call table level methods from form DS (similar methods)

7.      What is the difference between form init() & DS init()

8.      When a form opens what are the sequential methods called.

9.      Where is the best place to write code to perform filter in a form

10.  What are the different types of menu items available, explain each of them

11.  A action type menu item is attached to a form but in the drop down the menu item is not appearing, what could be the problem

Reports

1.      What are the two most important methods

2.      When do block the super() method of fetch

3.      Can we make a report from wizard, if yes from where

4.      What is a Programmable Section, how we use it in reports

5.      What is the difference between Auto Design Spec & Generated Design

6.      How can we sort the DS, what facility we can get in by placing fields in Ranges

7.      What is the role of executeSection

8.      What are Queries, how do we use them

Menu Items

1.      What is the use of Parameter, Enum TypeParameter/Enum Parameter properties of display

2.      Why do we provide Configuration key & Security key

3.      Normally what do we attach in Output

4.      Normally what do we attach in Action

General Questions

1.      What is difference between select & select firstonly statements

2.      What are the keywords used to access data from "multiple companies" and "one company to another company".

3.      How can we override a lookup

4.      How do the following methods work in a form DS.

ds.refresh(), ds.research(), ds.reread(), in what situation we should these methods

5.      On closing a form name the methods which are invoked

6.      What are security key/configuration keys, how do we use it in Ax

7.      How can we provide user level/user group level security

8.      What is a virtual company

9.      What is Visual MorphXplorer, what do we do with that

10.  What is the function of Application Hierarchy Tree

11.  If you want to monitor the database activity, where can you get that

12.  Where can we find the Label log and what is its utility

13.  What are the tools you will use to upgrade any object

14.  What is the difference between display() and edit() methods, how do we use each

      15.  What is the use of System Documentation/Application Developer Documentation/Application Documentation.

Few More Questions on DAX 

1.What are the classes,Tables,Forms and Methods used to post the sales orders.
2.What are the classes,Tables,Forms and Methods used to post the purchage orders.
3.What are the classes,Tables,Forms and Methods used to post the Ledgers.
4.What are the classes,Tables,Forms and Methods used to post the Inventory.
5.What is the base class to send the on-boad E-mailing.
6.What are the storage Dimensions?
7.What are the Item Dimensions?
      8.What is the difference between RunBase and RunBaseBatch?
9.How do you create a NumberSequence for existing Module and also fro new Module.
10.What is the difference between Insert and doinsert.
11.What is the Runbase Stack?
 

..................................................................................................................................................................

X++ code to write data to Event viewer

X++ code to write data to Event viewer.
Usually it will be difficult to monitor/debug Batch Jobs running on server . For e.g if something goes wrong than we can't find out why.
So we can make use of Eventviewer instead of infolog and monitor the status by checking the eventviewr .
Following Job illustrates how to write to event viewer.

static void Dev_Write2EventViewer(Args _args)
{
System.Diagnostics.EventLog eventlog;
Str logSource;
Str logName;
;

logSource = "Dynamics Ax";
logName = "Dynamics Ax Log";

// check if the log already exists
if(!System.Diagnostics.EventLog::SourceExists(logSource))
{
// create new log
System.Diagnostics.EventLog::CreateEventSource(logSource, logName);
}

eventlog = new System.Diagnostics.EventLog();
eventlog.set_Source(logSource);


eventlog.WriteEntry("Info Message");
eventlog.WriteEntry("Warning Message" , System.Diagnostics.EventLogEntryType::Warning);
eventlog.WriteEntry("Error! Please check the stack trace below. \n\n" +
con2str(xSession::xppCallStack()), System.Diagnostics.EventLogEntryType::Error);

info("Check the event viewer!");


}