web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Project Cost Variance ...
Microsoft Dynamics AX (Archived)

Project Cost Variance - Timesheet Entry

(0) ShareShare
ReportReport
Posted on by Mohammed Atef Rasheed 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

I have the same question (0)
  • Mohammed Atef Rasheed Profile Picture
    Mohammed Atef Rasheed 2,475 on at

    I am using AX 2012 R2 CU7 version

  • Sandeep Chaudhury Profile Picture
    Sandeep Chaudhury 3,303 on at

    Hi Rasheed,

    Which version of AX 2012 are you on ? You could check the following.

    1. Find the Timesheet that was posted and verify if it was an intercompany timesheet. You would then like to find why the intercompany timesheet was created and posted.

    2. If it was an intentional intercompany timesheet, and you are on AX 2012 R2, CU6 or less, the Project transaction (COGS) account will be debited in the contracting(Borrowing Company) and you will not have any project related transactions in the lending company.

    3. From your explanation, it looks like, you have mapped the same Project COGS main account the Intercompany-Cost posting type as well. Please check this in Project Ledger posting profile.

    With the information you have provided, I only have these initial suggestions for your situation. Please let us know if you need additional assistance on this.

  • Sandeep Chaudhury Profile Picture
    Sandeep Chaudhury 3,303 on at

    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 ?

  • Mohammed Atef Rasheed Profile Picture
    Mohammed Atef Rasheed 2,475 on at

    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

    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

    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

  • Brian Welcker Profile Picture
    Brian Welcker on at

    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

    Dear Sandeep,

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

    Regards.

  • Sandeep Chaudhury Profile Picture
    Sandeep Chaudhury 3,303 on at

    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

    Dear Sandeep,

    Thanks for your update. kindly check the below link

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

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Volodya Profile Picture

Volodya 2

#2
tgudwanski Profile Picture

tgudwanski 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans