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

(0) Share

Report

Posted on by bbb0777

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)

All responses (3)

Answers (0)

André Arnaud de Cal... 300,721 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
bbb0777 158 on at

Like (0)

Report
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

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:

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?

Was this reply helpful? Yes No
bbb0777 158 on at

Like (0)

Report
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

Was this reply helpful? Yes No