Project Cost Variance - Timesheet Entry

(0) Share

Report

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

All responses (12)

Answers (0)

Mohammed Atef Rasheed 2,475 on at

Like (0)

Report

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 3,303 on at

Like (1)

Report

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 2,475 on at

Like (0)

Report

RE: Project Cost Variance - Timesheet Entry

Dear Sandeep,

Thanks for your update. kindly check the below link

www.dropbox.com/.../Voucher.jpg
Sandeep Chaudhury 3,303 on at

Like (0)

Report

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 2,475 on at

Like (0)

Report

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.
Brian Welcker on at

Like (0)

Report

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 2,475 on at

Like (0)

Report

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 3,303 on at

Like (0)

Report

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 2,475 on at

Like (0)

Report

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 3,303 on at

Like (0)

Report

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 ?