Skip to main content
Question

Reclassifying Cost Budget values to new TaskID / Cost Code pairs.

  • August 28, 2026
  • 8 replies
  • 81 views

bpickles
Freshman II

As the title says we changed our budget layout a year later.  We reclassified many transactions through the Reclassify Transactions process screen.  Worked great for the Cost Budget but then noticed that in the Revenue Budget everything put through already appears to be a negative:

 

 

On an old tab I noticed that the Reclassification screen was still loaded with transactions I didn’t reclassify (because they didn’t add with the Cost Budget #’s I was looking for).  However on one line in the Revenue Budget it’s value for Actual Amount was the exact same as the 2 transactions showing that I didn’t reclassify.  Little confused here.

This is going to seriously mess up our AIA report.  I reversed all 80 of the GL reclassifications I did believing that would fix the Revenue Budget; however it did not.

Any help would be greatly appreciated; not sure what I did wrong nor how to fix it.

 

8 replies

smilner3
Varsity III
Forum|alt.badge.img+1
  • Varsity III
  • August 28, 2026

@bpickles Run Recalculate Project Balance from the More menu of the Projects screen (PM301000). The budget tabs hold stored balances, and getting them back in line with the transactions is what that process is for; that's why reversing the batches didn't bring the Revenue Budget back on its own. The default run rebuilds Actual Quantity and Actual Amount on both budget tabs from the released project transactions. Leave the extra check boxes cleared, since Recalculate Unbilled Summary can drop the project back onto Run Project Billing, and prove it on a test tenant off a snapshot first if you can.

Your screenshot is the tell. Several lines are at exactly minus 100 percent, and the partial ones look like percent billed. That points at the income entries from your billings having gone through the reclassification too. Reclassification posts to the project on every line, and the account group follows the GL account, so lines on revenue accounts move revenue actuals between task and cost code pairs the same way cost lines do.

After the recalc, open Project Transaction Details (PM401000) and filter to your revenue account group. Wherever billed revenue is still keyed to the wrong pair, reclassify those income lines back. If a line refuses because it was already reclassified, work from Reclassification History (GL405000); only the last entry in a chain can be reclassified again. Check the Cost Budget too, and when you redo those moves, only check the expense lines.


bpickles
Freshman II
  • Author
  • Freshman II
  • August 28, 2026

@smilner3 
Thanks for the reply.

Deleted a Draft Pro-Forma.  Recalculated Project Balances with all check boxes active.
When I did the original reclassification I didn’t select any revenue/income items, just the cost ones and they added perfectly to the cent on every cost budget line item I wanted to move.

As example; the upper green box are the 2 project transaction details for the lower green box on a revenue budget line item.  None of these that I can find were ever reclassified.

All the values are correct, just displaying everything as negatives.
 


smilner3
Varsity III
Forum|alt.badge.img+1
  • Varsity III
  • August 28, 2026

@bpickles That test narrows it down. The two transactions tie to the line to the cent, so your values are intact and the reclassification had nothing to do with this. The problem is the sign, and the sign comes from account group typing.

When a posted line becomes a project transaction, the system compares the GL account's type with the type of the account group it's mapped to. Matching types land billed revenue on the Revenue Budget as a positive. Mismatched types reverse it. An income-type group can legally hold accounts of any type, so nothing blocks the disagreement.

Open one of those two transactions and note its account and account group. Compare the group's Type on Account Groups (PM201000) with the account's own type in the chart of accounts. Your whole tab is flipped, so the group holding your billing income account is the one to check. If account groups were edited during the budget rebuild, that's when it broke. Fix the typing or mapping, then run the recalc again and the tab re-aggregates positive. Do it on a snapshot copy first and confirm there, because a group edit reaches every project using that group. If the typing already matches, the transactions themselves were recorded with the wrong sign: reverse them on Project Transactions (PM304000), re-enter them with the income account group on the credit side, and recalc.


bpickles
Freshman II
  • Author
  • Freshman II
  • August 28, 2026

@smilner3 
That makes sense; but I don’t see that we have anything mismatched:
 

 

We haven’t changed Account Groups or preferences like that in a while.  System has been running well with 5 tenants more or less setup the same.  Even our TaskID’s and Cost Codes are shared so we can export from one and import to another.

There’s other projects in this tenant setup exactly the same as this and there’s no issues.  I only noticed this after the reclassification.


Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • August 31, 2026

bpickles
Freshman II
  • Author
  • Freshman II
  • August 31, 2026
Error 403

 

You might not be allowed to view this area. Access to Knowledge Base, Product Downloads and Ideas is controlled by your assigned role in Acumatica CRM. If you require access, please work with your business account administrator to assign you the proper role.
 
I weep :(

Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • August 31, 2026

@bpickles ​@bpickleskcm  use your other user which is registered as a customer.  


smilner3
Varsity III
Forum|alt.badge.img+1
  • Varsity III
  • August 31, 2026

@bpickles It's actually in your screenshot, top left. The BILLING group's Type is Income, and its default account, Progress Claim Billing, is an Asset-type account with an AR account class. That's the disagreement: the group says revenue, the account inside it says asset.

That's also what your Project Transaction Details screenshot is showing. Both AR invoices hit BILLING as the Debit Account Group, and a debit into an income-type group reads as negative revenue on the budget. The amounts are untouched; the sign follows the current rules, which is why the whole tab mirrors your billings.

The article Heidi linked explains why it surfaced now: 2024 R1 changed how postings update project budgets when the account's type and the account group's type differ. Your reclassification and recalc rebuilt this project's balances under those rules. The other projects may only look right because nothing has rebuilt theirs since the upgrade, so don't run the recalc on them in production until the mapping is settled.

The fix is a decision, not a button. Decide where progress-claim billing should live: an asset-type group keeps it off the Revenue Budget, and a true income account carries the revenue actuals. Either way it ripples into GL reporting, so model it on a snapshot before touching the live tenant.