AX 2012 R2 - New Features

Microsoft Dynamics AX 2012 R2 New Feature

This article provides a summary of new feature list that have been implemented in Microsoft Dynamics AX 2012 R2.

Functional area	Feature
Accounting framework	Configure a recurring schedule batch job to clear purchase accrual for product receipt source documents
Accounts payable	Adjust taxes on an invoice line
Accounts payable	Integrate a payment calendar to control due dates for payments
Accounts receivable	Record charges on free text invoice lines
Business intelligence	Enterprise Portal Chart control for visualizing transactional and aggregated business data in Enterprise Portal
Business intelligence	Improvements to key performance indicators (KPIs)
Business intelligence	Support for data partitions in cubes
Business intelligence	Support for data partitions in reports
Business intelligence	Support for Power View
Business intelligence	Support for report servers running in SharePoint integrated mode
Business intelligence	Windows PowerShell commands for deploying cubes
Budgeting	Create and approve budget plans
Client and server	Enhancements to the Named user license count report (server)
Client and server	Microsoft Dynamics AX 2012 database split into two databases (server)
Data partitioning	Data partitions have been enabled to support data isolation
Enterprise Portal	Enterprise Portal in Microsoft Dynamics AX 2012 R2 supports Microsoft SharePoint 2013 Products and Technologies
Microsoft Office Add-ins	Localize data in the Microsoft Office Add-in
Microsoft Office Add-ins	Lock a template created by using the Office Add-in
Microsoft Office Add-ins	Microsoft Office Add-in enhancements
Sales and marketing	Cases are secured by case category
Sales and marketing	Generate a lead or opportunity record from a campaign or call list target record
Sales and marketing	Update the name of a party from the party record
Sales and marketing	Update, in bulk, the list of party records assigned to an address book
Sales and marketing	Updates to Sales and marketing Role Centers and the reporting information provided
Setup and upgrade	Data partition assignment for companies during upgrade

Indian Localization features in AX 2012 R2:

Country/region	Feature
India	Accounts receivable and accounts payable invoices
India	Assign financial dimensions to entries generated in the Transfer orders form
India	Automatic calculation of Tax Deducted at Source (TDS) when no Permanent account number (PAN) is registered
India	Bill of entry information is evaluated on a line-by-line basis
India	Cancellation of Bill of entry and invoice registration for India
India	Change to the item type for India
India	Changes to number sequences for Indian financial documents and incentive schemes
India	Changes to the electronic file format for TDS and TCS statements
India	Depreciation calculation for India
India	Duties and privileges added for user roles in features for India
India	Enhancements for purchase and sales orders for India
India	EXIM Advance Authorization (AA) incentive scheme
India	EXIM Duty Drawback (DBK) incentive scheme
India	EXIM Duty Free Import Authorization (DFIA) incentive scheme
India	EXIM Export Promotion Capital Goods (EPCG) incentive scheme
India	Expanded tax type support for project transactions, billing processes, and tax settlements
India	Expanded tax type support for service industry transactions
India	Financial dimensions for India
India	Fixed asset transfer for India
India	For India customs duty and Export Import Policy (EXIM), if the charge as expense ratio is used, the related customs duty is charged to the expense account
India	General ledger updates for India
India	Generation of financial statements in Microsoft® Excel for India
India	Global address book for India
India	Implementation of withholding tax calculation cache
India	Improvements to tax registration number assignments
India	Manual adjustment of taxes
India	Open customer invoices and settlement enhancements for India
India	Organizational model enhancements for India
India	Point of taxation
India	Recalculation of indirect taxes triggered by specific conditions
India	Sales and purchase orders enhancements for India
India	SLJL impact on the Indian custom duty functionality
India	SLJL impact on the Indian excise duty functionality
India	Standard Input Output Norms (SION)
India	Tax rate enhancements for India
India	The method of adjusting direct tax entries that are posted to the general ledger has changed. This feature replaces the feature for TDS and TCS adjustment, which is now deprecated.
India	Threshold exceeding error/warning message removed from India direct tax
India	Update tax information in a corrective free text invoice
India	Update to the Upgrade toolkit
India	Updates to general ledger and tax inquiry forms
India	Updates to import orders for India
India	Uptake of the subledger journal and distribution framework with Indian direct tax
India	VAT commodity codes on sales invoices
India	View and modify accounting entries before posting to the general ledger

 

Indian Localization in AX 2012 CPT - Oct 22-25

Indian localization in AX 2012 R2...

Indian Localization Parameters – General Ledger



Stock Transfer activation parameter as part of Indian localization

Stock Transfer

Company Information – Tax details

Indian localization – General Ledger

 

EXIM -

 

Formula Designer:

 

Thank you and Happy DAXing... :)

 

The backup set holds a backup of a database other than the existing database

The backup set holds a backup of a database other than the existing database.

Solution:

I have solved the Issue following the below steps.

§  Use WITH REPLACE while using the RESTORE command
§  Execute the following SQL Query

Alter Database MicrosoftDynamicsAX_model

      SET SINGLE_USER With ROLLBACK IMMEDIATE  

RESTORE DATABASE MicrosoftDynamicsAX_model

      FROM DISK = 'D:\AX2012\MicrosoftDynamicsAX_model.bak'
      WITH REPLACE

Thank you and Happy DAXing... :)

Updated Query:

ALTER DATABASE AX_IntegrationDB

SET SINGLE_USER WITH

ROLLBACK IMMEDIATE

RESTORE DATABASE AX_IntegrationDB

FROM DISK = 'D:\SIngu\AdrenalinSharedDB.bak'

WITH MOVE 'AX_IntegrationDB' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.DARWIN\MSSQL\DATA\AX_IntegrationDB.mdf',

MOVE 'AX_IntegrationDB_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.DARWIN\MSSQL\DATA\AX_IntegrationDB_log.ldf',

REPLACE

Step by step import with Data Migration Framework - AX 2012

Continuation to my previous article “AX 2012 Data Migration Framework”

In this article, we are Importing the LedgerGeneraljournal into AX 2012. 

Demo Files are available at:

C:\Program Files\Microsoft Dynamics AX 2012 Data Migration Framework (Beta)\DemoFiles

This is the beta release and therefore there will be bugs, issues and it’s not a complete offering. With that, when we start to look at the use of this framework, we must start with the types of sources we can work from. We do this from the Data Migration Framework > Setup > Source Data Formats. 

Apart from flat file, MS is planning to add Ax and ODBC types to the framework.

We can see that there are plans then for allowing both ODBC source types, as well as enabling AX-to-AX, source-to-target usage of this framework. Since this is file based on source types for the Data Migration Framework, out-of-the-box usage for the framework is limited. It’s powerful, and has a lot of great possible value, specifically when the AX and ODBC types are fully added. DMF is work well with the file sources, as I have tested and imported some of the data. If your source data is in flat files then you can start getting a lot of use from the framework.

1. Click on Data Migration Framework > Setup > Source data formats to set up your source data format.

2. Applications:  you can select your dimensions. The Dimension code lookup is a multiselection lookup (tick the selection box on the left of the lookup and ok).

3. Click on Data Migration Framework > Common > Processing group. Create a new record and give it a name and description

4. From the Processing group form, click on Entities.

Create a new record for the LedgerGeneraljournal. If we are selecting data from demo flat files, select the path in The Sample file path field or else you want to select (modify) the fields then leave The Sample file path field will be blank.

If you use the Demo files, then skip steps 5, 6 and 7. If you want to modify the columns, then do steps 5, 6 and 7, as it will ask you if you want to modify the existing file format.

5. Generate a sample file by clicking on Generate source file button. Follow the wizard and select the fields to import.

6. Then click the Generate sample file button. This will open up the sample file in notepad.

Click Finish when done.

7. Now fill in your data on the txt file.

8. Back on the main form click the Generate source mapping button. This will analyse the file and do the mapping between the file and the stagging table.

9. Now you can open and view the mapping by clicking on the Modify source mapping button.

It should looks something like this. The Source is your txt file and the Staging is your staging table in AX. If 

your source file is messed up, you should be able to see it here.

10. Now validate the setup by clicking the Validate button on the main form.

11. View target mapping. This is a mapping between the Staging to the Target table. This should already be predefined. You can however modify the mapping.

The Function options on the left. These are predefined methods in the class to allow you to execute business logic. The example below, when you pass in a string of dimensions A-B-C, the GenerateDefaultDimension function splits the string up and generates a DefaultDimension RecId.

12. When we check the Entities from, Click the Preview source file button. This loads up the file, to give you a preview of your file.

13. In Processing group form and click the Get staging data. This opens up a dialog with the processing group, click OK. You will then get this form.

Click on the Run to run client side or Click on Run on AOS to run server side. Usually, the user account doing the import wont have access to SQL integration servers. Use the second option and it will run under the service account. This should run and complete with out errors.

14. Now you can see the staging table by going to the Execution history from the Processing group form. From there you click the View staging data button. You can modify the staging data before you process it to the target.

15. To process to the target, click on the Copy data to target button. Follow the options to execute the process.

It’s done, Now the data has been migrated to AX 2012.

That's it for now... :)