1. Difference between
following
condel :Use
condel to delete
one or more items from a container.
confind :Use
confind to locate a
sequence of items in a container.
conins :Use
conins to insert
some items into a container.
conlen :Use
conlen to find out
how many items there are in a container.
connull :Use
connull to
explicitly dispose of the contents of a container.
conpeek :Use
conpeek to extract
an item from a container, and to convert it into another data
type
conpoke :Use
conpoke to replace
(poke) an item in a container.
2. Difference between
edit and display method
Display Indicates
that the method's return value is to be displayed on a form or a report.
The value cannot be
altered in the form or report
Edit Indicates that
the method's return type is to be used to provide information for a field that
is
used in in a form.
The value in the field can be edited.
3. Difference between
perspectives and table collection
Perspectives can
organize information for a report model in the Application Object Tree (AOT).
A perspective is a
collection of tables. You use a report model to create reports.
Table collection is
a collection of table, which sharing across all the virtual companies.
4. What are the 4 types
of files we need to copy to the standard folder?
*.aod application
object data file
*.ahd Application
Online Help Data
file
*.ald Application
Label data file.
*.add Application
Developer
Documentation Data file
*.khd Kernel
Online Help Data
And other files are
*.ahi Application
Online Help Index
files
*.adi Application
Developer
Documentation Index files
*.ali Application
Label Index files
*.alt Application
Label Temporary
file.
*.alc Application
Label Cache file
*. aoi Application
Object Index file
*.khd Kernel
Online Help Data
*.khi Kernel
Online Help Index
files
5. Why we use virtual
companies?
Virtual company
accounts contain data in certain tables that are shared by any number of
company accounts.
This allows users to post information in one company that will be available to
another company.
6. How can we restrict
a class to be further extended?
using Final Keyword
for ex: public final class <ClassName>
7. Which classes are
used for data import export?
SysDataImport and
SysDataExport
8. From which table u
can get the user permissions stored in Ax?
AccessRightList
table.
9. What should we do if
we need last record to be active when a form is opened?
In properties of
datasource table set the StartPosition property as last.
10. What is the
sequence of events while a report is generated?
Init, Run, Prompt,
Fetch, send,Print
11. Name few X++
classes/Coreclasses related to Queries?
Query, QueryRun,
QueryBuildRange, QueryBuildDataSource, QueryBuildLink
12. What is an index?
An index is a
tablespecific
database structure
that speeds the retrieval of rows from the table.
Indexes are used to
improve the performance of data retrieval and sometimes to ensure the
existence of unique
records.
13. Define IntelliMorph
IntelliMorph is the
technology that controls the user interface in Microsoft Dynamics AX. The user
interface is how
the functionality of the application is presented or displayed to the
user.
IntelliMorph
controls the layout of the user interface and makes it easier to modify forms,
reports,
and menus.
14. Define MorphX
The MorphX
Development Suite is the integrated development environment (IDE) in Microsoft
Dynamics AX used to
develop and customize both the Windows interface and the Web interface.
15. Define X++
X++ is the
objectoriented
programming
language that is used in the MorphX environment .
16. Differentiate
refresh(),reread(),research(),executequery()
refresh() will
not reread the record from the database. It basically just refreshes the screen
with
whatever is stored
in the form cache.
reread() will
only reread
the CURRENT record
from the DB so you should not use it to refresh the
form data if you
have added/removed records. It's often used if you change some values in the
current record in
some code, and commit them to the database using .update() on the table,
instead of through
the form datasource. In this case .reread() will make those changes appear on
the form.
research() will
rerun the existing form query against the data source, therefore updating the
list
with new/removed
records as well as updating existing ones. This will honour any existing
filters
and sorting on the
form.
executeQuery() is
another useful one. It should be used if you have modified the query in your
code and need to
refresh the form. It's like
research() except
it takes query changes into account.
17. Define AOT
The Application
Object Tree (AOT) is a tree view of all the application objects within
Microsoft
Dynamics AX. The
AOT contains everything you need to customize the look and functionality of a
Microsoft Dynamics
AX application
18. Define AOS
The Microsoft
Dynamics AX Object Server (AOS) is the secondtier
application server
in the
Microsoft Dynamics
AX threetier
architecture.
The 3tier
environment is
divided as follows:
• First Tier –
Intelligent Client • Second Tier – AOS • Third Tier – Database Server
In a 3tier
solution the
database runs on a server as the third tier; the AOS handles the business
logic in the second
tier. The thin client is the first tier and handles the user interface and
necessary
program logic.
19. Difference between
temp table and container.
1. Data in
containers are stored and retrieved sequentially, but a temporary table enables
you to
define indexes to
speed up data retrieval.
2. Containers
provide slower data access if you are working with many records. However, if
you
are working with
only a few records, use a container.
3. Another
important difference between temporary tables and containers is how they are
used in
method calls. When
you pass a temporary table into a method call, it is passed by reference.
Containers are
passed by value. When a variable is passed by reference, only a pointer to the
object is passed
into the method. When a variable is passed by value, a new copy of the variable
is
passed into the
method. If the computer has a limited amount of memory, it might start swapping
memory to disk,
slowing down application execution. When you pass a variable into a method, a
temporary table may
provide better performance than a container
20. .What is an EDT,
Base Enum, how can we use array elements of an EDT?
EDT To
reuse its
properties. The properties of many fields can change at one time by
changing the
properties on the EDT. Relations can be assigned to an edt are known as Dynamic
relations.
EDT relations are
Normal and Related field fixed.
Why not field fixed
– field fixed works on only between two tables 11
relation. And
Related field
fixed works on
1many
tables.so edt uses
related field fixed.
BaseEnum which
is a list of
literals. Enum values are represented internally as integers.
you can declare up
to 251 (0 to 250) literals in a single enum type. To reference an enum in X++,
use the name of the
enum, followed by the name of the literal, separated by two colons . ex NoYes::
No.
21. Definition and use
of Maps, how AddressMap (with methods) is used in standard AX?
Maps define X++
elements that wrap table objects at run time. With a map, you associate a map
field with a field
in one or more tables. This enables you to use the same field name to access
fields
with different
names in different tables. Map methods enable to you to create or modify
methods
that act on the map
fields.
Address map that
contains an Address field. The Address map field is used to access both the
Address field in
the CustTable table and the ToAddress field in the CustVendTransportPointLine
table
22. What is the
difference between Index and Index hint?
Adding the
"index" statement to an Axapta select, it does NOT mean that this
index will be used
by
the database. What
it DOES mean is that Axapta will send an "order by" to the database.
Adding
the "index
hint" statement to an Axapta select, it DOES mean that this index will be
used by the
database (and no
other one).
23. How many types of
data validation methods are written on table level?
validateField(),validateWrite(),validateDelete(),aosvalidateDelete(),aosvalidateInsert(),
aosvalidateRead(),aosvalidateUpdate().
24. How many types of
relations are available in Axapta, Explain each of them.
Normal Relation: enforce
referential integrity such as foreign keys. For displaying lookup on the
child table.
Field fixed: works
as a trigger to verify that a relation is active, if an enum field in the table
has a
specific value then
the relation is active. It works on conditional relations and works on enum
type
of data.
ExDimension
table
Related field
fixed: works as a filter on the related table.it only shows
records that match the
specified value for
an enum field on the related table.
25. When the recid is
generated, what is its utility?
when the record is
entered in the table the recid is generated by the kernel.it is unique for each
table.
26. Difference between
Primary & Cluster index.
Primary index: It
works on unique indexes. The data should be unique and not null. Retrieve data
from the database.
Clustered Index: It
works on unique and non unique indexes.retrieve data from the AOS.
The advantages of
having a cluster index are as follows:
Search
results are quicker when records are retrieved by the cluster index, especially
if
records are
retrieved sequentially along the index.
Other
indexes that use fields that are a part of the cluster index might use less
data space.
Fewer
files in the database; data is clustered in the same file as the clustering
index. This
reduces the space
used on the disk and in the cache.
The disadvantages
of having a cluster index are as follows:
It
takes longer to update records (but only when the fields in the clustering
index are
changed).
More
data space might be used for other indexes that use fields that are not part of
the
cluster index if
the clustering index is wider than approximately 20 characters).
27. How many kind of
lookups can be made and how.
By using table
relations
Using EDT
relations.
Using morphx and
using X++ code(Syslookup class).
28. How many types of
Delete Actions are there in Standard Ax and define the use of each
None
Cascade
Restricted
Cascade+Restricted.
29. If any record is
created in table I want to fetch the date & time stamp, how will you do
that?
30. What is the
function of super()
This method calls
the system methods to execute.
It is used to
instantiating the variables at the parent class. Used for code redundancy.
31. Utility and use of
find method.
All the tables
should have at least one find method that selects and returns one record
from the table that
matches the unique index specified by the input parameters. The last input
parameter in a find
method should be a Boolean variable called for update or update that is
defaulted to false.
When it is set to true, the caller object can update the record that is
returned by
the find method.
32. What are the
different types of Table groups defined on table properties?
Miscellaneous
Parameter
Group
Main
Transaction
WorkSheetHeader
WorkSheetLine
33. Multiple
inheritance possible or not, if not how can we overcome that.
In X++, a new class
can only extend one other class; multiple inheritance is not supported. If you
extend a class, it
inherits all the methods and variables in the parent class (the superclass).
We can use Interfaces
instead of multiple inheritance in Ax.
34. Do we need to write
main method, give reasons
Yes, but to open
the class from action menu item we have to create main method of class.
35. What is difference
between new & construct method
new(): used
to create a memory to the object.
Construct(): You
should create a static construct method for each class. The method should
return an instance
of the class.
36. What is the utility
of the RunOn property
Application objects
such as reports, tables, and methods can run on the application object server
(AOS) or the
client. An object can also have the RunOn property
value set to Called from. Objects set
to Called
from can run from either the client or server, depending on where the
object is called
from. This topic
describes the RunOn property, tiers that class objects
can run on, and hints about
using AOSRunMode.
Default value of RunOn
for Classes Called
from
MenuItems Client
37.What
is main class used in batch process OR which class will you inherit to make a
batch job
RunBaseBatch class
38. How can we make a
batch job occur at regular interval Using
RunbaseBatch
39. What is the main
utility of classes in standard Ax For
business logic
40. Which class is
called when we create a SO/PO.
SalesFormLetter and
PurchFormLetter
41. What is the basic
structure of a form
Methods,DataSources,Design.
42. Properties of a
form datasource
Name, Table, Index,
AllowCheck, AllowEdit, AllowCreate, AllowDelete, StartPosition,JoinSource,
LinkType.
43. 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
when we want the
validation at the table level means in every form where this table is uses, we
can write at the
table level.
If we want
validations at the particular form and it doesn’t effect to the other forms
where this
table was used, then
we can use form level validations.
44. How can we call
table level methods from form DS (similar methods)
By creating the
variable to the table and with tablevariable.methodname()
45. What is the
difference between form init() & DS init()
Form init(): init
is activated immediately after new and creates the runtime
image of the
form.
DS init(): Creates
a data source query based on the data source properties.
The form data
source init method creates the query to fetch data from the database and sets
up
links if the form
is linked to another form.
46. When a form opens
what are the sequential methods called.
Form init(),
DataSource init(), Form run(), DataSource executeQuery(), canClose(), close().
47. Where is the best
place to write code to perform filter in a form
FormDataSource
executeQuery()
and call this
method in the design field of the form.
48. What are the
different types of menu items available, explain each of them
Display – for Form
Output for
Report
Action for
classes.
49. 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 .
50. Difference between
pass by reference and pass by value?
Pass By Reference:
In Pass by
reference address of the variable is passed to a function. Whatever changes
made to
the formal
parameter will affect to the actual parameters
Same
memory location is
used for both variables.(Formal and Actual)it
is useful when you
required to return more than 1 values
Pass By Value:
In
this method value
of the variable is passed. Changes made to formal will not affect the
actual parameters.
Different
memory locations
will be created for both variables.
Here
there will be
temporary variable created in the function stack which does not affect the
original variable.
In case of pass by
value, the change in the subfunction
will not cause any
change in the main
function whereas in
pass by reference the change in the subfunction
will change the
value in
the main function.
Pass by value sends
a COPY of the data stored in the variable you specify, pass by reference
sends a direct link
to the variable itself. So if you pass a variable by reference and then change
the variable inside
the block you passed it into, the original variable will be changed. If you
simply pass by
value, the original variable will not be able to be changed by the block you
passed it into but
you will get a copy of whatever it contained at the time of the call.
51. What are the two
most important methods on the Report?
Init(),run(),fetch(),send(),print()
52. When do block the
super() method of fetch
Don't call super()
when overriding the fetch method
in a report
53. Can we make a
report from wizard, if yes from where
Yes,
Tools>DevelopmentTools>Wizards>Report Wizard
59. What is a
Programmable Section, how we use it in reports
Use programmable
sections to add any kind of customized information. To activate a
programmable
section, activate it explicitly with an element.execute(Number)
statement. The
Number must be
specified in the ControlNumber property for the design section.
60. What is the
difference between Auto Design Spec & Generated Design
Auto Design: An
auto design is a report design that has a layout that is automatically
generated
based on the data
for the report. You can use auto designs for most common reports. Reusability
is available.
This uses Report
template and Section template. Header ,Section Group and Footer is not
available.
Generate Design or
Precision design: You can create a precision design for a report that
requires a
very precise
layout. It doesn’t use Section template and Report template. Reusability is not
available.
61. How can we sort the
DS, what facility we can get in by placing fields in Ranges
this.query().datasource(1).addsortfield(fieldnum(tablename,fieldname),sorting:ascending);
62. What is the role of
executeSection
You can override
the executeSection method for a report section to
modify the layout of the section
and to modify how
the section is printed. If you want to do something before a section is
printed,
such as go to the
next page, this can be coded in the executeSection method.
63. What are Queries,
how do we use them
You can create a
query to retrieve data by using the query classes.
64. what is Composite
query?
A composite query
uses another query as its data source. A composite query is similar to class
inheritance in X++
or C#. A composite query is a good design choice when one of the following is
true:
An existing query
lacks only a range that you want to add. An existing query lacks only a method
override that you
want to add.
65. What is the use of
Parameter, Enum Type Parameter/Enum Parameter properties of
MenuItems?
Parameters: Specify
the arguments that are passed to the object. Optional.
Enum TypeParameter
and Enum Parameter: Choose an enumerated type as a parameter for the
Object, and then
select an enum value as the EnumParameter property.
Optional.
These properties
are typically used when one form is used in several different situations. You
can
change the behavior
of the form, depending on the EnumParameter value.
For example, the
PriceDiscGroup form
is used by three different display menu items (PriceDiscGroup_*), which
each have a
different EnumParameter value. In the form's init method,
a switch construct checks
the value, and then
the form is created accordingly.
66. Why do we provide
Configuration key & Security Key?
Configuration key: Configuration
keys allow administrators to enable or disable features in the
application for all
users. Disabling features helps to minimize the attack surface against
potential
attacks.
Configuration keys
are applied to:
Tables
Fields
Indexes
Views
Menus
Menu
items
Form
controls,
Report
controls
Extended
data types
Enumerations
Security key: Security
keys allow administrators to set security on a user group level. Minimizing
access on a user
group level helps to reduce the attack surface against potential attacks.
The main reasons to
apply userlevel
security are to:
Allow users to do
only their designated tasks.
Protect sensitive
data in the database.
Prevent users from
inadvertently breaking an application by changing code or objects on which
the application
depends.
You need to apply a
security key to:
Tables
Views
Menus
Menu
items
Form
controls
Report
controls
67. Normally what do we
attach in Output Forms
68. Normally what do we
attach in Action Classes
69. What is difference
between select & select firstonly statements
The select
statement fetches or manipulates data from the database or both
fetches and
manipulates data
from the database. Results of a select statement
are returned in a table buffer
variable.
If you are going to
use only the first record or if only one record can be found, use
the firstOnlyqualifier.
This optimizes the select statement for only one record. Do
not
usewhile
select firstOnly.
It is a best
practice to use the firstOnly qualifier in find
methods on tables.
70. What are the
keywords used to access data from "multiple companies" and "one
company to
another company".
A crosscompany
query returns data
for several companies in a single run.
To create a
crosscompany
query:
In X++, use the
crossCompany keyword on the X++ select statement.
In X++, set the allowCrossCompany
property method to true on
an instance of the Query class.
In the AOT, set the
AllowCrossCompany property to Yes on a node under Query.
71. How can we override
a lookup
AOT>Form>DatasSource>Fields>FieldName
>Lookup
Form>Design>Field>Lookup.
72. How do the
following methods work in a form DS.
ds.refresh(),
ds.research(), ds.reread(), in what situation we should use these methods
Refresh(): Updates
the form by refreshing the view of all records in the data source.
Research(): Rereads
the current record from the database.
Reread(): Refreshes
the database search defined by the query, specified by
theFormDataSource.init
method.
73. On closing a form
name the methods which are invoked
Close(), closed(),
finalise().
74. How can we provide
user level/user group level security By
using security
keys.
75. What is Visual
MorphXplorer, what do we do with that?(Reverse engineering tool has replaced
Visual
MorphXplorer)
76. What is the
function of Application Hierarchy Tree?
Displays the
current object's inheritance hierarchy.
The Application
Hierarchy Tree enables you to view information about the parents and children
of
application
objects. For example, you can see all the classes that extend a particular
class, or see
which data types a
particular extended data type inherits from. It also enables you to view the
methods, fields,
and indexes that are used by tables. Information is available for application
and
system classes,
tables, and data types.
To view information
for a single application object
Rightclick
the object, and
then select AddIns
> Application
Hierarchy Tree.
To view information
for all application objects
Select Tools >
Development tools > Application Hierarchy Tree.
You need to
generate crossreferences
before you can use
the Application Hierarchy Tree.
Tables are listed
under the Common node in the Application Hierarchy Tree. All tables extend the
system table called
Common. Classes are listed under the Object node.
77. If you want to
monitor the database activity, where can you get that?
Administration>Reports>DataBase
information
Administration>inquiries>
DataBase information
Administration>Reports>Size
of Company accounts
78. Where can we find
the Label log and what is its utility?
Tools>DevelopmentTools>Label>Label
log.
Use this form to
view the history of labels within the system and recreate
labels that have
been
deleted.
View a record of
all changes made to the label files.
Overview Each label
is described in terms of its identification (ID), language,
status, label text,
and by whom and when it was modified. A label can also
contain a
description, which is displayed at the bottom of the form.
General View
information about the selected label.
Button
Recreate Recreate
the selected label.
79. What is Label
Intervals?
The SysLabelInterval
table contains the settings that control the interval of label IDs that are
used
to create new
labels through the label editor in MorphX.
80. What are the tools
you will use to upgrade any object? Compare
81. What is the use of
System Documentation/Application Developer Documentation/Application
Documentation
System
Documentation is intended for developers under the functions subnode there are
hundreds
of useful functions
you will use when programming in x++.
Application
Developer Documentation, under this node you find documentation about tables
and classes used by
Ax. description about tables and classes for developers.
82. What are the
classes, Tables, Forms and Methods used to post the sales orders.
SalesTableType and
SaleslineType classes will get called while creating the orders.
SalesFormLetter*
classes will be used to post the sales order at various document
status(packing,
invoice etc).
SalesParm* tables
are used to prepare the data for posting
CustConfirmJour,
CustConfirmTrans when
a sales order gets
confirmed
CustPackingSlipJour,
CustPackingSlipTrans when
a packing slip is
posted.
CustInvoiceTable,CustInvoiceTrans
when
an invoice is
posted.
These are some of
the maily used tables.
83. What are the
classes, Tables, Forms and Methods used to post the purchase orders.
84. What are the
classes, Tables, Forms and Methods used to post the Ledgers.
85. What are the
classes, Tables, Forms and Methods used to post the Inventory.
86. What is the base
class to send the onboad
Emailing.
SysMailer and
SysINetMail.
87. What are the
storage Dimensions?
Site,WareHouse,PalletId,BatchNumber,SerialNumber
88. What are the Item
Dimensions?
Configuration,
size,Color
89. What is the
difference between RunBase and RunBaseBatch?
RunBase: To
create a job or an Action class a
program that
carries out processes, such as
accepting
parameters from the user and then updating records in the database you
use the
RunBase framework.
The framework is
implemented by the RunBase application class and supplies many
features,
which include the
following:
Query
Dialog,
with persistence of the last values entered by the user
Validate
The RunBase
class is a framework for classes that need a dialog for user
interaction and that need
the dialog values
to be saved per user.
RunBaseBatch: You
can design your own batch job by extending the RunBaseBatch class.
You can
also write code to
schedule the batch to run. The batch runs on the Application Object Server
(AOS)
91. What is the
difference between Insert and doinsert.
Insert(): To
insert the records into the database. Secure any related transactions with tts.
Doinsert():These
methods should only be used under strict control because they bypass the
following:
Any validations
that have been set up.
Any code that was
written in the insert, update,
and delete methods.
92. What is the Runbase
Stack?
93. Difference between
sql and x++ statementSELECT1.
Table buffer on the
FROM in x++ clause ,not the table as in SQL
2.ORDER BY clause
precedes the WHERE clause
3.! for negation
,not NOT as in SQL
4.&& and ||
for logical operator ,not AND or OR as in SQL.
5.* and ? for like
wildcards ,not % and _ as in SQL.
JOIN CLAUSE1.
Join clause has no
ON keyword in x++,use WHERE instead
2.Default JOIN
direction is left .
3.there are no LEFT
and RIGHT keyword for JOIN in x++
4.The FROM clause
is optional when:
No
column is listed or
Only
one table is listed
in the SELECT in x++
select * FROM
CustTable;
select CustTable;
both are same.
OTHERS1.
The WHILE SELECT
statement provides an automatic cursor for return rows in x++
2.There is no
HAVING keyword in x++
3.No null values
are return in x++
94. What is cluster
installation?
Admin Setup
Cluster
Configuration
Click System
administration > Setup > System > Cluster configuration.
You can distribute
the user load in Microsoft Dynamics AX across multiple instances of
Application Object
Server (AOS) by creating a load balancing cluster.
95. Steps in creating
number sequence?
Basic>Setup>NumberSequences>
NumberSequences – Create a new number sequence.
Classes>NumberSequenceReference>LoadModule.
AR>Setup>parameters
setup
code.
Tables>CustParameters
create
method starts with
numRefEDT.
Form>FormRun
Create
numberSequenceFormHandler
method.
Form>FormDataSource
Override
create method.
96. Any module you are
good at. – AR,AP,Inventory,Production.
97. Collection classes
You cannot store
objects in arrays or containers. The AX collection classes have been designed
for
storing objects.
The classes are implemented in C++ to achieve the maximum performance (they
are system
classes).
Class Description
Array
Similar to the
array type except that it can hold values of any single
type, including
objects and records. Objects are accessed in a specific
order.
List Contains
elements that are accessed sequentially.
Map Associates
a key value with another value.
Set Holds
values of any single type; used when order is important.
Struct
Can contain values
of more than one type. Used to group information
about a specific
entity.
98. Tables in
inventory?
InvetTable,InventTableModule,InventItemLocation,
InventDim, InventTrans
BOMTable ,
WMSShipment.InventColor, InventSize
99. If you manipulate anything
which layer would it affect?
The present layer
where you are working and below of that layer.
100. What are the
components in reports?
Methods ,
DataSources , Design.
101. How many types of
classes are there?
System Classes and
Application Classes.
102. Development tools?
Version control ,
Crossreference,
Code profiler,
Debugger, Application Hierarchy Tree,Code
Explorer, Reverse
Engineer, Number of Records, Embedded Resources, Wizards, Label.
103. Communication
tools
104. Can you say few
best practises in ax?
105. What is the
difference between sql queries and dynamics queries.
Sql query is Select
statement –
Dynamic query – AOT
Query and Query class using x++.
106. What is the
difference between x++ and c#?
X++ contains code
and Sql select statements
C# contains only
code.
107. What are the link
types in Ax?
Passive: Linked
child data sources are not updated automatically. Updates of the child data
source
must be programmed
on the active method of the master data source.
Delayed: A
pause is inserted before linked child data sources are updated. This enables
faster
navigation in the
parent data source because the records from child data sources are not updated
immediately. For
example, the user could be scrolling past several orders without immediately
seeing each order
lines.
Active: The
child data source is updated immediately when a new record in the parent data
source
is selected.
Continuous updates consume lots of resources.
InnerJoin: Selects
records from the main table that have matching records in the joined table and
vice versa. There
is one record for each match. Records without related records in the other data
source are
eliminated from the result.
OuterJoin: Selects
records from the main table whether they have matching records in the joined
table.
And the other
records also shown in the main table.
ExistJoin: Selects
a record from the main table for each matching record in the joined table.
The differences
between InnerJoin and ExistJoin are as follows:
When
the join type is
ExistJoin, the search ends after the first match has been found.
When
the join type is
InnerJoin, all matching records are searched for.
NotExistJoin: Select
records from the main table that do not have a match in the joined table.
108. What can’t you
store in containers
We can’t store
objects in containers.
109. Difference between
arrays and containers
An array can hold
only items of same and its declared type. Containers store different types of
data
types at a time.
You can allocate
memory space for an array and fill that space with values later, such as in a
loop.
This is efficient
and performs well.
110. Logic for
converting string to uppercase?
StrUpr() Converts
all the letters in
a string to uppercase.
111.What is JumpRef()?
The user activates
the Go to main table command from the shortcut menu on the control or by
pressing
CTRL+ALT+F4. The super() call opens the main table that
contains data for the field.
112. D.B Abstract and
final class.
Abstract forces the
class to be derive subclass and final stops the class not to be derive or
inheritance.
113. D.B ValidateWrite
and write.
validateWrite(): Executed
when a new or updated record is to be written. Determines whether
data is valid and
ready to be written.
Write(): Executed
when the user inserts a new record or updates an existing one. Calls
theFormDataSource.validateWrite
method and manages the database write operation.
114. What is dialoge
class.
A dialog in AX is a
simple form with a standardized layout, created by using the Dialog
system
class. Dialogs
should allow users to enter some simple values.
Dialog ClassesDialogField,
DialogGroup,
DialogTabPage, DialogText, DialogWindow.
Dialog Methods –
addField,addGroup,addTabPage,run,pack,unpack,
115. Pack and Unpack
method?
Use the packunpack
pattern to save
and/or store the state of an object, and then later reinstantiate
the same object.
Pack():create
a pack method to read the state of the object and return it in
a container suitable for
saving or
transporting between tiers. Reading the state of the object implies collecting
the value of
all its members. If
the members are tables (records, cursors, temporary tables) or classes, it must
also be possible to
read their state.
Returns the state
of the object as a container.
Unpack():create
an unpack method that takes the packed state
and reinitializes an object with it.
Construct the
object before creating an unpack method.
The unpack
method takes the saved state of the object and reinitializes the
object with it. It
reinitializes the
object members according to the values in the container, taking the supplied
version number into
account.
The method can
return a Boolean that signals the result of the initialization process.
116. Architecture of MS
dynamics AX.
Ax has the three
tier architecture 1
. client 2. AOS
3.DataBase.
117. Tell us about
AIF(MSMQ).
Application Integration
Framework (AIF) is the infrastructure within AX with which you can
expose business
logic or exchange data with other systems. AIF is comprised of three primary
components:
1.Services
Enable
you to expose
business logic written in X++ as a service to be consumed by
other applications.
Within Microsoft Dynamics AX, you can create, customize, and publish
services.
2.Document
services A
specific
implementation of services in which the Microsoft Dynamics AX
business logic is
exposed through document services.
3.Consume
Web services In
Microsoft Dynamics
AX, you can consume external Web services
from your X++ code.
118. How to design a
form in AX using X++?
The Form*
classes enable you to manipulate, create, modify, or run forms
by using X++ code. You
can also modify
forms during run time so, for example, one or more controls are hidden on a
form,
depending on the
user's selections in the preceding form.
The Form
classes are all system classes and are prefixed with Form.
Form, FormRun,
FormDesign, FormBuildDesign, FormDataSource, FormBuildDataSource,
FormControl
119. What is report
builder?
You can create
reports by using Report Builder for Microsoft SQL Server Reporting Services.
You
add information to
the report from a report model.
When you create a
report by using Report Builder for Microsoft SQL Server Reporting Services,
you are using
secure views of the tables available in the report model.
120. What is Index,
properties in Index and types of Index?
An index is a
tablespecific
database structure
that speeds the retrieval of rows from a table.
Indexes are used to
improve the performance of data retrieval and to ensure the existence of
unique records.
It's up to the databasespecific
query optimizer to
use available indexes to
facilitate
efficient data retrieval.
Unique index and
nonunique
index.
121. Concept of
Different Layer in AX.
sys syp gls Glp hfx
sl1 sl2 sl3 bus bup var vap cus cup usr usp
122. Difference between
bound and unbound controls?
Form controls
belong to one of three groups, depending on their data source as follows:
Bound
control – associated with a field in an underlying table. Use
bound controls to
display, enter, and
update values from fields in the database.
Unbound
control – does not have a data source. Use unbound controls to
display pictures
and static text.
Calculated
controls – uses a method as the data source. An example of a calculated control
is the sum of two
fields on a form.
123. How to create
runtime query?
You can create a
query to retrieve data by using the query classes.
Query, QueryRun,
QueryBuildDataSource, QueryBuildRange, QueryBuildLink,
QueryBuildDynaLink
124. What is optimistic
concurrency control and Pessimistic Concurrency Control?
Optimistic
Concurrency Control (OCC) helps increase database
performance. Pessimistic
Concurrency Control
locks records as soon as they are fetched from the database for an update.
However, Optimistic
Concurrency only locks records from the time when the actual update is
performed.
Following are the
advantages of using OCC:
Fewer
resources are used to hold the locks during the update process.
Records
are locked for a shorter length of time.
Records
remain available for other processes to update if they have been selected from
the
database but
haven't yet been updated.
The disadvantage of
using OCC is that the update can fail if another process updates the same
record. If the
update fails, it must be retried. This can lead to a reduction in database
performance.
OCC makes it
possible for other processes to update a record even after it has been fetched.
You
can catch update conflicts
by catching
the UpdateConflict
and UpdateConflictNotRecoveredexceptions.
125. What are
transactions?
126. How to lock
transactions?
127. What are macros?
Macros act as a
container for defining variables used for frequent tasks. The purpose of
macros is to make
statements easy to reuse. A macro can’t be executed independently as a class.
An advantage macro
is that the maintenance is done in only one place.
Three types of
macros
Macro libraries –
is a standalone macro that contains a collection of local macros.
Standalone macros –
is created by using the macro node in the AOT.
Local macros is
declared with in a
method.
128. What is the
default link type property? Delayed.
129. Default join in
select statement (Queries) innerJoin
130. Difference between
validate write and validate field?
validateWrite(): Executed
when a record is written to the database, before the data change is
committed in the
database.
validateField():Executed
when you leave a field in a record. For example, after entering changes to
a field on a grid
control, you could click another field in that same record or on a different
record.
Or you could click
another control on that same form.
The super()
method invokes field validation checks, as guided by the value
of
the Validateproperty.
131. Do we have
validate write and validate field in form level?
FormDataSource –
validateWrite()
FormDataSourceField
validate()
132. What are the
methods required for posting a purchase order?
133. How to give null
in select query?
Select table where
table.field == “ ” ;
134. What is cache
lookup and IsLookup what is it used for?
CacheLookup : Determines
how to cache the records retrieved during a lookup operation.
Types None
, NotInTTS, Found,
FoundAndEmpty,EntireTable.
IsLookup : For
report models, it specifies whether the table information is incorporated into
other
tables that
reference it when a report model is generated.
For OLAP cubes, it
determines whether to generate a consolidated dimension or a distinct
dimension. You can
specify one of the following values.
Yes
Indicates
that attributes
from the table are to be consolidated into the parent
dimension (star
schema).
No
Indicates
that a separate
dimension is to be generated for the table (snowflake
schema).
135. Difference between
table and views?
A Microsoft
Dynamics AX view is a virtual table that contains the data records and fields
that are
specified by a
query.Like a table, a view uses fields and rows to represent data records.
However,
the data in a view
is not stored as a database object but is dynamically created when the view is
accessed. A view
uses a query to retrieve data fields from one or more database tables.
When you create a
view, the view definition is generated and stored in the database. When that
view is accessed,
the view dynamically retrieves the data that satisfies the view definition.
Views are readonly.
The data fields and
tables that a view uses cannot be updated from that view.
Benefit Description
Focused data
A view enables you
to retrieve and return only the data that is relevant
for a particular
user or scenario.
Customized data
A view enables you
use a complex query to create a highlycustomized
set of data. For
example, a view often represents data as a single table
that was retrieved
from multiple joined tables and used many
conditions.
Performance
A view can improve
performance by returning only relevant fields to
the user. In
addition, a view definition is compiled which may provide
better performance
than calling an equivalently complex query.
136. In which case
delete_from and delete() have same result?
When deleting only
one record in the table.
137. Explain
sales/purchase order processes in AX.
138. Can you just tell
the table properties that you can remember?
139. Explain different
types of reports?
AOT Reports , Using
X++ Report
classes, Using
Report wizard.
140. Primary Key in
tables (In dynamics AX don’t have primary key)
141. What is the
default index for a table?
The system index is
created on the RecId and DataAreaId fields if the DataAreaId field exists.
Otherwise the
system index is created on the RecId field. You can see system indexes in the
database but they
aren't visible in the AOT.
142. What are all the
addon
tools you used in
Dynamics AX (It’s an indirect question for AIF)
143. Did you work with
EP (Enterprise Portal & Workflow) how can you implement this features
into your projects?
144. Difference between
this and element?
this & element:
this can be used in any objects to reference the current object
and member
methods.
In forms the
collection of objects is contained within a FormRun object. You can reference
members in the
outer formrun object by using the element reference.
If your code is
placed at the top level there are no functional difference between this and
element.
If your code is
placed in a formdatasource but this will reference the datasource but element
will
reference the
formrun.
You cannot use
element to refer table or class object.
145. COM & .NET
Business Connector
146. Concurrent user
& Named user
147. Primary key &
Foreign key
148. AOS Load balancer
concept/Clustering
149. AX 2009 Debugger
concepts?
Use this debugger
to debug X++ code that is running on the following:
Microsoft Dynamics
AX Business Connector
AOS
Microsoft
Dynamics AX Client
The debugger
windows. 1. Code 2. Variables 3.Call stack 4.Watch 5.Break
points
6. Output
150. Cross reference
tool ?
The Microsoft
Dynamics AX crossreference
system allows you
to see the relationships between
objects. You can
see the following:
Which other objects
use the current object
Which other objects
the current object uses
For example, you
can get a list of every piece of code that uses a particular method, or you can
see
which forms use a
particular table field. You can also get information about where labels are
used
in the application.
151. Document
Management
152. Print Management
153. Caching mechanism
in AX ?
Caching is to
remember the information already retrieved from the database and use this
memory when the
same data is needed again.
Drawback, if the
remembered information is no longer valid this could compromise the
consistency of the
database as the updates are made based on the invalid data.
Read ahead caching
, single record caching, Entire table caching, Record view caching, Display
method caching.
154. What is cloud
computing? How it is configured in AX?
155. Difference between
parameter table and Normal table?
The parameter
system design pattern holds static setup information for the modules in a
company, such as
information on the national currency, the posting method, and so on. There is
one instantiation
of this pattern per module.
The parameter
system should be set up as described in this topic. The parameter record is
automatically
created by the system and has the following:
A
parameter table
A
parameter form
A
parameter menu item
There should be one
parameter table per module.
Parameter tables
have a single record per company, holding the required parameters for the
module. The record
is cached. To enable the Foundcache,
a key is defined.
Add an integer
field called key. It should have the Visible property
set to No
156. What is
Configuration form in Ax?
Administration>Setup>System>Configuration
displays
all the module
configuration
keys and we can
enable or disable the key from this form.
157. How to change
Standard table as temporary table ?
By changing the
table property to Yes and Use the setTmp table
method to make a nontemporary
table temporary
rather than creating a copy of the table, and then making it temporary.
158. What is difference
between Auto design and Generate design ? If we uses both designs in a
report what design will
be print?
Report prints
Generated
design.
159. Oops concept what
doesn’t support in Ax?
Multiple
inheritance and method overloading
160. Instead of
multiple inheritance what we use in Ax?
Interfaces
161. How to open exe
file in Ax?
Ax32.exe "
C:\Program
Files\Microsoft Dynamics AX\50\Client\Bin\Ax32.exe"
162. What is table
properties of formRef and ReportRef ?
For tables where
the Table Group property has been set to Group,
Main, or
WorksheetHeader,
you must do the following:
Have
a form to maintain the table records.
Set
the FormRef property to the name of a display
menu item.
The form and the
display menu item that are used to start the form should have the same
name as the table.
An example of this rule is the CustTable table in Microsoft Dynamics AX.
Note
Don't set the FormRef property for tables where the MaxAccessMode property is set to
NoAccess. These
tables are not used in a form.
Specifies the
display menu item that is activated when a table is referenced.
When you use a
primary index field on a report, this form is available as a link in the
report. A primary
index is specified by using the PrimaryIndex property.
If you leave this
field blank, the system attempts to display a form that has the same name
as the table.
The FormRef
property of a table lookups display menuitems.
163. How many types of
exceptions are there in Ax?
15 types of
exceptions in Ax are Info,
warning,deadlock,error,internal,break,dderror,sequence,numeric,CLR
error,Code access
security,UpdateConflict,UpdateConflictNotRecovered,DuplicateKeyException,DuplicateKeyExceptionNot
Recovered.
164. Access modifiers
and Method modifiers ?
Access Modifiers: All
methods of a class are always available to code in the class itself. To control
access from other
classes, and to control inheritance by subclasses, X++ has three access control
modifiers for
methods:
Classes are treated
as public if you do not specify an access
modifier.
public :
Methods that are declared as public can
be used anywhere the class is accessible and can
be overridden
by subclasses.
protected :
Methods that are declared as protected can
only be called from methods in the class
and in subclasses
of the class where the protected method is declared.
private :
Methods that are declared as private can
only be called from methods in the class where
the private method
is declared.
Method Modifiers : abstract
,client,server,display,edit,final,static,public,private,
protected.
165. How many types of
dimensions in inventory?
Item dimensions –
Configuration,size,color
Storage dimensions
– Site, Ware house, PalletId, Batch number, Serial Number.
166. If we create table
relation and EDT relation for the same field in the table which relation the
field uses?
Table relation.
167. What is Composite
query where we can use?
A query with in
another query is called Composite query. Uses in the Query node in the
AOT.
168. Can run the form
on server side? No
169. Difference between
table delete and form delete?
170. What is section
template and report template?
Report Template: A
report template can specify the sections that a report includes, such as a page
header and a page
footer, page numbers on each page ,company logo ,the controls included in each
section, and the
layout of the controls. Only reports based on an Auto design inherit changes
that
are made to a
report template, Generate design doesn’t inherit changes to report template.
Section template: This
makes it possible to define sections one time and reuse them many times.
This is used for
elements appearing in more than one report.
171. When you are
creating a table what is the default table group? Miscellaneous
172. Where is the best
place to write the logic in Ax?
Classes, try to
avoid the code in the forms.
173. what is the thin
and thick or fat client in the configurations?
Thick client has
the direct access to the database.
How to generate the
Sales invoice periodically/automatically?
How to send the
customer’s report as an Email
to the particular users
on daily status?
What class will call
when sending the Email?
How to run the debug
for the server modifier methods?
What are the delete
actions?
What are the relations
and examples?
What is Security key
and configuration key?
What are the query
methods and what is get , getno methods?
In the fetch method
of report we call get() and getno() methods. Get is used to get the table from
the query or
datasource of report, here we will give the datasource table name. and getno()
is used
to get the query
number or datasource table number of a report.
What is the Sales order
cycle?
10. What methods and
tables called when posting the sales order?
11. What is purchase
requisition?
12. What is BOM?
13. What is abstract
class? what are the abstract classes in Ax?
RunBase,
RunBaseBatch, FormLetter , FormLetterReport
,
PurchFormLetter,PurchFormLetterReport, SalesFormLetter,
SalesFormLetterReport,RunBaseReport,GanttData
,InventModelType ,
InventMovement LedgerBalance PrintMgmtHierarchy , PrintMgmtNode
,PrintMgmtSetupSettings
, SmmImport SmmOutlookSync , SysCheckList , SysCodeExplorer
,SysDataExpImp ,
SysDefaultData, SysExcel, SysExcelApplication , SysExcelCell
,SysExcelWorkbooks
, SysExcelRange , SysSearch, SysWizard, WorkflowElement,
AddressSelectForm,
AddressZipCodeImport, AifDocument, AifDocumentService,
AssetSumCalc,AssetTableInterval, AssetTableMethod, AxdBase, Barcode,
BOMCalcBase,
BomCalcLine,
BOMCopyFrom, CustVendBalanceList, CustVendPaym, CustVendTransData,DimensionCopy
14. What is interface
and what are interfaces classes in Ax?
Batchable,
SysPackable, SysComparable, SysMergeable,SysSaveable
,AfService,SysVersionControllable,
SysTestExecutable, SysTestListener
,AifXmlSerializable,AifCustomizableService,
AifGatewayReceiveManager, AifGatewaySendManager,
AifIntegrationAdapter,
AifPipelineComponentInterface,AfEmployeeService,WorkflowDueDateProvider,WorkflowHierarchyProviderNode,
WorkflowConfigControl,
WMSOrderTransMultiUpdateHandleable, DynamicPropertyCallback,RunbaseRecsMapable,
SysCompareContextProvider, WorkflowStartedEventHandler,
WorkflowCompletedEventHandler,
WorkflowCanceledEventHandler,SysVisioModelProvider,
SysVersionControlChangeLists,
SysVersionControlReviews,
, SysTaskRecorderIEventMonitor, SysImportStatusGettable,SysImportLoggable,
SysCheckListInterfaceUpgrade, ButtonStateProvider
15. What is
polymorphism?
16. What is primary
index ,clustered index?
17. Write a program for
reversing the string?
18. Why SSRS using
temporary table, can we use normal table?
19. How many types we
can develop SSRS reports?
20. What is Data
provider class?
21. What is the best
way to develop SSRS reports? (query or DP class)
22. Write a program to
print the sum of amount for each accountnum from CustTrans?
23. Write a program to
print the reverse of a given number?
24. Write a program for
finding the biggest element in the array?
25. What are changes
between Ax2009 and Ax2012?
26. What is table
inheritance in Ax 2012?
27. What is table
reference in EDT – 2012?
28. What is surrogate
key in Ax 2012 ?
29. How to cancel the
sales order from X++, what is the best place to write the code for cancelation?
30. If I have millions
of records in a form and to open the form or perform any operation it is taking
more time. So how to
speed up the process of the form to retrieve the records from the database?
31. What is FIFO and
LIFO in inventory ,give the real time example?
32. How to debug the
batch jobs in ax?
33. What is amstrong
number write a program for finding the amstrong number?
34. Where you will
write the code for filter in form and report?
35. Differences between
abstract class and interfaces?
1. Main
difference is methods of a Java interface are implicitly abstract and cannot
have
implementations. A
Java abstract class can have instance methods that implements a default
behavior.
2. Variables
declared in a Java interface is by default final. An abstract class may contain
nonfinal
variables.
3. Members
of a Java interface are public by default. A Java abstract class can have the
usual flavors
of class members like
private, protected, etc..
4. Java
interface should be implemented using keyword “implements”; A Java abstract
class should
be extended using
keyword “extends”.
5. An
interface can extend another Java interface only, an abstract class can extend
another Java
class and implement
multiple Java interfaces.
6. A
Java class can implement multiple interfaces but it can extend only one
abstract class.
7. Interface
is absolutely abstract and cannot be instantiated; A Java abstract class also
cannot be
instantiated, but can
be invoked if a main() exists.
8. In
comparison with java abstract classes, java interfaces are slow as it requires
extra indirection.
Interview Questions:
Tell about your
Self.
What kind of
Customizations you have done.
How you will create
Table in Ax. In that Table how you will define Indexes, Relations, Delete
Actions and
Methods. Tell me the steps First what you will do, First you will define
Indexes or
Relations. Why?
What is Naming
Conventions in Ax?
What is Index? How
many types of Indexes are there? What is unique index and nonunique?
What is Cluster
Index?
What is Cache Look
Up? More Questions on regarding Cache Look Up?
What is FormRef?
What is
Configuration Key? Why need of configuration keys?
10) What is
Security Key?
11) What is Record
Level Security?
12) How the ax is
providing security. What are the ways?
13) Types of
Relations.
14) Types of Delete
Actions.
15) What kind of
methods you will create will create a Particular Table?
16) What is Table
Collections?
17) How you will
create different Environments like Aos1, Aos2……………..so on……
18) For Example:
150 users are Accessing Aos1.How you will assign users to Aos2 for that what
you
required. More
Questions on regarding AOS
19) Tell me the
Invent Table Form Data sources?
20) Invent Dim
Table What it stores?
21) What is Table
Group? When you creating new tables in ax by default what is the Table Group?
22) Can you tell me
the Sales Table, Table Group? What it consists
23) How you will do
the SSRS Repots in AX?
24) What are all
the New Features are added in Ax 2009?
25) How to install
Ax 2009? What it Require? How you will install in Win XP & Vista? More
Questions on
regarding Ax Installation.
26) What is
Workflow? How you will do this? Ex: For Po how to configure Workflow? Steps…..
27) For New Module
how to Achieve Workflow. Steps. more Questions on regarding WF
28) How you will
configure Workflow For AR
29) How to install
Workflow. What it requires (software’s).
30) Weather
Workflow requires EP?
31) What is EP?
What it requires (software’s). More Questions on regarding EP.
32) What is Number
Sequence? How you will do that? Number Sequence Steps…
33) How you
configure Number Sequence in Ax? For Example I created one record in ABC Form.
I
didn’t save the
record. I just deleted the record. In that Case what will happen? What comes
next….
34) What is Global
Address Book?
35) How can you use
the Global Address Book?
36) How can you
Create New Employee?
37) What is the use
of Virtual Companies?
38) At form Level
how you will define Query Build Classes. How you will do that
39) Tell me Form
Level Data Source Methods.
40) What is Execute
Query
41) What is Init at
form Methods
42) Types of
Inventory Dimensions?
43) Types of Item
Dimensions?
44) Types of
Storage Dimensions?
45) Types of
Dimensions in Ax?
46) How to define
Composite Queries in Ax?
47) Number Sequence
Classes.
48) Types of Link
Types?
49) Inner Join and
Exists Join?
50) Oops Concepts?
51) What is
inheritance?
52) Types of
Inheritance?
53) What is
Abstract Class in Ax? How you will define?
54) What is
interface?
55) Tell me
Interfaces Classes in Ax?
56) What is
RunBase?
57) Where we can
create item in Ax2012?
58) Difference
between change company and cross company?
59) What is
surrogatekey in 2012?
60) How to import
data one application to another application?
61) Differences in 2009 and 2012?
