Skip to main content

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.

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


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.


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


Hi Laura,

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

Thank you.


Hello,

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

 

Laura


Hi Laura,

Yes, they all belong to the expense type.


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


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