This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Budget Creation Constrains

Hello,

I tried to create  multiple budgets for same budget center and division, but for different classifications, but it gave me error that i can't according to data integrity, i can't create because there is a budget is existing for same budget center and division.

please any advise how to create many budgets for different classifications and same budget center and division.

Regards,

Hesham

Parents
  • 0

    The conflict you are receiving is due to Budget Name must be unique.  Concatenate Budget and Budget Classification for unique Budget Name, then the data integrity issue will go away.  This can be done using Budget Name and Budget Classification Name or Budget Name and Budget Classification Code or some other uniqueness.

  • 0 in reply to 

    I already created Budget with unique names, but it gave me this error:

     Financial year "2022" is already used by budget "xyz"

    Agent "Budgets Agent" returned error :'-2009'

  • 0 in reply to 

    Please review the index constraints using AM Designer application for budgets.  There you will see associations for budgets, budget centers, and Divisions must be unique.

  • 0 in reply to 

    Thank you for your clarification, but what if i want to create multiple budgets for same budget center and same division, but for different classifications, is this applicable?

    As shown in below chart in user guide:

  • 0 in reply to 

    It is applicable and what you write is just like those pics show.  Budgets and Budget Classifications is a 1:1 link.

    Hint:  "Budget 2001" and "Budget 2002" in the pic are child Budget Centers...not Budgets.

  • 0 in reply to 

    so as you described it is applicable, but what about index constrains for division and budget center, it prevents me to create multiple budgets for same division and budget center. 

  • 0 in reply to 

    As Shown in below screenshot

  • 0 in reply to 

    Your "multiple budgets" you write of IS NOT unique for same division and budget center.  The index constraint is at the Budget table level which means 1 Budget can only be associated with 1 Budget Center / Division combination.

  • 0 in reply to 

    So based on you clarification, if i have budget center "x" and division "2022-Annualy ", i can't create two budgets with following data:

    Budget Name: x-2022-Annualy

    Budget Center: x

    division:2022-Annualy

    Classification: Hardware

    Budget Name: x-2022-Annualy

    Budget Center: x

    division:2022-Annualy

    Classification: Software

  • 0 in reply to 

    You are not creating two budgets.  You have one budget with name "x-2022-Annualy".  Each budget name must be unique.

  • 0 in reply to 

    Budget Name: x-2022-Annualy Hardware

    Budget Center: x

    division:2022-Annualy

    Classification: Hardware

    Budget Name: x-2022-Annualy Software

    Budget Center: x

    division:2022-Annualy

    Classification: Software

  • 0 in reply to 

    Ok, but if i am creating:

    Budget Name: x-2022-Annualy Hardware

    Budget Center: x

    division:2022-Annualy

    Classification: Hardware

    then i try to create 

    Budget Name: x-2022-Annualy Software

    Budget Center: x

    division:2022-Annualy

    Classification: Software

    It gives me error because the constrain of division and budget center because they are the same in two budgets although different names.

  • Suggested Answer

    0 in reply to 

    Then the system is not acting as designed.  Open a support ticket with Micro Focus Support.

Reply Children