How to Calculate Month Difference Between Two Dates – Excel Formula 1

Excel is an essential tool for a consultant life and especially for functional ones. In this interesting and helpful excel series, we will try to share few quick excel formulas which we may need on regular basis. Today I got stuck into one situation where I wanted to calculate month […]

How to Open Details Form in Default Edit / View Mode in Ax 1

When you open a record from list page, the default behaviour of record is to open in view mode. In cases where you do a lot of editing, you would like to cut down your no. of clicks. To open a record in default edit mode may save you one […]

Auto-Complete Text in the Windows Client for Ax Users

Ax has an in-built parameter to remember text that user typed in the past and recalled that text when you type it next time in the future. This is a handy tool and minimise your text typing. There is a parameter to turn off this option if you do not like […]

How to Edit Number Sequence for Purchase Requisition in Ax 2012 1

While working on one of the requirement, I had to enable Purchase requisition process. While trying to change the number sequence for purchase requisition, I couldn’t find the way. When investigated, I found it is not a company specific but a global set-up (1 sequence for all companies). When you […]

What is the difference between SSIS, SSRS and SSAS?

SSIS: SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing. SSIS is the new name assigned to the component formerly branded as Data Transformation Services (DTS). SSIS (SQL Server Integration Services) is […]

Error : Worker cannot be deleted while dependent Position worker assignments exist. Delete dependent Position worker assignments and try again in Ax 2012

While deleting a Worker / Employee in HR module in Ax, sometimes we face the following error message; This error comes since employee is linked to a position. We need to delete the position first to delete the worker / employee, however there is no delete option on position form. […]

How to Generate Standard Report in DD/MM/YY format in Ax 2012

While working in multiple countries, a major requirement comes from the clients of how to generate standard reports in DD/MM/YY format. When analysed the reason, we came to know that our language setting which makes this difference. We were selecting “en-us” when a new entity is created. Solution: Navigate to […]

How to auto populate the Country code when adding addresses in Dynamics Ax 2012

In this post, we will let you know how to auto populate the country code when adding new address in Dynamics Ax 2012. This can be very meaningful and time saving requirement if you have users in multiple countries that are entering new addresses for Vendors, Customers and Workers. When […]

How to Change Number Sequence of Business Unit / Cost Centers / Departments in Ax 2012

Navigate to Organization administration > Common > Number sequences > Number sequences Find the sequence named as ‘Orga_1’ (Organizational Number)     Select to edit that record. Go to the ‘General’ section and put a check in the “Manual” check box.     Now you can manually add the Department / Cost […]

Job Costing in Service Industries

A very valid question strikes our mind if job costing is only used by Manufacturing industries; Answer is No! Many Service industries use job costing as well. Courier Service Companies, Accountants, Electricians are some of the examples of service providers which use job costing. Electricians track costs by project (i. […]

What are Intrastat transactions

Intrastat applies to Imports and Exports within the E.U. only.   EU traders with imports or exports exceeding certain thresholds are required to submit bi-monthly intrastat reports. Under these thresholds, summary data is required to be reported, as in the case of Ireland, all VAT registered traders operating within the EU […]

Project Integration Management

This chapter covers key concepts related to Project Integration Management. The knowledge area of Project Integration Management consists of the following seven processes – Project Integration Processes               A project charter Formally authorizes the project. Gives the objectives and business case Identifies the Project […]