Archive for the ‘Restricted Items Genie’ Category:

How to prevent selling items to a customer in Dynamics GP

How do you prevent selling an inventory item that is for a specific customer in Dynamics GP?  If you have an inventory item that is just for one customer or a class of customers how do you prevent selling that item to any customer?

Inventory Management words in white 3d letters on a ball or sphere of cardboard boxes representing merchandise or stock in a logistics chain for a business or company


You always have the option of creating special price list but this can quickly become a pricing nightmare to manage.



SOP Restricted Items Genie provides a much more straight forward functionality to manage customer specific inventory. You simply list what items (or Item Class) are for what customer (or customer Class), no need for special price lists.


SOP Restricted Items Genie Advantages:

  • Enforce product sale authorization by customer or customer class
  • Use of multiple Price Levels not required
  • Ease of maintenance
  • No workarounds, strictly enforced

SOP Restricted Items Genie works in the background of the Sales Transaction Entry window. When a user enters an item number on a sales line, RIG checks the authorization list in the following manner:

  • If the item is absent from the RIG list:
    • It is ignored and standard GP handles the completion of the Sales Transaction
  • If the item is present in the RIG list:
    • When the customer is assigned the item in RIG then the Sales Transaction is allowed to continue in GP
    • When the customer is not assigned the item in RIG then entry of the item is prevented on the Sales Transaction
  • If the item belongs to an item class that is in the RIG list:
    • Customers assigned the item class are allowed to continue
    • Customers assigned the specific item are allowed to continue
    • Customers not assigned the item or item class in RIG are prevented from purchasing the item
  • Customer Classes
    • Customer classes can be used instead of specific customer IDs. The same rules are followed for enforcing item id and item class sales.

For more information download the SOP Restricted Item Genie manual SOP Restricted Items Genie

Customer Specific Inventory in Dynamics GP

Do you need to restrict the sale of specific items to specific customers?

What would happen if you sold the wrong product to the wrong customer?

If you have inventory items that are for specific customers you need to ensure that sales orders do not include the wrong inventory item.  Often these items are based on the customers specifications making Sales Order processing critical in matching the correct inventory to the Customer.

You can use Price Levels in Dynamics GP but that often requires high maintenance to keep up.  We developed Restricted Items Genie to control what customers get what inventory to address this issue.

Restricted Items Genie prevents the sale of unauthorized items to customers.  When entering a sales transaction, Restricted Items Genie checks the authorized sales list for the customer and customer class.  If the item you are trying to sell is restricted for that customer Restricted Items Genie will inform you of the issue and remove the item from the order.  Simple, fast, and effective.

The following screenshots show the messages displayed when the user tabs off the line after entering a restricted item number for a customer not authorized to purchase the item:

Restricted Item in SOP

For more information download the SOP Restricted Item Genie manual SOP Restricted Items Genie