Skip to content
Enhanced Planning Worksheet app iconEnhanced Planning WorksheetPlanning worksheet

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

  1. A planner sets up a view of the worksheet for a recurring task.
  2. The view is saved in Custom Views under a clear name.
  3. Each time the planner opens Enhanced Planning Worksheet, the planner chooses Select View and picks the view for the task at hand.
  4. 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.

Enhanced Planning Worksheet app icon

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.

Ask a product question

Product Questions