Skip to main content
Solved

How can we Link between Budget in Finance module with Project Budget


agung42
Freshman I

Dear all,

We want to ask about how we can link between Budget in Finance module with Project Budget in Acumatica?

Thank you for your kind attention

Best Regards,

Agung Edhy Triyono

Best answer by kristianharianja

Pak Agung, how are you? :)

I think this would be possible via Business Event, not exactly linking them but that can notify you if the project budget exceed GL budget. They both are linked through Account Group so you can technically link them.

However, that would only compare GL budget to one project only as opposed to entire projects. You may have multiple projects and each has labor budget less than 11,000 but the sum of it across projects could be way more than your GL budget. You should restrict over budget that includes all projects in my opinion.

Regards,

Kristian Harianja 

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

5 replies

Gabriel Michaud
Captain II
Forum|alt.badge.img+10

Hi @agung42,

Can you provide more details on your requirements? Are you trying to build some sort of report that shows you the total by project for an account group (ex: travel expenses), and use that to build your finance budget?


agung42
Freshman I
  • Author
  • Freshman I
  • 2 replies
  • July 23, 2021

Hi @Gabriel Michaud 

Exactly the requirement is:
- Using the Budgets from Finance module, we want to constraint so that the budget amount in the Project Budgets from Projects module will not greater than Budgets from Finance module.

Example:
We have budget amount 11,000 for account no. 51200


If we see on Chart of Accounts, the Account Group for 51200 is LABOR


When we create Projects. we want to constraint the Original Budgeted Amount or Revised Budgeted Amount so that not more than the 11,000



I hope it make it clear.

Thank you for your kind attention.

Best Regards,

Agung Edhy Triyono


kristianharianja
Semi-Pro I
Forum|alt.badge.img+3

Pak Agung, how are you? :)

I think this would be possible via Business Event, not exactly linking them but that can notify you if the project budget exceed GL budget. They both are linked through Account Group so you can technically link them.

However, that would only compare GL budget to one project only as opposed to entire projects. You may have multiple projects and each has labor budget less than 11,000 but the sum of it across projects could be way more than your GL budget. You should restrict over budget that includes all projects in my opinion.

Regards,

Kristian Harianja 


agung42
Freshman I
  • Author
  • Freshman I
  • 2 replies
  • July 23, 2021

Hi @kristianharianja 

Your idea is absolutely true. 
We would like to restrict over budgets for all projects with the same account and subaccount.

How can we perform that?

Thank you for your kind attention

Best Regards,

Agung Edhy Triyono


Gabriel Michaud
Captain II
Forum|alt.badge.img+10

I agree with @kristianharianja -- business event is a good way to go, however it would be used to send a warning e-mail, not to block entry. If you want to prevent saving of the budget a customization needs to be added; there’s nothing built-in to do that.


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