Assign users to roles based on the Rule

Posted by Alvin You
2013. 11. 6. 23:13 Dynamics AX

AX 2012의 Role&Security 정의는 생각보다 까다롭다는 이야기를 많이 합니다. 그만큼 Role 정의도 많아졌고, 세부적인 권한 설정까지 정의 하기 위해서는 많은 준비와 시행착오를 감수해야 하기 때문일 것 같습니다.

특히 국내에 보급된 ERP의 메뉴 정의와 권한 셋팅에 익숙해져 있는 국내 IT 관리자들에겐 MS Dynamics AX의 권한 셋팅은 쉽지 않은 작업이라고 생각이 듭니다.

 

오늘은 권한 셋팅 방법 중 하나인 규칙 기반의 Role 할당 방법에 대해서 간략하게 설명을 하려고 합니다.

미리 정의된 직급,직책,부서 단위로 설정된 Query를 통해 관련 사용자 목록을 가져와 자동적으로 연결된 Role에 맵핑을 시켜주는 방법입니다.

 

메뉴 위치 : System Administration >> Setup >> Security >> Assign users to roles

 

Add Rule 버튼을 통해 아래와 같이 미리 정의된 Query문을 가져올 수 있습니다. Query를 추가 하는 방법은 나중에 따로 올리도록 하겠습니다. 아래 Query3를 보시면 별도의 작업을 통해서 추가 할 수 있는걸 확인하실 수 있습니다.

 

AX 2012 프로그램에서 사용되는 단축키 정리

Posted by Alvin You
2013. 11. 5. 00:57 Dynamics AX

AX 2012에 대한 교육 진행시 단축키에 대한 설명을 반복적으로 진행해 주면 고객사 담당자의 반응이 좋답니다.

특히 Ctrl + t, Ctrl + g와 같은 기능은 현업 담당자들을 기쁘게 해 주는 기능입니다.

Description 

Keyboard Shortcut

Help 

F1 

Create a new record* 

Ctrl+n 

Save record 

Ctrl+s 

Open new workspace 

Ctrl+w 

Go to first record in grid 

Ctrl+Home 

Go to last record in grid 

Ctrl+End 

Delete record 

Alt+F9 

Filter by field 

Ctrl+k 

Filter by grid 

Ctrl+g 

Filter by selection 

Alt+F3 

Advanced Filter/sort 

Ctrl+F3 

Remove Filter/sort 

Ctrl+Shift+F3 

Export to Excel 

Ctrl+t 

Move cursor from Sales Order header to order lines 

Ctrl+PgDn 

Refresh the screen with updated data 

Ctrl+F5 

Close all AX screens 

Alt+F4 

Dynamics AX 2012 R2 – Cumulative Update 7 (CU7) released

Posted by Alvin You
2013. 11. 3. 00:40 Dynamics AX

Today Microsoft released a new cumulative update for Microsoft Dynamics AX2012 R2, named Cumulative Update 7 (KB2885603). The version number of this release is 6.2.1000.4051.

You can download the update here.
More information on Partersource and Customersource will be available soon.

There is an installation guide for this update available on the Microsoft Download site. Download it here.

Within this update hotfixes are included as well as some new or enhanced features. Also the prior CU’s are included. It’s good to see Microsoft continues enriching the functionality for Microsoft Dynamics AX even in cumulative updates. There was an additional focus within the next areas:

Update experience

The CU7 update experience is more metadata driven – providing users the ability to view applicable changes, perform impact analysis during install and apply them to their environments on an as-needed basis with auto code update (where possible). The new update experience will also have tighter integration between Lifecycle Services in the cloud and the on premise update installer.

Sales order potency

Create and validate price calculations for sales order items that have a potency. Price calculations are based on the active concentration levels of batch attributes.

Budget planning

  • Create an Excel worksheet template using a wizard.
  • Allocate budget amounts using ledger allocation.

Payroll

Some compliance preparation reports are added for use of the 940, 941, state wage and tax reports. Also preparation reports for VETS and OSHA are available for the US market.

It is possible to create groupings of tax codes that share the same financial data. An user can act on then as group rather than individually. The new tax groups can be used in transaction posting definitions as well.

Another nice enhancement is the functionality for updating benefits rates. A process can be run that compares the default rates to the enrolled rates for each worker and makes any necessary updates. It also provides a way for the user to designate an enrolled rate as “custom” so the update tool will ignore it when processing updates.

You can now use the Payroll cube to analyze information including earnings statements, pay statements, benefit accruals, tax history, arrears, and benefits.

HRM

You can hire or promote a worker using personnel actions. These actions enables the following features:

  • The hire action is added to an action history log for the worker
  • The option to use standard Dynamics AX Workflow before the Hire is committed
  • The option to easily add comments about the hire

Depending on the personnel action type that you use, the hire action can be routed through workflow.

You can now use the HR cube to analyze workforce demographic information, recruiting metrics, compensation, benefits, training courses, seniority, positions, jobs, employment leave, terminations, and more.

On-hand cleanup

The purpose of the On-hand entries cleanup feature is to improve the performance of the on-hand query by deleting records from the inventory on-hand table (InventSum) that are closed and associated with a tracking dimension. Entries in the table that are not associated with a tracking dimension are not deleted. The feature will especially benefit companies that handle large quantities of serialized products.

Product change

Within CU7 functionality is added to document the master data changes needed to accommodate the substitution of a component used in production, and manage the coordinated release of BOMs and routes to production. This functionality is integrated with case management where product cases are routed in this process.

Services industries

It is also good to see some improvements on project functionality:

A Microsoft Project client add-in is included in this update. It enables easy creation and editing in MS Project without requiring Project Server. It supports editing WBS for project, project quotes, and templates including task and category assignment. Additionally it enables tasks to be viewed on SharePoint Online.

Enhancements on the work breakdown structure (WBS) provides a more natural and complete editing surface for project planning, estimation, and monitoring. Several enhancements have been made to provide more effective resource scheduling and assignment. These enhancements include the following abilities:

  • Assign resources using visual, graphic-based tools
  • Form a project team by identifying project roles and competencies required for the team
  • Rationalize team and work breakdown structure assignments • Assign a percentage of a worker’s capacity to a project
  • Make group resource assignments

Also enhancements were made on intercompany project invoicing. The goal of this functionality is to make the control of cost, revenue recognition, taxes, and transfer price for intercompany project transactions in Microsoft Dynamics AX Service Industries more flexible and powerful.

Mobile experiences

Until now you could install updates for enabling functionality on mobile devices such as timesheets and expenses. Within this update this functionality is included out of the box.

Data Import Export Framework

Within CU7 also the Data Import Export Framework is integrated as part of the update. Over 60 entities have been added out of the box. Some new entities are: Number sequence codes, Project contracts and Product variants.

Also the new version of this framework now supports file type XML and Excel.

You can now use a wizard to compare or copy entities from one source company to one or more companies.

 

 

It’s exiting to see the commitment of Microsoft towards the Microsoft Dynamics AX product.

 

That’s all for now. Till next time!

AX 2012 Security Access Level 정의

Posted by Alvin You
2013. 10. 30. 00:15 Dynamics AX

AX 2012 Development I, Chapter 4 (Security)에 나와 있는 Access Level에 관련한 내용입니다.

Correction이라는 항목을 보시면 아시겠지만, 유효한 날짜안에서는 Delete를 제외한 작업을 진행할 수 있습니다.

새롭게 나온 권한 종류라 생소하지만 날짜를 기반에 둔 Business Process 프로그램에 적용하면 될 듯 싶네요.

 

AOT Name
Label Description
No Access No Access Does not provide any access to data.
Read View An end-user can view data.
Update Edit An end-user can view and edit data.
Create Create An end-user can view, edit and create new data.
Correct Correction An end-user can view, edit, create new and correct date-effective record without creating new records.
Delete Full control An end-user can view, edit, create new and delete data.
  Correct is a new level concerning date-effectivity.

Dynamics AX Useful Links

Posted by Alvin You
2013. 10. 25. 22:52 Dynamics AX

Dynamics AX와 관련한 유용한 Links 정보입니다.

 

Microsoft Dynamics InformationSource

 http://informationsource.dynamics.com

Microsoft Dynamics ERP RapidStart Services

 https://www.rapidstart.dynamics.com

Microsoft Dynamics AX 2012 for Developers

 http://msdn.microsoft.com/en-us/library/aa496079.aspx

Microsoft Dynamics AX architecture [AX 2012]

 http://technet.microsoft.com/en-us/library/dd309612.aspx

Unit Test Framework [AX 2012]

 http://msdn.microsoft.com/en-us/library/aa874515.aspx

Sure Step Online

 https://mbs2.microsoft.com/Surestep/default.aspx

The Microsoft Dynamics AX product team blog

 http://blogs.msdn.com/b/dax/

The Performance team blog

 http://blogs.msdn.com/baxperf/

The Dynamics AX Sustained Engineering team blog

 http://blogs.technet.com/b/dynamicsaxse/

 

 

Microsoft patterns & practices   http://msdn.microsoft.com/en-us/practices/bb190332
Architecture Journal   http://www.ArchitectureJournal.net
Application Lifecycle Management (ALM)   http://www.microsoft.com/visualstudio/en-us/strategies/alm
Microsoft Security Development Lifecycle

 http://www.microsoft.com/security/sdl/default.aspx

Visual Studio Test Professional Overview  http://www.microsoft.com/visualstudio/en-us/try/test-professional-2010-tour

Minimizing risk, maximizing returns

Posted by Alvin You
2013. 10. 25. 22:14 Dynamics AX

많은 BP(Business Partner)들이 자사만의 프로젝트 방법론을 통해 AX 프로젝트를 수행하지만, 목표는 성공적인 프로젝트를 수행하고 고객 만족도를 최대화 시키는게 공통 사항이라고 생각합니다.

많은 방법론들이 있지만 대표적인 방법은 MS의 SureStep이라는 표준 방법론이 있습니다. SureStep같이 표준화된 프로세스를 100% 따르기는 힘들어 많은 방법론들이 프로젝트에 꼭 필요한 내용을 기반으로 구성되어 있습니다.

아래 내용은 방법론적인 내용보다는 BP 또는 VAR(Value Added Reseller) 회사들이 AX 기반의 Solution을 구축할때 어떻게 하면 위험요소를 줄이고 이익을 극대화 할 수 있을지에 대해서 MS Dynamics R&D 직원이 도식화 시킨 내용입니다.

Solution을 만드는 과정도 하나의 프로젝트라고 생각한다면, 고객사에 AX Implementation 즉 프로젝트 방법론 중 일부를 아래 단계별 과정을 응용해 프로젝트를 수행하면 좋지 않을까 싶습니다.

 

Import data from Excel file to AX using X++ in AX 2012

Posted by Alvin You
2013. 10. 23. 00:19 Dynamics AX

Excel 파일을 Import 받아 AX에 구성되어 있는 Standard or Developed Table에 값을 집어 넣는 로직입니다. Delphi나 VB, Powerbuilder 개발을 해 보셨던 분들에겐 익숙한 코딩일 듯 싶습니다.

 

static void ReqAmount(Args _args)
{
    SysExcelApplication application;
    SysExcelWorkbooks workbooks;
    SysExcelWorkbook workbook;
    SysExcelWorksheets worksheets;
    SysExcelWorksheet worksheet;
    SysExcelCells cells;
    COMVariantType type;
    Name name;
    FileName filename;
    ReqAmount reqAmount;
    int row;
    str _reqOrderNo;
    int _reqAmount;
    ;
 
    application = SysExcelApplication::construct();
    workbooks = application.workbooks();
    filename = "D:\\ReqAmount.xlsx";
   
    try
    {
        workbooks.open(filename);
    }
    catch (Exception::Error)
    {
        throw error("File cannot be opened.");
    }
 
    workbook = workbooks.item(1);
    worksheets = workbook.worksheets();
    worksheet = worksheets.itemFromNum(1); //첫번째 Sheet
    cells = worksheet.cells();
    do
    {
        row++;
        _reqOrderNo = any2str(cells.item(row, 1).value().toString());
        _reqAmount = cells.item(row, 2).value().int();

        reqAmount.ReqOrderNo = _reqOrderNo;
        reqAmount.ReqAmount = _reqAmount;
        reqAmount.insert();

        type = cells.item(row+1, 1).value().variantType();
    } while (type != COMVariantType::VT_EMPTY);
   
    application.quit();
}

'Dynamics AX' 카테고리의 다른 글

Dynamics AX Useful Links  (0) 2013.10.25
Minimizing risk, maximizing returns  (0) 2013.10.25
RecId란?  (0) 2013.10.20
훌륭한 Dynamics AX Project Manager에 필요한 자질  (0) 2013.10.16
SAP vs Oracle vs AX  (0) 2013.10.13

RecId란?

Posted by Alvin You
2013. 10. 20. 22:44 Dynamics AX
AX 개발자에겐 선배 개발자들이 말하는 RecId라는 말을 그냥 개발자에겐 꼭 알아야 하는 고유명사처럼 많이들 들어봤을겁니다. 하지만 정작 우리가 RecId에 대해 명확히 알고 사용을 하는지 한 번 되새겨 볼 필요가 있어서 RecID 원문 글을 올립니다. 
What is RecId?
The RecId is a unique field in every table, used as an identifier. Every row in the system can be guaranteed (in theory) to have a unique RecId. RecIds can be negative, and their value can change due import/export operations. Due to this, it is not a good idea to use RecIds as foreign key references to other tables.

What is the difference between a RecId and an Id?

The kernel generates the RecId while the Id is generated by the application.

'Dynamics AX' 카테고리의 다른 글

Minimizing risk, maximizing returns  (0) 2013.10.25
Import data from Excel file to AX using X++ in AX 2012  (0) 2013.10.23
훌륭한 Dynamics AX Project Manager에 필요한 자질  (0) 2013.10.16
SAP vs Oracle vs AX  (0) 2013.10.13
AX VS SAP?  (0) 2013.10.12

훌륭한 Dynamics AX Project Manager에 필요한 자질

Posted by Alvin You
2013. 10. 16. 00:20 Dynamics AX

성공적인 Dynamics AX Project 가 되기 위해서는 Project Manager의 역할이 큽니다. 그렇다면 훌륭한 Dynamics AX Project Manager가 되기 위해서는 어떠한 것들이 필요할까요?

 

SAP과 같은 ERP 솔루션들은 SAP BC(Basis)와 같은 SAP과 관련한 Technical 영역을 담당하는 컨설턴트가 별도로 있을만큼 시스템 영역을 전문가가 담당하고 있습니다. 하지만, AX 같은 경우는 X++ 개발을 담당하는 개발자가 System Engineer 역할도 Developer 역할도... 같기도(흔히 이야기 하는 영업 같기도 개발자 같기도 아키텍쳐 같기도 등등 = Multi Player)와 같이 다양한 역할들을 담당해줘야 합니다.

 

Project Manager 또한 다양한 영역에 대한 배경 지식이 없는 한 그 모든것들을 컨트롤 한다는것은 불가능하다고 생각합니다.

 

WescJv

 

http://www.cognitive-group.com/blog/ax/what-makes-a-good-dynamics-ax-project-manager-with-infographic

'Dynamics AX' 카테고리의 다른 글

Import data from Excel file to AX using X++ in AX 2012  (0) 2013.10.23
RecId란?  (0) 2013.10.20
SAP vs Oracle vs AX  (0) 2013.10.13
AX VS SAP?  (0) 2013.10.12
Code for Proxies in Enterprise Portal of AX 2012  (0) 2013.10.11

SAP vs Oracle vs AX

Posted by Alvin You
2013. 10. 13. 23:41 Dynamics AX

Welcome to the ERP Fight Club:

In Today’s match let me introduce you with our fighters:
1.)SAP
2.) Oracle(E-Business Suite)

3.) Microsoft (Microsoft Dynamics)

4.) Other ERP vendors.

Each of these has their own advantages and disadvantages. So to get the clear idea we will compare all of these according to different points. Starting with

1.Market Share:

 

So i think SAP is leading the way in this Game.

2.Average ERP Solution Satisfaction and Benefits Realization.

According to survey carried out over thousands of companies which use the ERP Tools.

SAP Gives : 75%

Oracle Gives : 60%

Microsoft Gives : 58%

Other ERP Vendors gives : 60%

 

So again SAP wins the game. The biggest advantage with SAP is the huge experience which it gets from its client and makes the ERP Tool more Power full to satisfy each and every business need.

3.Average Cost to maintain and implement the ERP Tool

SAP : $16 M

Oracle : $12 M

Microsoft :$3 M

Others : $3.5 M

 

if you don’t want to spend much for ERP tool just go for the last two options.

4.Average implementation Time Duration :

SAP : 15 Months

Oracle : 13 Months

Microsoft : 12 Months

Others : 11 months

5.Business Risk Factor:

This factor is most important as it gives the proportion of the companies that suffered from operational interruptions following go-live are relatively high.