Hi all, we use the % complete override on a project for booking our revenue. One particular project, we split out the revenue evenly July 2021 through June 2022 (100% complete in June 2022). No problems there and that all worked as intended. However, now when we are looking at our profitability and revenue reports, it is booking a negative revenue for July 2022 when there shouldn't be any revenue at all. As far as I can tell, there is no difference on this project & it's revenue settings compared to every other project. We have never seen this before and have exhausted hours trying to find what is causing this. Any ideas what is going on?

Did the total amount of revenue change in July 22? f.ex if it's linked to an SO line did it get edited or closed? Did something else get added to the same arrangement + you're using FV allocation? Both of these scenarios could cause the revenue to change even if nothing changes on the project itself.

no - this was a set it and forget it Sales Order. Set up in June 2021 with a 12 month billing schedule, set the % complete and the only time we touched the SO was to create each monthly invoice. No line items were adjusted or closed.

Are you on ARM?

yes and yes! It appears as though the status was re-opened at the end of July. Is there a way to see why it went back to in progress? It should have stayed closed after reaching the 100% in June.

Can you screenshot: 1. The previous revenue plan 2. The revenue arrangement header 3. The revenue arrangement version subtab 4. The revenue arrangement message subtab?

looks like the previous version also had a negative entry.

If you go to the revenue element and look at its system notes, does it show changes in any of Sales Amount, Discounted Sales Amount, or Revenue Amount?

not since originally opening the SO last June

@Dawn just want to butt in because I think we had the same issue before. Were there actual and approved time entries recorded in July 2022?

Hey Luis - appreciate the butting in! Yes to the time entries, in both July and now August as well. However, this is pretty typical for us to have time entries outside of the months we book revenue and we haven't seen this before. I wonder if we screwed up on some settings that is factoring in time now?

And if that happens you don't include those periods in the Percent Complete Override subtab and put 100% as cumulative percent completion?

correct. we exclusively use the % complete override. The actual hours and their billable rates are less than the total fee we billed to the client. This is also common and has not created an issue in the past.

I was asking because in our experience and in the documentation, if there's an approved and actual time entry posted in a period that is not included in the Percent Complete Override, NS will use the percentage of completion based on time entries. For example, your actual hours as of July 2022 are 91 but your planned hours are 100, then that's just 91%, so NS will make a negative adjustment assuming there's a time entry in that period and the period isn't in the Percent Complete Override. Just to be clear, the billable rates don't matter. It's just actual hours divided by the planned hours (or whatever the formula is).

gotcha. I'm seeing what you mean now. We don't use the planning tasks, and it defaults to just 10 hours for one department. We are well over that on actuals

Yeah. That's what I'm going to suggest too. 'Cause that's what we do and that's what's in the documentation in case there are time entries beyond the original last period. My hunch is your actual work divided by the calculated work as of July 31, 2022 (not what you see right now 'cause that's as of today) is less than 100%. Other than that, I have no clue.

I think Luis is on to something. I was discounting the actual time because you are using % Complete Override, but you have to shut a project down properly. If Actual Time entries are made in a period not covered by your % Complete Override, then NS is going to recalc for that month.

What steps might I be missing from shutting down the project properly that could affect this?

IMO part of project shut down is confirming no further time entries will be made, & that the %complete override covers all periods.

gotcha. Agreed we will definitely make this a part of things going forward. It makes sense for sure but I cannot seem to replicate it & it's making me crazy! I have other projects that have time outside of the % complete (both over and under the NS calculated % work complete) and they did not have this issue.

Dawn, I was wondering if someone entered time dated in July and then removed/unapproved/edited date to June etc

No, all the time entries are still the same.