Skip to main content

Notifications

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 156

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? 

  • bbb0777 Profile Picture
    bbb0777 156 on at
    RE: Project Mgmt & Accounting > Fee Management: Where to see the logic FO is using for Revenue Calcs?

    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

  • bbb0777 Profile Picture
    bbb0777 156 on at
    RE: Project Mgmt & Accounting > Fee Management: Where to see the logic FO is using for Revenue Calcs?

    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? 

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    RE: Project Mgmt & Accounting > Fee Management: Where to see the logic FO is using for Revenue Calcs?

    Hi bbb0777,

    Can you clarify your question and provide some examples?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans