Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Project Cost Variance - Timesheet Entry

Posted on by 2,475

when generate project cost report from General Ledger "Account Balance" and compare it to projects costs from all projects reports "Category Actual Transactions" for example system is showing big variance. " GL show amount more than Project Module Report"

after making some investigation, I noticed that the variance exactly came from some timesheet entry. the transactions are posted to GL with posting type "Inter-company Cost".

These transactions are not affecting the project reports.

I do not have any inter-company timesheet entry. how can I solve this deference issue ?

I need to affect the project reports to be the same as GL affect?

*This post is locked for comments

  • Mohammed Atef Rasheed Profile Picture
    Mohammed Atef Rasheed 2,475 on at
    RE: Project Cost Variance - Timesheet Entry

    Dear Sandeep,

    Thanks for the support. please advice how we can connect so you can check this issue

  • Sandeep Chaudhury Profile Picture
    Sandeep Chaudhury 3,303 on at
    RE: Project Cost Variance - Timesheet Entry

    You case really seems strange.

    With what I have seen so far in various screenshots, I can confirm that you have intercompany timesheets in place. Moreover, you should have the Project Posted transactions as well.

    I think it is also little difficult to trace the whole thing together here in this conversation chain in bits. You can connect with me, if you would like me to look into your system to recommend more.

  • Mohammed Atef Rasheed Profile Picture
    Mohammed Atef Rasheed 2,475 on at
    RE: Project Cost Variance - Timesheet Entry

    Dear Sandeep,

    Thanks for your update. kindly check the below link

    www.dropbox.com/.../Voucher.jpg

  • Sandeep Chaudhury Profile Picture
    Sandeep Chaudhury 3,303 on at
    RE: Project Cost Variance - Timesheet Entry

    Hi Rasheed,

    I reviewed the screenshots, from those, I could not conclude if the timesheet you provided was the origin.

    Can you please provide a screenshot of the "General" tab of the voucher transaction line you have in the screenshot ?

  • Mohammed Atef Rasheed Profile Picture
    Mohammed Atef Rasheed 2,475 on at
    RE: Project Cost Variance - Timesheet Entry

    Dear Sandeep,

    Did you find solution for my case. I shared some screen shot. kindly advice if you need more details.

    Regards.

  • RE: Project Cost Variance - Timesheet Entry

    Sorry, I responded before I saw the whole thread. I'll take a look at the screenshots.

  • Mohammed Atef Rasheed Profile Picture
    Mohammed Atef Rasheed 2,475 on at
    RE: Project Cost Variance - Timesheet Entry

    Dear Sandeep,

    Kindly check the below screen shot, the affect on the project transaction = zero.

    www.dropbox.com/.../MainAccount%20Transactions.jpg

    www.dropbox.com/.../Transaction%20Origin.jpg

    www.dropbox.com/.../TS%20Entry.jpg

  • Sandeep Chaudhury Profile Picture
    Sandeep Chaudhury 3,303 on at
    RE: Project Cost Variance - Timesheet Entry

    HI Rasheed,

    With the situation and information about your query here, I could only suggest the following.

    1. If you are able to see the GL Transactions with Posting type as 'Intercompany - Cost", try to see the origin of the transaction from the GL voucher. This should help you to trace the timesheet document, if at all it is originated by it. You should be able to easily trace of the origin of these transactions.

    2. It would be helpful to some screenshots of the GL transactions, their voucher and transaction origin.

  • Mohammed Atef Rasheed Profile Picture
    Mohammed Atef Rasheed 2,475 on at
    RE: Project Cost Variance - Timesheet Entry

    Dear Sandeep, Thanks for your reply.

    I do not have any setup for intercompany timesheet. In Project parameter, the intercompany sheduleing is not enabled, and in the posting profile, no account defined for intercompany cost.

    please advice

  • Sandeep Chaudhury Profile Picture
    Sandeep Chaudhury 3,303 on at
    RE: Project Cost Variance - Timesheet Entry

    I just saw this after I posted my first reply. So if you are on CU7, do you have business scenarios for using intercompany timesheets at all ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans