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?
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
Add thm both together to get Revenue
Sure, thanks.
Project Management & Accounting Module
<Select a Project>
In the Menu, select Fee Management, under [Maintain] select Fee Management
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)
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
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]
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:
Hi bbb0777,
Can you clarify your question and provide some examples?
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156