web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to make Budget Matrix non-editable when G/L Budget Name is Approved?

(1) ShareShare
ReportReport
Posted on by 4

Hi everyone,

I’m working with Budget Matrix (Page 9203 - ListPart) which is based on Dimension Code Buffer (Table 367).

I have implemented workflow approval for G/L Budget Name (Table 95).

Requirement:

When the G/L Budget Name status becomes Approved, the Budget Matrix page should become read-only / non-editable.

Issue:


  • The Budget Matrix is built from Dimension Code Buffer, which does not contain fields like Budget Name or Status.

  • I cannot modify or extend Dimension Code Buffer to store status.

  • I also tried updating the buffer rows on OnOpenPage trigger but that does not work since the table is temporary.

Question:

➡️ How can I control the editable property of Budget Matrix based on the status of the related G/L Budget Name?

I am looking for a correct approach to:


  • detect the Budget Name used when opening the Budget Matrix

  • check its Status

  • disable editing on the entire matrix when Status = Approved

Any clean solution or event pattern would be appreciated.

Thanks!

I have the same question (0)
  • Suggested answer
    Dhiren Nagar Profile Picture
    509 on at
    Hi,
     
    I think you are looking at the wrong place.
     
    What you can do is create a field on G/L Budget Name field. Customize approval to set the field value.
     
    Now on the OnOpenPage of Budget (113) you will find variable for Budget name, from there you can get the Approval status field value.
    Then you can set the editable property of the listpart, it think the name of part is Budget Matrix.
     
    I hope this helps.
     
    Regards,
    Dhiren.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,573

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 773 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 760 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans