Monday, 4 July 2016
History of Microsoft Dynamics AX
Microsoft Dynamics AX is one of Microsoft's enterprise resource planning software products. It is part of the Microsoft Dynamics family.
Microsoft Dynamics AX was originally developed as a collaboration between IBM and Danish Damgaard Data as IBM Axapta. Axapta was initially released in March 1998 in the Danish and U.S.
markets. IBM returned all rights in the product to Damgaard Data
shortly after the release of Version 1.5. Damgaard Data merged with
Navision Software A/S in 2000 to form NavisionDamgaard, later named Navision A/S. Microsoft acquired the combined company in July 2002.
The newest version was released in February 2016.
Version |
Release |
Company |
|
Axapta 1.0
|
March 1998
|
Damgaard A/S
|
|
Axapta 1.5
|
November 1998
|
Damgaard A/S
|
|
Axapta 2.0
|
July 1999
|
Damgaard A/S
|
|
Axapta 2.1
|
January 2000
|
Damgaard A/S
|
|
Axapta 2.5
|
December 2000
|
Navision-Damgaard
|
|
Axapta 3.0
|
October 2002
|
Microsoft
|
|
Microsoft Dynamics AX 4.0
|
March 2006
|
Microsoft
|
|
Microsoft Dynamics AX 2009
|
June 2008
|
Microsoft
|
|
Microsoft Dynamics AX 2012
|
August 2011
|
Microsoft
|
Wednesday, 1 June 2016
Role-Based Security to Forms in Microsoft Dynamics AX 2012
Overview
Microsoft Dynamics AX 2012 uses a role-based security framework to assign permissions to users of AX. A user must be assigned to one or more security roles in order to access different functions within AX.Pre-requisites
- Microsoft Dynamics AX 2012
- At least one user must be setup (System administration à Common à Users à Users)
Important Concepts
1. Security roles
Security roles define a particular function that an individual plays in an organization. Security roles are groups of duties and privileges which define the functionality a user can access and parts of the interface a user can view.2. Process cycles
Process cycles are used to organize duties and privileges according to the business processes used in an organization. They are not directly assigned to the user but helps in organizing higher level process of the organization.3. Duties
Duties correspond to individual task that a user can perform, and group related privileges into a single task. Each duty can be assigned to one or more security roles depending upon the business process in question.4. Privileges
Privileges are used to give access to individual application objects like forms and reports. A privilege defines the level of permission that is required to access an application object in AX. Privileges group together permissions that are necessary to complete a specific job.5. Entry point
An entry point corresponds to a starting point that a user is required to access in order to perform a job. Each function in AX is accessed through an entry point. There are 3 different types of entry points in AX:- Menu items
- Web menu items
- Service operations
6. Permissions
Permissions are used to control access to each individual object in Dynamics AX. The level of permission is controlled by the associated Access level. Following are the different Access levels available in AX:- Read
- Update
- Create
- Correct
- Delete
- No Access
Scenario
As part of this tutorial, role-based security will be applied to the Customer groups form (Accounts receivable à Setup à Customers à Customer groups).Steps
- First, to create a new privilege go to AOT à Security à Privileges
- Right click on Privileges and select New Privilege
-
Name it CustomerGroupViewNote: It is a best practice to name a Privilege as MenuItemName + View/Maintain depending upon the Access level
-
Set the Label of the privilege as Customer group view
- Now expand the newly created privilege and create an entry point by right clicking on Entry Points and selecting New Entry Point
- Name the entry point as CustGroup and set the AccessLevel to Read
-
Set the ObjectType to MenuItemDisplay and ObjectName to the menu item of the Customer group form, CustGroup
- Save the privilege
- Now create a duty and assign the above created privilege to the duty
- Go to AOT à Security à Duties
-
Right click on Duties and select New Duty to create a new duty
- Name the duty as CustomerGroupView and set the Label as Customer group view
- Expand the above created duty and create a new privilege by right clicking on the Privileges node and select New Privilege
-
Select the CustomerGroupView privilege in the Name field and save the dutyNote: You can also drag and drop the privilege on the Privileges node
- Next create a new role by going to AOT à Security à Roles
- Right click on Roles node and select New Role
- Name the role as SecurityDemo and Label it as Security demo
- Expand the above created role and right click on Duties node and select New Duty
- Select the CustomerGroupView duty in the Name field and save the role Note: You can also drag and drop the duty on the Duties node
- Now assign the above role to a user Dynamics AX. Go to System administration à Setup à Security à Assign users to roles
- On the Assign users to roles form, select the above created role in the left tree and click on Manually assign / exclude users
- In the opened dialog, select the user to which you want to assign the role and press Assign to role
- A green check mark will appear in case of successful assignment. Close the form
- Now login with the selected role
-
Only the functions assigned to the user will be visible. In this case only the Customer groups form is visible since the Security Role contains only one duty. Also note that only those Menus will be visible that contains the menu item assigned in the Privilege
Monday, 9 May 2016
Code to get the no of records selected in a grid in infolog
void clicked()
{
//this helps us to get the no of records selected in an infolog
FormDataSource fds;
Common common;
int counter;
;
super();
fdS = Table6_DS;//tablename_ds
for (common = fdS.getFirst(true) ? fdS.getFirst(true) : Table6_DS.cursor(); common; common = fdS.getNext())
{
counter++;
}
info(int2str(counter));
}
Thursday, 14 April 2016
Creation of Inquiry Form Using Display Methods
Scenario:
Here the scenario is to show the item details in grid based on selection of item in the form.
The item details include Orderedsum,PhysicalInventory and PhysicalReserved.
But we have to get these three fields through display methods in table.
With the help of above screen shot you can easily understand what my scenario is.
- First of all I have created a table (table6),in that I have taken itemid(edt) as a field, but this table should be temporary table(TempDB).
- Now I have written a method(getorderedsum) in order to get orderedsum field in my form.
Display Qty getorderedsum()
{
Inventsum inventsum;
InventDim inventdim;
;
inventdim.InventSiteId = this.InventSiteId;
inventDim.InventLocationId = this.InventLocationId;
inventDim = InventDim::findOrCreate(inventDim);
select inventsum where
inventsum.itemid == this.ItemId;
return inventsum.orderedSum();
}
- Now I have written another method(getphysicalinventory) to get physical inventory field.
Display Qty getphysicalinventory()
{
InventSum inventsum;
InventDim inventDim;
;
inventdim.InventSiteId = this.InventSiteId;
inventDim.InventLocationId = this.InventLocationId;
inventDim = InventDim::findOrCreate(inventDim);
select inventsum where
inventsum.itemid == this.ItemId
&& inventsum.InventDimId == inventDim.inventDimId;
return inventsum.availPhysicalCalculated();
}
- Now I have written another method(getphysicalreserved) to get physical reserved field.
display qty getphysicalreserved()
{
Inventsum inventsum;
InventDim inventdim;
;
inventdim.InventSiteId = this.InventSiteId;
inventDim.InventLocationId = this.InventLocationId;
inventDim = InventDim::findOrCreate(inventDim);
select inventsum where
inventsum.ItemId == this.ItemId
&& inventsum.InventDimId == inventDim.inventDimId;
return InventSum.availReservation();
}
- Now create a form using the above created table as data source.
- Now override the init method with this code.
public void init()
{
super();
delete_from Table6;
}
- Now in grid create three real edits and name those as Orderedsum,PhysicalInventory and PhysicalReserved respectively.
- Now in realedit properties give the datasource as table6(tablename) and data method as respective method name.
- now do the same for the next two real edits.
- Inorder to get the grid empty set the datasource property insertifempty to NO.
- Then the final output will be as shown below.
Wednesday, 3 February 2016
Select Statements
CrossCompany
static void CON_SelectStatement(Args _args)
{
CustTable custTable;
container companies = ['USMF','IBM'];
while select
crossCompany:companies * from custTable
{
info(custTable.AccountNum);
}
}
firstFast
static void CON_SelectfirstFast(Args _args)
{
CustTable custTable;
while select
firstFast custTable
info(custTable.AccountNum);
}
firstOnly
static void CON_SelectfirstOnly(Args _args)
{
CustTable custTable;
while select
firstOnly custTable
{
info(strFmt("%1--%2",custTable.AccountNum,custTable.dataAreaId));
}
}
forUpdate
static void CON_SelectforUpdate(Args _args)
{
Con_Calc con_Calc;
ttsBegin;
while select
forUpdate con_Calc where con_Calc.Name=="Satya"
{
con_Calc.Name="Satya CH";
con_Calc.update();
info(con_Calc.Name);
}
ttsCommit;
}
static void CON_Selectwhere(Args _args)
{
CustTable custTable;
while select * from
custTable where custTable.CustGroup=="10"
{
info(strFmt("%1--%2",custTable.CustGroup,custTable.AccountNum));
}
}
Groupby
static void CON_SelectGroupby(Args _args)
{
CustTable custTable;
CustTrans custTrans;
while select
minof(AmountMST) from custTrans group by AccountNum
{
info(strFmt("%1--%2",custTrans.AccountNum,custTrans.AmountMST));
}
}
count
static void CON_Selectcount(Args _args)
{
CustTable custTable;
CustTrans custTrans;
int a=0;
while select
count(RecId) from custTable
{
a =
custTable.RecId;
}
info(strFmt("%1",a));
}
change
Company
static void CON_SelectchangeCompany(Args _args)
{
CustTable custTable;
info(custTable.dataAreaId);
changeCompany('IBM')
{
custTable =
null;
while select
custTable
{
info(strFmt('%1',custTable.dataAreaId));
}
}
}
Relational
Operator
static void CON_Select(Args _args)
{
CustTable custTable;
CustTrans custTrans;
int a=0;
while select
custTable where custTable.AccountNum=="DE_005" &&
custTable.AccountNum=="DE_006"
{
info(strFmt("%1",custTable.AccountNum));
}
}
static void CON_Select(Args _args)
{
CustTable custTable;
CustTrans custTrans;
int a=0;
while select
custTable where custTable.AccountNum =="DE_005" ||
custTable.CustGroup =="10"
{
info(strFmt("%1--%2",custTable.AccountNum,custTable.CustGroup));
}
}
Joins
static void CON_SelectJoin(Args _args)
{
CON_Car car;
CON_RentCar rent;
// Inner Join
/* while select car join rent where car.CarID ==
rent.CarID
{
info(strFmt("%1--%2",
car.CarID,rent.CarID));
}
*/
//Outer Join
/* while select car outer join rent where
car.CarID == rent.CarID
{
info(strFmt("%1--%2", car.CarID,rent.CarID));
}
*/
//Exists
/* while select car
exists join rent where car.CarID == rent.CarID
{
info(strFmt("%1--%2", car.CarID,rent.CarID));
}
*/
//Not Exists
while select car
notExists join rent where car.CarID == rent.CarID
{
info(strFmt("%1--%2",
car.CarID,rent.CarID));
}
Subscribe to:
Posts (Atom)