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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Guidance please - Splitting views within Job Planning Lines. Different columns hidden & shown.

(0) ShareShare
ReportReport
Posted on by 19
First time posting, hope you're all nice.
 
Quick question that will take you a second to answer.  But I have to explain it :
 
I work for a construction company using BC.  We purchase material, use up some labour and charge our client for  the stuff we build.  We therefore use the Job section in BC a lot.  And because of the nature of our industry (not buying and selling widgets), we don't have a need for the functionality within BC that assigns and tracks costs & prices *within* each item.   I.E. an item in the budget planning line will not have a sell price.  An item in the budget billing line will not have a cost price.  No need for that, completely separated.
 
What I'm trying to do is create 2 unique views within the table /Job Planning Lines/
 
One for when it comes time to invoice the customer :
 
//
 
Another for when it comes time to enter/rejig/modify the budgets :
//
 
Not much filtering going on, just several columns hidden in one view, several columns hidden/shown in another.
 
Ive only used BC for a year, Dabbled in Visual Studio, created table and page extensions, but by no means a true programmer.
 
So far, I have created a new view via pagecustomization with the relevant columns hidden or shown. However, its sloppy, and loses the job filtering once you click anything.
 
Am I on the right track ?  Is programming this via AL/visual Studio the only way to achieve this or can it easily be done another way, Personalization of a different profile ? Design Mode ? 
 
Thanks for any pointers you may share.
 
 
 
 
I have the same question (0)
  • Suggested answer
    DH-18070427-0 Profile Picture
    19 on at
    Nevermind guys.  After a few hours of persevering it was down to just one set of filters (among others)  Filters = where("Job No." = field("Job No"));
     
    That kept the view focused on the right job no matter which view I switched to.
     
    Still.........crazy convoluted way to get what I thought would be a simple view.
     
     
     
  • Verified answer
    YUN ZHU Profile Picture
    101,600 Super User 2026 Season 1 on at
    Hi, I think you can try the following Shared layout view.
     
    Hope this helps.
    Thanks.
    ZHU
     
  • DH-18070427-0 Profile Picture
    19 on at
    Tanks Zhu,
     
    That was one of the pages I visited in my quest!   Your website/blog is very helpful.
     
    Thank You !
     
     

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,382 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,625 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,376

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans