“The Value FeeRet in the Category field is not valid according to the Category setup” Error in AX 2012

“The Value FeeRet in the Category field is not valid according to the Category setup” Error in AX 2012

Friends,

I have been busy in work after my long vacation  and break from blogging.

Today, I just wanted to write a quick post about troubleshooting an error which you might face while submitting invoice proposals which has retention enabled in it in Microsoft Dynamics AX 2012.

If you come across the error with message“The value “ FeeRet“ in the Category field is not valid according to the Category setup” , where “FeeRet” is the customer payment retention category, then make sure that The “Active in journal” and “Customer payment retention” check boxes are marked in the Category setup under Project Management and Accounting > Setup > Categories > Project Categories.

Refer to screenshot below.

image

Note : Please note that, if you select the ‘Customer payment retention’ check box prior to the ‘Active in journal’ check box, then you cannot mark the ‘Active in journal’ check box anymore, as it will be disabled.

Hope this will help. Lot of new exciting posts coming soon. Stay tuned.

Keep DAXING Smile

Sandeep

Committed Costs in Project Management in Microsoft Dynamics AX 2012

Committed Costs in Project Management in Microsoft Dynamics AX 2012

Efficient cost management in Projects is always one of the key aspects to ensure that the project remains optimally profitable, especially in cases of fixed price contracts where revenue remains fixed. A clear visibility of all aspects of the cost data in the project helps the Project Budget Manager or Project Controller to ensure that the expenses in the project are well controlled and the project is adequately funded on time.

The common practice followed widely by most of the Project organizations is to establish a project budget for the costs and then track the actual project costs(Realized costs) against it, to arrive at the remaining budget balances, % of work complete in the project etc., for the managers to take suitable actions on funding effectively.

While the actual costs/realized costs gives the required visibility to the remaining budget balances of a project, there is one other cost component which should be considered. This is called the “Committed costs”.

The “Committed costs” are the project expenses that are used over a period longer than the cost reporting period. An example of this is the materials and services(Subcontractors and Consultants) getting used in a project. Once a purchase order has been issued to a supplier or subcontractor, then the funds for that purchase order are “Committed” by the organization.

In today’s post we will take a look the “Committed costs” functionality for Projects in AX 2012 and discuss how this could be helpful for service industries such as the Construction, advertising and media where the subcontracting services are usually used for a longer time period.

The first thing to understand is the parameter setup under the project module. Notice that Dynamics AX 2012 makes it flexible and allows users to designate all the types of transactions which could form a cost component in a project, in stead of just limiting this to just Purchase orders and Vendor invoices. Users can select or deselect these transaction types to decide if they want those to be reflected as “committed costs” in the projects. Take a look at the screen below.

image

In this case, I will consider the purchase order, Item journals and vendor invoices as committed costs. I will also create a Fixed price project and then allocate budget to it and finally post some purchase orders, item journals and vendor invoices for this project to see how the “committed costs” work.

Below screenshot shows the total budget which I have defined for this project for the items and the subcontracted labors.

image

We will now post some costs on this project by booking few hour journals to record some actual costs on the project. See the screenshot below which shows all the details in the Project budget balances screen. This shows that there are no commitment costs/committed costs.

image

Now let us create a purchase order(Do not post) and book a vendor invoice and see the impact on the committed costs. After creating the purchase order and vendor invoice for the project, navigate to Project Management and accounting > Periodic > Committed costs > Generate committed costs and click OK button. (Ideally this could be set to run in batch automatically).

image

Now let us enquire the project budget balances and see how system automatically shows these as committed cost so that project budget manager or project controller gets a better visibility of the costs for this project.

image

Also, you can navigate to Project > Control Tab > Costs > Committed costs button and system will show the details for all the committed costs on the project in this screen and users can click the Item tasks button to go to the source document which forms the basis of the committed cost and then take suitable actions.

image

Hope this post was helpful.

Thanks

Sandeep

Microsoft Dynamics AX 2012 Launched in India

Microsoft Dynamics AX 2012 Launched in India

The wait is finally over !!!

Microsoft Dynamics AX 2012 is now launched in India. India has been one of the key emerging market segment for Microsoft Dynamics AX ERP over the years and the launch of Dynamics AX 2012 in India will definitely gain attention with its new improved and powerful purpose-built solutions for Manufacturing, Distribution, Retail, Public sector and Service Organizations. Stay tuned.

Read more http://gadgets.ndtv.com/laptops/news/microsoft-launches-dynamics-ax-2012-in-india-300731

Automated Tasks in Workflows in Microsoft Dynamics AX 2012

Automated Tasks in Workflows in Microsoft Dynamics AX 2012

The workflow engine of Microsoft Dynamics AX ERP has been one of the very important and capable tool over the different versions. It helps users to automate and streamline several business processes in the organization across several departments. Now, with Microsoft Dynamics AX 2012, the workflow engine gets even more stronger with the introduction of additional capabilities such as,

  • Easy-to-use graphical workflow components which allows users to create new workflows with easy drag and drops.
  • Parallel activities enables multiple users to take action on an workflow item simultaneously.
  • Sub-workflows works seamlessly under the main workflow.
  • Automated tasks, which if used properly, can prove to be very useful and efficient.

Microsoft Dynamics AX-Powerfully Simple

Recently I got chance to learn the automated tasks in AX and in today’s post, I will explain how we can configure automated tasks in a workflow and how it can help business in real time.

Tasks such as posting transactions and generating reports or verifying results can run automatically or require an user intervention in Dynamics AX. In AX 2012, a workflow can contain both manual tasks(Requires user intervention) and automated tasks(Does not require user intervention).

AX 2012 provides few automated tasks out of the box in some the workflows such as expense reports, budget entry workflow etc. However, you can create automated tasks as per your requirements, with a little help from your technical team.

Let us assume a scenario, where we want to automate the “Credit limit check” for customers while approving Sales orders or Free text invoices, so that the automated task will complete the credit check and send the result to the workflow owner/user for them to take further actions.

Below are the high level steps which you can follow to create a new automated task.

  1. Open AOT.
  2. Expand the Workflow node and go to Automated tasks node.
  3. Right click the automated tasks node and click New automated task.
  4. Now, right click the newly created automated task and go to properties.
  5. Set Name, Label , configuration keys.
  6. For the Document property, select the workflow document for which you need this automated task.
  7. In the Execution event handler property, select the event handler class which will actually run the Customer Credit Limit check. Here you can have your technical team’s help to create the Execution event handler class for you. Once you have the event handler class ready, select the same, in this property.
  8. And you are done.

image

For this demonstration in the post, I have not created the Event handler class for customer credit limit check. So, I will use an existing automated task (Automatic posting of expense reports) and demonstrate how it can be used in workflows.

Follow the steps below to configure an automated task in a workflow.

  1. Go to Travel and Expense Management > Setup > Travel and Expense Management workflows.
  2. Create new Expense report workflow.
  3. Notice that the expense report workflow which comes out of the box, does not have the automated task, but you can configure it in the Workflow type.
  4. To do this, go the AOT > Workflow > Workflow Types and select the TrvDocumentTemplate.
  5. Expand the Supported elements node and drag and drop the automated task here.
  6. See the screen below where I have configured the automated task of Posting the expense report.

image

7.  Now, see the screen below which shows one very simple workflow which I have configured with the automated task is it.

image

8. When the workflow is run and it gets reviewed and approved, the workflow will be able to post the expense report automatically without requiring user intervention.

9. Also, note that there will be no outcome after an automated task in run inside the workflow. The status will just changed to “Completed”. If you need outcomes for automated tasks, then you can write custom code with help from technical team.

So, with few easy steps and custom code, Microsoft Dynamics AX 2012 makes it easy to automate lot of tasks in the business process which may not require an intervention.

Hope this post will be helpful. Do not hesitate to contact  if you need help on this.

Thanks

Sandeep

Now Process your U.S.Payroll In-house with Microsoft Dynamics AX 2012 R2

Now Process your U.S.Payroll In-house with Microsoft Dynamics AX 2012 R2

Microsoft Dynamics AX is POWERFUL yet again !

With the strong enhancements to the global talent management functionality and introduction of end to end U.S. Payroll processing functionality within AX 2012, in the R2 release, Microsoft Dynamics AX now gets even more powerful.

Below are few of high level capabilities of the U.S. Payroll functionality in AX 2012 R2 release. Read the MS Product team’s blog Here for more details about this.

  • Seamless integration of the U.S. Payroll functionality with the Human resources management allows one time setup of all payroll related data and parameters such as “Deductions”, “Benefits”, “Compensation” etc.
  • Seamless integration with Financials management module facilitates printing of pay checks or direct deposits into employee’s savings/checking accounts.
  • Employees can view their Pay statements on the Employee Self-services portal.
  • Easy tracking of the regular pays and the exceptional based earnings such as Paid time off etc.
  • And More…..

Thanks

Sandeep

Taking advantage of the On hold funding sources in Project Contracts in Microsoft Dynamics AX 2012

Taking advantage of the On hold funding sources in Project Contracts in Microsoft Dynamics AX 2012

Hi,

Hope everyone is doing well and having great times in this festive season.

In today’s post I will discuss a very small and useful functionality which is introduced in the project management and accounting module of AX 2012. This is the new “On hold funding source type” for project contracts.                                                                       

When you use the funding limits on the project contracts, the “On hold” funding source can prove to be very useful in allocating any transaction amounts which exceeds the specified funding limits for the other funding sources present in the project contract. The on hold funding source is referred to one of the internal organizations of AX 2012, which are the business units setup in the company.

Let me now elaborate this with an example.

Let us say there is a project contract with one customer as funding source and one on hold funding source. Also there is a funding limit of $2000 for the customer which is the funding source for the project contract. Take a look at the screen below for such a project contract.

image

Now, let us post few transactions on the project belonging to this project contract, such that the amount exceeds $ 2000 and see how the on hold funding works. The below screenshot shows an hour journal posted on this project such that the total sales amount exceeds $2000, the funding limit for the customer.

image

If we go to the project posted transactions and take a look at the funding allocation, this will show how the exceeded amount of $100 is allocated to the On hold internal funding source and the allowable $2000 is allocated to the customer funding source.

image

image

Now that the exceeded amounts are allocated to the On hold funding source, you can use adjustment function later to allocate these amounts back to the funding source when funding limit changes after agreement with the customer. The advantage of having the On hold funding source is that, it will allow posting of transactions even if the sales amount exceed the specified funding limits for the funding customers in the project contract.

Let us now change the funding limit to $3000 as the customer has agreed upon the same and then run adjustment for the transaction to see how the amount which was allocated to the On hold funding source, gets allocated back to the customer.

Funding limit change is shown in screen below.

image

After you change the funding limit for the customer in the project contract, adjust the transaction to see the impact how the transaction gets allocated back to the funding source.

Select the adjusted transaction and verify the transaction to see that the amount $2100 is now allocated to the funding source which is Forest wholesale.

image

image

Powerfully Simple. Microsoft Dynamics AX 2012.

image

Feel free to ask any queries about this.

Thanks

Sandeep

Managing Travel Requisitions in Microsoft Dynamics AX 2012

A travel request is a business process where the employee/traveler takes a pre-trip approval from their managers or superiors. A travel request/requisition may contain information such as the date, destination, purpose of the travel and also details about  transportation, accommodation, cash advances and overall estimated cost of the travel.

The travel requisition functionality in Microsoft dynamics AX 2012 is a system aided way of managing the submission and approval of business travel trips. This is a source document which contains the details of the expenses which will be incurred on a travel.

In today’s post I will explain the travel requisition process functionality of AX 2012. Before we look at the steps for processing a travel requisition in Microsoft Dynamics AX 2012, let us  know how it can help organizations to control expenditures, specifically when they work on fixed price projects and the travel expenses must be under the budget of the project.

  • It can be made mandatory for employees to get approval of a travel request prior to the travel.
  • Several travel request policies can be setup at the Project, customer, and resource levels in terms of expense amounts on different expense categories.
  • Travel requisitions can apply in cases whether the employees are charging the expenses to a corporate credit card, using cash from a cash advance or even out-of-pocket expenses which employees may incur and gets reimbursed for those later.

Travel requisition business process:

The first step involved in the travel requisitions management process in AX 2012 is to configure a workflow as desired by the business. Configure this workflow under the Travel and expenses module.

image

The next step is to set up all required travel request policies as per the business needs. Do the required policies setup under the Travel and expenses module.

image

If the business needs that pre trip approval is mandatory before employees submit their expenses, optionally enable the required parameter in the travel and expense parameters.

image

Once the prerequisites are all configured, let us now have an employee submit a travel request.

Navigate to Employee self-service portal > Expenses > Travel Requisitions.

Create new travel request and key in all the required details as shown in screen below.

image

In this post, the focus is only to highlight the prerequisites and various capabilities of the travel requisition functionality in Microsoft dynamics AX 2012.

You can proceed further in the process to complete the following and see the real-time impacts and results.

  1. See the travel request policies and workflow in action when employee submits the travel requisition.
  2. Submit the travel requisition.
  3. Travel request gets reviewed and approved by Managers.
  4. Employee has come back from the travel trip and prepares his expense report for submission.
  5.   See the travel request mandatory in action during expense submission.
    Feel free to ask any related questions on this and I will be glad to answer.
    Thanks
    Sandeep