AMS Grid for Dynamics 365

The Dynamics 365 grid. But better

Why is working with data in Dynamics so painful?

AMS Grid fixes all of it, bringing Excel-like power directly into Dynamics 365.

Introducing

AMS Grid for Dynamics 365

All your favourite features of Excel, now in Dynamics

Find and filter your records faster than ever

Build lists of records, or quotes in no time

Chart and analyse data instantly

All on one page - no reloading

"The solution has significantly improved our workflow for inputting and reviewing data, providing user-friendly data viewing compared to the standard view.”

Omotola Olufemi
Analyst
Impact Global Health

How does AMS Grid make Dynamics 365 faster?

It’s like Excel for Dynamics. No need to integrate Excel separately

Inline editing

Fill down columns

Just like in Excel you can fill down. A huge timesaver

Instant filtering

With grouping and sorting – no performance loss.
Just type and see immediate results

Fast charting

Easy data analysis in Dynamics! No complex set up.
Just select some data, choose a chart type and you’re done!

Drag and drop ordering

Both rows and columns

Multiple sorting levels

Pivot Tables - in Dynamics!

No need to export to Excel to create a pivot table in Dynamics 365.
All the features you’d expect from a pivot table. Sorting, filtering, aggregation, rage select and more

Multiple grouping levels at an instant

Make your data look great

Use custom icons for a better user experience

It even works quickly with huge data sets. Try it.

No more exporting to Excel

Speedy data analysis

Lightning fast list building

What Is AMS Grid?

AMS Grid replaces the standard lists and views in Dynamics 365 with something that actually works the way you’d expect.

You can edit, filter, sort and update your data right there on screen, without the frustrations that come with the built-in options.

Slow grids and lists

Slow Dynamics 365 lists are one of the biggest complaints we hear. The standard Dynamics 365 grid is slow, especially with large data sets. Editable grids are even slower. Pages take time to load, scrolling is clunky, and data entry slows to a crawl.

AMS Grid loads thousands of records on a single screen with no paging, no lag, and no waiting around. If Dynamics 365 data entry is slow for your team, this is the fix.

Bulk editing and updating records

Need to bulk edit Dynamics 365 data? The native tools make it harder than it should be. Editing multiple records means opening each one individually, or exporting to Excel and re-importing.

With AMS Grid you can bulk update records directly in the grid. Edit multiple records at once using inline editing, fill down columns, and save everything back to Dynamics in real time. No export. No re-import. No waiting.

Editable grid problems in Dynamics 365

The standard Dynamics 365 editable grid has well-known problems. Grids not saving. Changes lost when you navigate away. Subgrid problems where data doesn’t refresh properly. Grouping that strips out detail.

AMS Grid solves all of this. Edits save immediately for all users. Your scroll position, filters and grouping stay exactly where you left them. And sub-grids in Dynamics 365 work just as smoothly as the main grid.

Hard to edit records?

If your team finds Dynamics 365 records hard to edit, or if data entry feels like a chore, AMS Grid changes the experience completely. Lookups, text, numbers, dates and currency fields can all be edited in place. No opening individual records. No clicking through multiple screens.

Customising your Dynamics views

Want to customise Dynamics views without needing a developer? AMS Grid lets users save their own column layouts, groupings, and filters. It gives your team the flexibility to build the data lists they actually need, not just the ones an admin configured months ago.

And if you’ve been looking at building a custom Dynamics JavaScript grid, AMS Grid does it out of the box, with no code required.

Better data management for Microsoft Dynamics 365