AvklarePlan Help Sign in Start a free trial

Help ›

Filter the plan grid

Hide what you don't plan, such as inactive items, a discontinued supplier or a whole package type, so the grid shows only what matters. A bulk change on a row changes only the items you can see, never the hidden ones. An Owner or Admin can make a filter the workspace's default, so everyone opens plans with it.

Anyone who can open a plan can filter it. Making a filter the default needs an Owner or Admin.

Before you start

Hide rows by a grouping's values

  1. Open Plans and open the plan.

  2. Next to Filter, open + Filter and choose the grouping, for example Active.

    You should see a list of its values under the toolbar, each with how many items hold it, all ticked.

  3. Untick the values to hide, for example 0 or Inactive. For a long list, type in Search first, then Hide these or Show these for every match.

    You should see a chip such as Active: hiding 0, and the count above the grid change, for example 1,240 of 3,600 items. Totals add up only what is shown.

  4. Click Done. To change the filter later, click its chip. To remove it, click × on the chip.

Plan one unit at a time

An amount in native units, such as Add 500 cases, needs a selection whose items share one unit. To plan cases apart from kegs, add Unit under Group by, or filter Unit to hide the kegs, then select the row. An amount in equivalent units, such as CEQ, works across units without this.

Hide empty rows

Hide empty rows, next to the filters, is on unless your workspace's default view turns it off. It hides items with no quantity in any month of the plan, of the approved baseline, or of the actuals being compared. A supplier whose items all sell nothing disappears with them, and comes back as soon as anything is planned or sold for it.

Untick it to see every item, for example to plan a new item that has nothing in it yet.

Make it the default view

  1. Set the filters and Hide empty rows the way everyone should see plans.

  2. Click Make this the default view.

    You should see Saved. Everyone in the workspace now opens plans with this view.

Anyone can still change the view for themselves: remove a filter, add another, or untick Hide empty rows. Back to default view puts the workspace's default back. The default applies to every plan in the workspace, including ones created later.

What a bulk change does with a filter on

A bulk change applies to the selected row's items as shown. Hidden items are never changed, even when they sit under the selected row. The plan's History records what was hidden, for example Supplier: Acme › Brand: Hazy (hiding Active: 0; rows with no volume). An export downloads the rows as shown, too.

Common mistakes

All guides

An unhandled error has occurred. Reload 🗙