This is all about how I use GP, based on what I learned in my investigations with clients...

“Suggested Sales Items” - Microsoft Dynamics GP 2013

Posted by Belinda Allen on Oct 19, 2012 10:20:00 AM

(The attached video includes all of the information in the text below for those of you who prefer to “watch it” rather than “read it.”)

 “Suggested Sales Items” is an awesome new feature in Microsoft Dynamics GP 2013.  This new version is due to be released at the end of December, 2012.

We’ve all been to a restaurant and ordered an entrée only to have the wait person suggest some additional side or appetizer based on our entrée selection.  This is known as “upselling.”  We’ve also been in the situation where we have seen a newspaper advertisement for a product on sale only to get to the store to see another version of the sale product that is better but not on sale.  This is known as a “loss leader.”

It is probable that you’ve bought the extra side dish or the “non-sale” more expensive item in both of the situations above at least once. 


Q:  So how can you use Microsoft Dynamics GP to translate this action in your customers?

A:  The new feature in GP 2013 “Suggest Sales Items.”


This feature is setup in Inventory Control, but used in Sales Order Processing.  You start with the Inventory Item Maintenance Window (Inventory ~ Cards ~ Item.) 



  1. Select an item using the Item Lookup Window.
  2. Click on the new button in the bottom of the Item Maintenance Window called “Suggest Items.” 
  3. The new “Suggest Sales Item Maintenance” window will open.
  4. Select which Sales Order Processing (SOP) Document type for which you want to have suggestions made to you while working with a customer or prospect.  (The default is for all SOP document types.  This feature does not work with Back Orders or Returns.)
  5. In the grid at the bottom, select the item you want Microsoft Dynamics GP to suggest to you.  Click on the Lookup icon for a list, then enter the quantity that you want suggested.  This may not always be a one to one relationship (e.g.  If you are selling a 10 gallon bucket of paint, you may want to suggest 2 paint rollers or 8 brushes or a single spray painting machine.)  In this example you’ll notice we can suggest more than item.
  6. Click OK.



  1. Begin your Sales Order Processing transaction in the SOP Entry window.
  2. After an item that has suggestions assigned to it is entered, the “Suggest Sales Item Entry” window will appear.  This will allows you as a sales person to discuss these additional options with your customer or prospect.
  3. OPTIONAL:  If you do not have enough of the original item OR the suggested item in stock, you will receive the “Sales Quantity Shortage Options” window at the appropriate time to ensure you are given the option of how you want to handle shortages.
  4. OPTIONAL:  If the client is over their credit limit, you will receive the Credit Warning window after you enter the original item and BEFORE the “Suggest Sales Item Entry” window appears.  It will still appear giving you the opportunity for upselling, however normal Credit Rules already in place will still exist.
  5. Should the customer or prospect choose to receive any of the suggested items, all you have to do is:
    1. Click on the box next to the item number in the grid at the bottom.
    2. Ensure the quantity is the desired quantity, if not change it.  Once you are returned to the Sales Order Processing Entry window, you can edit the quantities and pricing there as well.
    3. Click OK.
    4. If the customer does not want the items, just click OK to close the window.

    Boat House in Central Park, New York City, NY

This is a really cool new feature and I hope everyone who utilizes the distribution series takes advantage of it!

Tags: Inventory, Sales Order Processing