Skip to main content
Solved

Discrepancies in Budget node vs sub-node.

  • 21 February 2024
  • 8 replies
  • 50 views

Hi All,

I have noticed that there are inconsistencies between the figures returned by a budget node and those present in the sub-node. I am looking for an explanation of the root cause of this inconsistency and would like to explore possible solutions and best practices to rectify it.

For example, the sub-node amount and distributed amount is 352,962.60 while the node amount is 352,962.60 and the distributed amount is 705,925.20.

I would appreciate your insights on how to effectively troubleshoot this issue.

Thank you.

Best answer by Laura02

I am running out of ideas.

Are there any customizations on your site that could be interfering?  Rule out customizations by temporarily un-publishing them and viewing the budget.

I though of Finance process → Recalculate, but it looks like Budget ledger is not included in the Recalculate process.

Did you try removing/recreating the budget articles? 

It may be time to open a Support ticket with your VAR or Acumatica.

Laura

View original
Did this topic help you find an answer to your question?

8 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 21, 2024

Hello,

It’s helpful to know your Acumatica version, to understand how the budget was loaded, and to see a screen shot of all the columns that add up to the Distributed amount for the incorrect roll-up node and all its sub-nodes.

Without the additional information, I can guess that changing one column figure in one of the months, saving, and then changing the figure back and saving again  may re-calculate the Distributed Amount.

Laura


  • Author
  • Freshman I
  • 8 replies
  • February 21, 2024

Hi Laura,

Thanks for the response. I have tried the suggested solution, but it didn’t work.

The version is 2021R1, Build is 22.118.0022+.

The budget was loaded using the upload file option.

Attached below are the screenshots.

1: The sub-node (cost center)

2: Node (Department)- The highlighted are the figures the system is returning as totals for the cost center

Thank you.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 21, 2024

Hello,

I see 10 account/subaccounts in #1 that I think are your Subarticles, rolling up to the first highlighted Node in #2.  Does screen #1 show us 100% of the Subarticle lines listed under BID_Employee Costs Node in your Budget Configuration?

Example- Budget Configuration: 13 Accts & Subs Roll up to ‘Revenue Accounts Node

Do any of the Nodes or Accounts in your Budget Tree/Subarticles have Secured column checked ON?

Laura


  • Author
  • Freshman I
  • 8 replies
  • February 21, 2024

Hi Laura,

Attached is the screenshot that completes all the lines. None of them has the Secured column checked.

Thank you.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 21, 2024

Hello,

Do all the accounts in the Node have the same Account Type on the Chart of Accounts?

 

Laura


  • Author
  • Freshman I
  • 8 replies
  • February 22, 2024

Hi Laura,

Yes, they all belong to the expense type.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • February 22, 2024

I am running out of ideas.

Are there any customizations on your site that could be interfering?  Rule out customizations by temporarily un-publishing them and viewing the budget.

I though of Finance process → Recalculate, but it looks like Budget ledger is not included in the Recalculate process.

Did you try removing/recreating the budget articles? 

It may be time to open a Support ticket with your VAR or Acumatica.

Laura


  • Author
  • Freshman I
  • 8 replies
  • February 22, 2024

Hi Laura,

I forgot to mention that the user uploaded the file and then released it when all values were correct. They then used the preload articles hoping to view the actual figures alongside the budget figures using the compare-to functionality.

That’s when the budget became messy.

I have recreated the sub-articles, but the issue couldn’t be resolved. 

 

Thanks.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings