Total Pageviews

Search This Blog

Monday, July 22, 2013

Update Troubleshooting Project Hour Journal won't get created automatically while submitting Timesheet in Dynamics AX 2012 CU3

**************************************************************************************************
Update - Thanks heaps to Andre and Sandeep for their responses which confirms my investigation.

I posted this issue in Dynamics forums and got this reply..


Within the build you mention, indeed the hour journal is not used for posting the hours. You can manually or automatically post the timesheets. No hour journals are created then. The timesheet is your "hour journal".
One disadvantage without the hour journal is that there is no possibility to change the ledger date and eventually correct the cost or sales amount in advance.
I believe posting without the hour journal is the way to go, but it should be possible to make adjustments before it gets posted.

You can read the complete post out here..
 https://community.dynamics.com/ax/f/33/p/109594/218725.aspx#218725

Below Sandeep's comments:

In AX 2012 feature pack, when timesheets are approved, they appear in the Unposted timesheets where one can see the distribution of sub ledger. When you post the Unposted timesheet, system registers the project hour transaction but does not create a separate hour journal anymore.

In AX 2012 feature pack, hour journals are no more created.

1. Timesheets sit in the Unposted timesheets form
2. One can view ledger distributions prior to posting it.
3. When posted, system creates the project hour transactions, but does not create any separate hour journals.

***************************************************************************************************


Dear Friends,

Hope you are doing good.

This post is going to be more of an issue which one of my client is facing while creating Project Hours Journal (automatically) via timesheet submission. They are on Dynamics AX 2012 (CU3 Build) - 6.0.1108.670

In Project Management and Accounting Parameters > TimeSheet parameters are set as shown below:


Now, when we submit a timesheet through Home > TimeSheets > All timesheets > Create a new timesheet, we are able to create a new timesheet line and then submit the timesheet. This is done through AX Thick Client.

The batch gets invoked, Initially the timesheet is "In Review" status and then it gets progressed to "Approved" status.

At this stage, we were expecting an hour journal to be automatically created based on the above parameter setting, but we are not able to see the Hour Journal under Projects >  Journals > Hour Journal form.

Then, we go to Unposted Timesheets under Home > TimeSheets to post the timesheet. The timesheet gets posted, but again no transaction is shown under Hour Journal, although we can see the posted transactions under Project > Manage > Posted transactions

Doing some googling around, I came across this article http://technet.microsoft.com/en-us/library/hh271583.aspx

·         Approve – Approve the timesheet. Depending on your version of the product, one of the following things happens:
o    Microsoft Dynamics AX 2012: If this is the last step in the timesheet workflow, an hour journal is automatically created for the timesheet. If you have not configured Microsoft Dynamics AX to post timesheets automatically after they have been approved, you can a view and post the hour journals in the Hour journal form in the Microsoft Dynamics AX client.
o    Microsoft Dynamics AX 2012 Feature Pack or Microsoft Dynamics AX 2012 R2: If this is the last step in the timesheet workflowa subledger journal is automatically created for the timesheetIf you have not configured Microsoft Dynamics AX to post timesheets automatically after they have been approved, you can a view timesheets that have not been posted yet on the Unposted timesheets list page in the Microsoft Dynamics AX client.

I read the above paragraph several times and what I found interesting is that in  Dynamics Ax 2012 standard version (without any hotfixes), once the approval is completed, you can view and post the hour journals in the Hour Journal form, Whereas with the later releases of AX 2012 feature pack (CU2, CU3 etc) it creates a subledger journal and one needs to post the Journal through Unposted timesheets screen and not through hour journal. 

Can anyone please confirm if this is case? 

I did some digging around the Timesheet related classes in AOT, but I can see only a linkage in the TimeSheetPost class which is invoked when the Unposted Timesheet form is invoked other than that during the timesheet creation process, there is no calls to create a Hour Journal automatically, Maybe I'm wrong? 

Any help appreciated. Thanks.







10 comments:

Sandeep Chaudhury said...

Hi Dilip,

In AX 2012 feature pack, when timesheets are approved, they appear in the Unposted timesheets where one can see the distribution of sub ledger. When you post the Unposted timesheet, system registers the project hour transaction but does not create a separate hour journal anymore.

Let me know if you have any other questions.

Regards
Sandeep

Sandeep Chaudhury said...

In AX 2012 feature pack, hour journals are no more created.

1. Timesheets sit in the Unposted timesheets form
2. One can view ledger distributions prior to posting it.
3. When posted, system creates the project hour transactions, but does not create any separate hour journals.

Dilip said...

Thanks Sandeep! It helps

Cheers,
Dilip

workflowax said...

Hi Dilip.

Just a note, we also found that we didn't have transactions generated even though the Timesheet was marked as posted. We discovered this was related to not having all the cost prices setup on the employee, thus there was a 0 transaction amount and thus AX creates no transactions.

workflowax said...

Hi Dilip.

Just a note, we also found that we didn't have transactions generated even though the Timesheet was marked as posted. We discovered this was related to not having all the cost prices setup on the employee, thus there was a 0 transaction amount and thus AX creates no transactions.

workflowax said...

Hi Dilip.

Just a note, we also found that we didn't have transactions generated even though the Timesheet was marked as posted. We discovered this was related to not having all the cost prices setup on the employee, thus there was a 0 transaction amount and thus AX creates no transactions.

Online Timesheet said...

Hi
 Its great to explanation to us how to use the timer tracking for office work bases,i also use the officetimer href="www.officetimer.com>Online Timesheet  that is so comfortable to us .
Thanks
Bhanu Sharma

Online Timesheet said...

Thanks for ur post,i recognize this issue, Its great to explanation to us how to use the timer tracking for office work bases,i also use the officetimer -http://www.officetimer.com/ that is so comfortable to us .
Thanks
Bhanu

Bell Brown said...

I actually added your blog to my favorites and will look forward for more updates. Great Job, Keep it up.

Bi Weekly Timesheet Software Application

Bell Brown said...

Thanks a lot for enjoying this beauty article with me. I am apreciating it very much! Looking forward to another great article. Good luck to the author! all the best!

Web Timesheet service