Algorithm_2026 R1 - Favorite Things_Ben G

Apr 23, 2026 18:33 · 8:59 · English · Whisper Turbo · 2 speakers

यो प्रतिलिपि यसमा म्याद समाप्त हुन्छ 8 दिन स्थायी भण्डारणका लागि स्तरबृद्धि गर्नुहोस् →

Lecture Index

0:03

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

Hey everyone, I'm regular Ben. I'm based in Columbus, Ohio. I've been with Algorithm now for about four years, and I would like to share a relatively simple but disproportionately cool change to the Acumatica projects and construction modules in 26R1. I'm going to talk about automated revenue percentage calculation rules for progress billing. Hold on.

0:33

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

Here we go. Now, in previous versions of Acumatica, the process for updating completion percentages on multiple revenue budget lines, it was manuals, tedious, and it was really an estimate. It's not an outright

0:49

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

if not an outright best guess so you know what happens if some costs aren't entered some transactions aren't released maybe there was a key in error when entering completion percentages i mean i've never made a key in air in my entire life but i hear it happens it can happen from time to time and if these happen it can create difficulties reconciling costs and revenue it can delay or create inconsistencies with invoicing and really nobody feels 100 percent

1:18

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

confident in the numbers. So in short, it's manual, it's messy, and it's easy to get wrong. Now with the new revenue recognition, I'm sorry, revenue percentage calculation rules introduced with 26R1, all of these issues are addressed. So let's take a look at that within Acumatica.

1:43

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

First, we're going to look at the configuration of the rules. We're going to go to projects and we don't see it here. We're going to click on show all. Then we're going to come down here to revenue percentage calculation rules. These revenue percentages.

2:01

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

These revenue percentages can be updated based on budgeted amounts, budgeted quantities, or if you're using cost projections, based on cost projections. And they can be grouped by, let's take a look at the amount rule here. They can be grouped by either revenue tasks or project tasks. And if you need additional...

2:29

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

specificity in your percentage completion revenue updates, you can actually further group by item and cost codes here.

2:41

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

You can see here you can create custom formulas for your individual rules to meet the specific needs of your billing and revenue recognition requirements. Let's take a look at this calculation here. You can see here it's saying if our budgeted amount is not zero, then take all of our actual costs and divide them by our actual budget of this particular task.

3:10

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

All right. And you can create custom rules here. And it's really, really flexible to meet your needs there. Okay. Now, I know some of us probably have some, we've jerry-rigged some type of quasi-automated solution involving GIs, business events, import scenarios. Now, those are really just held together by duct tape and dreams. And this new functionality really is a welcome addition to projects and construction.

3:41

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

We have our rules here, so let's look at how we can assign these to projects. First off, you can just assign it directly to a project down here on the project profile.

3:55

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

in your billing and allocation settings right here. There's a new field down here called revenue percentage calculation rule. You can see we could select any of our three. In this case, we're going to leave it at amount. Additionally, you can assign it from the project directly to the tasks here on your tasks tab. You don't have to use the same rule for every task, but in this case, I've used it. If you can see here, we can just select any of the three.

4:25

S… Speaker 2 (Algorithm_2026 R1 - Favorite Things_Ben G)

All right. Additionally, we can do the same thing on the project templates. It looks just the same as the project profile, but this will be for templates and we'll push through to any newly created projects utilizing this template. I'm going to assign that there. Then we could also, just like on the project, we get assigned to the project template tasks here, right down here.

5:00

S… Speaker 2 (Algorithm_2026 R1 - Favorite Things_Ben G)

All right. And the last place that we can assign this rule is on a common task. These screens look a lot the same, but they each have a different, slightly different functionality. Okay. All right. So that's how you get them on the project. You assign the tasks. Let's look at the budget configuration now. So we're going to look at our cost budget here. And we have grouped the...

5:39

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

revenue percentage calculation, percentage complete calculation by revenue tasks. So you can see here each cost task has a revenue task as well. And you can see we've captured some actual costs here and we have a budget here. And what those rules are going to do, it's going to take our actual dollars or costs here, divide them by our revised budgeted.

6:06

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

costs here, and it's going to push those through to our revenue budget. As you can see right here, the system is giving us a recommended completion percentage. Now, on its own, that doesn't do anything. You can see there's no pending invoice amount. If I went to run billing, I'd get a $0 pro forma invoice.

6:30

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

utilize this feature, what we're going to do is we're going to select the specific rows we'd like to have the system automatically update for us. Also, you can just check the top box if you want to do them all at once. But you'll see when we hit the update completion percentage here, the system is going to do this calculation and pull in the appropriate percentage complete and revenue amount.

6:57

S… Speaker 2 (Algorithm_2026 R1 - Favorite Things_Ben G)

based on the rule calculation. Now we have a pending invoice amount here. When we run our billing, we are going to get a nice pro forma invoice here where we don't have to make any modifications. There we go. It pushed through those percentages based on our revenue budget. I'm going to go ahead and throw this in the trash. I'm going to come back to our project. In addition to automatically updating here,

7:43

S… Speaker 2 (Algorithm_2026 R1 - Favorite Things_Ben G)

We can still overwrite if we want to. Write here. Say our POC is at 8.51%, but we actually want to bill 10% for this. You can just put that number in there and that will then push through to your Performa invoice. The last thing I'd like to take a look at.

8:05

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

is the nice little side panel over here. We can actually see the different recommended completion percentages by the different rules. Right here, we can see if we were using the amount, here's our 8.51 percent. If we were using quantities, it's giving us a different percent. Then if we were utilizing cost projection worksheets, we would have a completely different calculation over there.

8:35

S… Speaker 1 (Algorithm_2026 R1 - Favorite Things_Ben G)

So to recap, the revenue percentage complete update process in previous versions of Acumatica was manual, it was messy, and it was easy to get wrong. But in 26R1 with the revenue percentage calculation rules, it's automated, it's flexible, it's easy, it's breezy, and it's beautiful. So I really appreciate your time.

This transcript was generated by AI (automatic speech recognition). May contain errors — verify against the original audio for critical use. AI policy

❤️ Love STT.ai? Tell your friends!

सारांश

यो लिखितको AI सारांश उत्पन्न गर्न सारांश गर्नुहोस् क्लिक गर्नुहोस् ।

यो प्रतिलिपि बारे AI सोध्नुहोस्

यो transcript बारेमा केही सोध्नुहोस् - एआई सम्बन्धित खण्डहरू र जवाफ पाउनुहुनेछ.

अर्को प्रतिलिपि गर्नुहोस्