Managerial Hierarchy based workflow configuration for Timesheets does not work as expected when Timesheet is submitted by a Delegate in AX 2012

Managerial Hierarchy based workflow configuration for Timesheets does not work as expected when Timesheet is submitted by a Delegate in AX 2012

Friends,

Hope everyone is doing well.

Just wanted to share a quick information about an issue which you may face while implementing Timesheets approval of workers based on a Managerial Hierarchy.

When you setup the Timesheet review workflow as “Hierarchy” based and setup appropriate reporting positions for the workers, you will notice that the timesheet when submitted “by a Delegate” for an employee, will get routed/assigned to the reporting manager of the delegate(who submits the timesheet), instead of getting assigned to the reporting manager of the actual employee.

This is a known issue in AX 2012 feature pack(until the CU4 release) and you will need to make a code correction by taking help of your developers.

However in the R2 release of AX 2012, this issue is taken care by the introduction of a small “Design change” in the workflow configuration. In the R2 release, you will be able to select “Worker” as the “Start from” location for the workflow. This will ensure that the timesheets even though submitted by a delegate, will get routed/assigned to the reporting manager of the timesheet worker/employee, but not to the reporting manager of the delegate. See screen below.

image

Please shoot questions in case you have any in this regard.

Till next time !! Keep DAXING Smile

“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

Preparing Financial Statements with financial dimensions getting printed in different Columns in the report in Microsoft Dynamics AX 2012

Sometimes companies may want to generate their financial statements with one or more of their financial dimensions getting printed in different columns of the financial statement report for comparison and review purpose. For example, a company may want to generate the income statement with the data for each of its “Business Units” getting printed in separate columns in the report.

Take a look at the dummy screenshot of such a report below.

Sample Income Statement

Here are the quick guide lines how to achieve this in Microsoft Dynamics AX.

1. First of all, configure the financial statement by navigating to General Ledger > Setup > Financial Statement > Financial statement.

2. Define the financial statement column structure as shown in sample screen below.

Financial Statement Column Structure

3. Now assuming that your row definition for the financial statement is ready, let us go and generate the financial statement.

4. Navigate to General Ledger > Reports > Transactions > Financial Statement. Key in the values for financial statement, Row definition(If not already defaulted from financial statement) and click the Columns tab.

Generate Financial Statement

5. You will notice the 3 columns(Current) which we configured in the financial statement.

6. Select the first record and click Select button.

Select Business units/Financial dimensions during report generation

7. Click Add button and select the business unit financial dimension in the “Field” and provide the criteria value(For example BU-001)

Select the financial dimensions

8. Repeat steps 6 and 7 to complete this for business unit 2 and 3.

9. Click Ok button and we are done. This will print the financial statement as depicted in the sample screenshot above in this post.

Companies may also have different financial dimensions like Territory/Region, Product Line etc. They may also report based on these financial dimensions with having these printed in separate columns in the report.

Complex Reporting !!! Made Powerfully simple. Smile

Microsoft Dynamics AX 2012 - Powerfully Simple