Inline Grids for Sales Orders in Microsoft Dynamics CRM

written by benvollmer on Friday, November 14 2008

In every CRM application I have ever played with there have been areas I have never been proud to show off to customers or prospects. And adding products to CRM's Sales Orders has been one of those areas for me in CRM since the products inception.

While it works well in high dollar low transaction environments, it doesn't work so well in high transaction, low dollar transactions. One of my most recent demos was to a company that did over 50,000 sales orders a day and so working with Daren from Microsoft Consulting Services, he build a REALLY cool too to help them VERY quickly insert items into Microsoft CRM without the normal number of clicks.

The coolest thing to me is that this is 100% HTML and JScript. No C# or VB.NET here at all. (If you look at the code, Daren built a Service that allows him to call CRM's web services easily from JScript. Check out his blog for more details.)

In the left grid, we enter new products and in the right grid we have a list of all of the products that they have ordered for the past three completed sales orders.

So below you can see a screen shot of what the grid looks like installed.

image

Once you have inserted all of your products, you can quickly  click the recalculate button to be able to have all of the totals created as well as have the items inserted into the Sales Order.

 image

Here are all of the files to make this magic happen. You will need to copy the contents of the custom.zip file to your CRM Demo Server and drop it off in a directory called custom. The order customizations will need to be applied to your CRM server as well.

This is DEMO WARE. Happy Demos! And Thanks Daren! This rocks!

Similar Posts

  1. Do you hate the Bike Shop?
  2. Microsoft CRM 3.0 Launch.... Are you ready?
  3. Local Event: Mid-Atlantic Partner Technical Briefing

Comments

  • Eran Yaron on on 11.26.2008 at 6:12 PM

    Eran Yaron avatar

    This is nice, but why does the JS go to the CRM3 web service and not the 4.0 one?

    The grid part is very nice!

  • Eddie on on 12.01.2008 at 5:35 PM

    Eddie avatar

    Does Sales orders work on CRM4 now?

  • Ben Vollmer on on 12.02.2008 at 3:16 PM

    Ben Vollmer avatar

    This works with 4.0. The Web Services are the 3.0 webservices, which work in 4.0, but don't work with Multi-Tenancy, Multi Currency or Multi Lang.

    So this works with 4.0 and the 3.0 web services were used because the JS was actually written a couple of years ago. Daren is working on an update. Check his website for more details.

    Thanks!

    Ben

  • Miguel on on 12.03.2008 at 3:14 PM

    Miguel avatar

    Download is gone

  • Ben Vollmer on on 12.03.2008 at 3:15 PM

Post a comment

Options:

Size

Colors