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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Project Mgmt & Accounting > Fee Management: Where to see the logic FO is using for Revenue Calcs?

(0) ShareShare
ReportReport
Posted on by 158

Project Management & Accounting > Fee Management:

We, and our consultants, are having trouble understanding how FO got to its Revenue #s for about 5% of our subprojects.

Normally I'd use a combination of [Line Property] & [Invoice Status]. And that works 95% of the time.

But I'm getting subprojects where say - ok that's a nonrevbill line, but sure seems to be counting for Revenue, and other oddities - what the heck logic are you using FO?

Either documentation (though FO doesn't really seem to be documented per se), or - maybe it depends on our setup - in which case, is there a way to peek under the hood? 

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    303,446 Super User 2026 Season 1 on at

    Hi bbb0777,

    Can you clarify your question and provide some examples?

  • bbb0777 Profile Picture
    158 on at

    Sure, thanks.

    Project Management & Accounting Module

    <Select a Project>

    In the Menu, select Fee Management, under [Maintain] select Fee Management

    5287.Fee-Management.png


    This then gives calculations FO makes.  I'm mostly interested in the Revenue calculation at the moment, though Total Invoiced and WIP too (WIP, presumably simply can be derived via Revenue - Total Invoiced)

    Fee-Management-2.png

    For the most part - I can understand how FO got to those numbers.  About 20% of the time though, I can't.  


    How I try to recreate the numbers (if doing it by hand)

    Project Management & Accounting Module
    <Select a Project>
    Go to Related Information > Posted Transactions

    Posted-Transactions.png

    Look at the transactions

    Use a combination of the following 3, to get Revenue, Invoiced, and thus WIP (Revenue - Invoiced = WIP)
    [Total Sales Amount]
    [Invoice Status]
    [Line Property]


    Posted-Transactions-2.png

    However, about 20% of the time, this logic doesn't quite get the same #s as FO. Usually the issue is Revenue, it seems. e.g. - a line will count as Revenue, but we don't see why, or vise versa. 

    So I was wondering:

    • Is there documentation on how FO comes up with those screenshotted numbers in Fee Management?
    • Or if there's not (probably not), and/or each configuration could be different - where can one see the logic FO is using in their FO install? 

  • bbb0777 Profile Picture
    158 on at

    My understanding now, is that Fee Management was pulling from a different place - ProjTransPosting, whereas I was trying to calculate via the ProjTransSale Tables (ProjEmplTransSale, ProjICostTransSales, etc.).

    In theory they should be equivalent, but because we, how do you say, fucked up, a bunch of our imported transactions from our old ERP - it did not.

    So switched to using ProjTransSales for calculating WIP And Billed, then adding those together to get Revenue.

    At least in our setup

    • When PostingTypeName = 'Project - WIP - sales value', then that's WIP
    • When PostingTypeName = 'Project - invoiced revenue' then that's Billed (but needs to be multiplied by -1)

    Add thm both together to get Revenue

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 517 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 440

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans