Finance | Project Operations, Human Resources, ...

Project Actual Transactions report-negative hours

(0) Share

Report

Posted on by NMC2

Hi All,

I need some assistance with Project Actual Transactions report

When I pull this report , there I hours that are negative and some hours are positive , but the cost are all positive . Please advise what’s the logic behind this.

This is not the only project report with this negative and positive hours. So it seems there is an explanation. My main concern is if the negative hours represent the credit timesheets , the why would the cost not be credited also.

The timesheets have no record of negative hours and the vouchers do not show any reversals.
There are other transactions with positive hours and amounts?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Project Actual Transactions report-negative hours

Hi,

I am not sure how you created this report/excel sheet but it seems to show payroll allocations.

The posting 'logic' of AX is that a project cost account is debited with the project cost for the hours and the payroll allocation is credited.

Example:

DR: Project cost

CR: Payroll allocation

Amount: 2560.00

Posting timesheets does thus not affect your profit as the DR and CR accounts are usually P&L accounts.

In other words, you post an allocation only.

The 'offset' account to the payroll allocation is your normal wages/salary account that you use for posting the monthly salaries of the employees.

Ideally, the complete wage/salary can be allocated to projects.

This is, however, not always the case and there might be some costs remaining on the wages/salary account depending on the usage of your employees.

Hope that answers your question.

Best regards,

Ludwig

Was this reply helpful? Yes No
NMC2 95 on at

Like (0)

Report

RE: Project Actual Transactions report-negative hours

Thank you so much Ludwig!

This makes sense and I can see the P&L accounts associated.

Sorry if I am not fully understanding, but;

How is the 'correction' or credit of the hours not reversing the allocation?

The hours have been reversed, but the cost has not?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Project Actual Transactions report-negative hours

Hello NMC2,

If you post negative hours then the opposite vouchers are created.

Yet, I am not sure what you mean by 'reversing'.

Can you do the following:

Try to identify one of those transaction at the project level in AX; not in your excel sheet ;-)

You can do that by going to one of the projects and by opening the posted project transactions tab.

From there identify one of the hour postings and select the voucher.

When you see the voucher check the posting type field and the accounts used for posting.

(you might have to personalize the posting type field into the form).

Then make a screenprint and share it here.

Many thanks,

Ludwig

Was this reply helpful? Yes No

Join the conversation

Community site session details

Project Actual Transactions report-negative hours

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Project Actual Transactions report-negative hours

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates