AMS GRID - THE SMARTER EDITABLE GRID FOR DYNAMICS 365 AND POWER APPS

Working with data in Dynamics 365 shouldn't be slow

Filters reset. Record lists jump back to the top. Paging is clunky, grouping hides half the detail and updating a hundred records means opening a hundred pages. 

AMS Grid gives you Excel-like editing and analysis, inside Dynamics.

If you use Dynamics every day, you'll know this

Dynamics users tell us this regularly

None this is a huge deal, it’s ten seconds here, thirty there, but by Friday your team has lost half a day to a system that’s supposed to be saving them time.

So your people work around it. They export to Excel, edit records there and import back. This means more steps, more copies of the truth and more chances for something to go missing.

So what does AMS Grid do differently?

The standard gridAMS Grid
Open a record, come back and the filtered view is goneSave a view once, share it with the team, come back to it whenever you want
Long lists crawlEvery view is preloaded. 10,000 records and more, with no waiting
Next page, next page, next pageScroll, freeze columns, and search with wildcards to find the row you want
Grouping hides half the detailGroup and sort on several levels at once, and pivot the data without leaving Dynamics
One record open at a time, one page load eachEdit inline, fill down a column like you would in Excel, and update a hundred records from one screen
Export to Excel, edit, import back, hopeNothing leaves Dynamics. Export to Excel if you want to, not because you have to
"The solution has significantly improved our workflow for inputting and reviewing data, providing user-friendly data viewing compared to the standard view.”
impact global health
Omotola Olufemi
Analyst, Impact Global Health

Here's what it looks like

Transforming your Dynamics  365 and Power Apps experience

Inline editing

Click a cell, type and then move on. No opening the record, no page load, no save and go back to the record list.

inline editing

Fill Down a Column

Set one value, drag it down the column and you're done. The same move you'd make in Excel, on live Dynamics data.

Fill down in AMS Grid

Instant filtering

Start typing and the record list narrows as you go. Every view is preloaded, so there's no wait, and wildcard search comes as standard.

AMS Grid filtering

Sort on Several Levels

Sort by owner, then date, then value. As many levels as you need, in one click each.

sort by multiple columns

Group without losing the detail

Group by more than one field at once and still see the records underneath.

Charts in a couple of clicks

Select the columns you want and you get a chart. Quicker than building one in Dynamics.

What else does AMS grid do?

Freeze columns

Just like Excel

Easy export to Excel

Drag drop column reordering

and column resizing

Pivot tables

Analyse data using Pivot tables within Dynamics

Saved view library

Store and share your saved views

Work with huge recordsets

Easily loads 10,000+ records without performance issues

Who uses AMS Grid?

AMS Grid is an add-on for Dynamics 365. It replaces the standard record grid in the apps you already use, so there’s no separate system and nothing for your team to log into.

You'll get on with it if you're running:

  • Dynamics 365 Sales
  • Dynamics 365 Field Service
  • Dynamics 365 Customer Service

It's not for you if:

  • You’re on Business Central. AMS Grid doesn’t work with it.
  • You want a standalone tool. This only works inside Dynamics.

Who buys it, and who uses it

Usually it’s operations or IT. They’re the ones fielding the complaints about how long things take.

Then everyone uses it. Sales, service, admin, anyone who works through a list of records as part of their day. 

How long it takes

About a month from decision to your team using it. That covers the licensing, the build and getting it configured around how you actually work.

Prices

AMS Grid Starter

£ 300 +£30/month
  • 1 subgrid
  • 5 grid fields

AMS Grid Standard

£ 820 +£50/month
  • 1 subgrid with up to 5 fields
  • 1 editable optionset
  • 1 editable lookup
  • 1 editable date field
  • 1 editable text field
  • 1 editable number field
  • drag and drop rows

AMS Grid Premium

£ 1,240 +£100/month
  • 1 subgrid with up to 10 fields
  • 2 editable optionsets
  • 2 editable lookups
  • 2 editable date fields
  • 2 editable text fields
  • 2 editable number fields
  • 1 frozen pane
  • drag and drop rows

These prices are for our common bundled packages. Sometimes, you’ll find it better to get a bespoke package

Pricing includes licencing, development and support / updates.
Please call for details 01422 824831

What can I use AMS Grid for?

Building complex quotes quickly

Allow your sales team to focus on sales work, not admin

Managing orders

If your business processes lots of orders daily, having the overview to quickly tweak and view them is essential. AMS Grid far outperforms the built-in order system. Try it.

Scheduling

Use AMS Grid for scheduling your resources

Task management

Task and activity management is slow in Dynamics. Lots of page reloads and complex views. Let AMS Grid take the strain

That's the product

If it looks like it would solve problems you’ve been putting up with, ring 01422 824831 or email hello@allmysystems.co.uk and we’ll tell you whether it fits.