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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Unable to see the Actual invoice in Project Statements

(0) ShareShare
ReportReport
Posted on by 105

Dear Friends,

I created a Fixed Price project and posted some hour transactions. So, the cost is booked. Based on this cost, I have run the Estimate and posted the accrued revenue. The details are below:

pastedimage1575353424929v2.png

pastedimage1575353164194v1.png

Accrued Revenue is 10,000

Now, I wanted to book the actual revenue. So, I created and Invoice Proposal (Based on Milestone defined in the billing rule). The details are follows:

pastedimage1575353504908v3.png

But, when I look at the project statement, the actual invoice is not getting reflected. The invoiced revenue is still showing 0 

pastedimage1575353542371v4.png

As per my posted invoice, the actual revenue should be 12,000. Should I reverse the accrued revenue? Even if I reverse, will system show the invoiced revenue? Theoretically, when I have actual revenue, my P&L should be based on the Invoiced revenue and not from Accrued revenue. Am I right?

I have the same question (0)
  • Prabhath-AX Profile Picture
    105 on at
    RE: Unable to see the Actual invoice in Project Statements

    Status of Project Group is below

    pastedimage1575354000546v1.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Unable to see the Actual invoice in Project Statements

    Good Morning Anthony,

    With this project / project group setup the revenue will be created at the time the estimate is posted. That's your revenue that you should see in the P&L statement form/section.

    Invoicing a milestone is a pure balance sheet transaction that debits and credits balance sheet accounts. As a result, no P&L effect arises when you create the project invoice.

    Best regards,

    Ludwig

  • Prabhath-AX Profile Picture
    105 on at
    RE: Unable to see the Actual invoice in Project Statements

    Dear Ludwig,

    Good Morning & Thanks for the quick reply...!!

    So, when does the Invoiced Revenue gets updated? At some point, should the recognized revenue be reversed and Invoiced revenue booked? Means, from BS Account, it posts tp my P&L account in GL? Appreciate your earliest response.. In My screenshot below, even the on-account also shows 0 despite I have posted an invoice of 12,000

    pastedimage1575355628675v1.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Unable to see the Actual invoice in Project Statements

    Hi, 

    I am afraid but the revenue recorded won't move 'up' in your project statement and will remain as accrued revenue. 

    Below, some screenprints from my second book where I provided a number of examples how this posting process works for your project group setup configuration. 

    You might not be able to follow up the different numbers but the posting process should become clear from those illustrations. 

    Best regards, 

    Ludwig

    POC1.png

    POC2.png

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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,882

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 794 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 525 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans