Custom Planning Worksheet Views for Microsoft Dynamics 365 Business Central
One planning worksheet often serves several people. A buyer wants purchased items only, a planner wants everything, and someone loading containers wants lines sorted by weight. Rebuilding filters and sorting each time wastes the start of every session.
Enhanced Planning Worksheet lets planners save worksheet views and switch between them from a Custom Views list.
How Custom Planning Worksheet views works in Enhanced Planning Worksheet
- A planner sets up a view of the worksheet for a recurring task.
- The view is saved in Custom Views under a clear name.
- Each time the planner opens Enhanced Planning Worksheet, the planner chooses Select View and picks the view for the task at hand.
- When needs change, the planner edits or deletes views in the list.
Key capabilities
A list of saved views
Custom Views lists the saved views by name. A planner picks one and the worksheet changes to it.
Views for different roles
Examples in the demo company include All Data, Purchased Only, and Sort by Weight, which reflect different jobs on the same worksheet.
Select View on the ribbon
The Select View action on the worksheet's Home tab opens the list, so switching takes a couple of clicks.
Maintain the list
Edit List and Delete actions on Custom Views keep the list current as roles change.
See Custom Planning Worksheet views on screen
Real screens from Enhanced Planning Worksheet, shown with demo data.
Details that matter on the floor
Named for the job
View names like Purchased Only describe the work, so a new team member can find the right view without knowing how it was built.
Works with the rest of the worksheet
The FactBoxes and tabs work the same in every view, so a buyer's view still shows the planning summary and history for each line.
Who uses Custom Planning Worksheet views
Purchasing managers
Open a view that shows only purchased items.
Inventory planners
Switch between a full view and focused views during a planning session.
Operations managers
Set up views that match how planning work is split across the team.
Questions about Custom Planning Worksheet views
Can I save different views of the planning worksheet in Business Central?
Yes, with Enhanced Planning Worksheet. Saved views appear in a Custom Views list, and the Select View action switches the worksheet to the chosen view.
What kinds of views can I save?
Views that suit different planning roles. The demo company includes All Data, Purchased Only, and Sort by Weight.
Can views be removed or renamed?
The Custom Views list has Edit List and Delete actions for maintaining saved views.
Related Enhanced Planning Worksheet features
All Enhanced Planning Worksheet features →Part of Enhanced Planning Worksheet
Align Inventory with Demand and Optimize Vendor-Driven Purchasing.
Have a question about Custom Planning Worksheet views?
Send us a note and the Enhanced Planning Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
