Product- Customer

Is there a way to not allow a certain product to be entered to a specific customer or supplier?  

  • +1
    Verified Answer

    Hi

    You can use forbidden price to prevent saling a product to a customer.
    You have an example in your SEED folder:

    To prevent purchasing a product to a specific supplier, you can use the supplier referencing parameter (ACH > REF > ITMBPS)


    Use this parameter to indicate if the product referencing is required for the supplier on the receipt site when managing purchase documents.

    Mandatory - Referencing is mandatory: in the Suppliers section of the Product record, a line must exist for the supplier. Otherwise, you will not, for example, be able to enter the product on an order intended for this supplier (a blocking message is displayed).

    Optional - Referencing is not required. A warning message is displayed.

    Not used - No control is carried out.

  • 0 in reply to Julien P

    Hi Julien,

    thanks for quick reply.  I've tested on the purchasing side and it works fine.  Don't understand why the sales side doesn't have the same parameter setting as it would be so much better.  In Seed I do not see a price list configured but did see the setting in your screen shot.  I did add a product/customer to the price list however it did not stop me from creating the order so not sure what I'm missing.  Also- in our case would would have to limit either one or a few customers to be able to sell products so I do not see how this would work for us.   This is why having the same parameter setting on sales side would work.  We do link customers on our product-customer tab.   If you know how I can configure the price list where it would limit the SO entry for that product-customer , would be appreciated as we could use this feature for other products.  I'll take a closer look as well to see what I may have done wrong.  Thanks again!  

  • +1 in reply to Christine T.
    Verified Answer

    Julien,

    I've got the forbidden price list to work.  Seems I had selected the incorrect price structure on the parameter (had Product but changed to Customer) and received the block Prohibited Product.  This is a good start but if you happen to know a way to allow all customers but specific customers that would be awesome.   thanks so much as always for your help!

  • 0

    My question was answered on how to restrict a certain product from being entered to certain customers but would anyone know if there is a way to only allow a product to be sold to one customer?  We could use the Notes field to warn users when creating SO's but wondering if Sage has something built in to give an error that 'this product cannot be sold to this customer'.   We are at V12.  Thanks!  C

  • 0 in reply to Christine T.

    Only through extra development, we did it for several customers, it's quite usual especially when you have multiple companies inside the same folder.

  • 0

    X3 has this concept on the purchasing module to restrict the purchase of an item from only those suppliers that are setup in the suppliers section of the product master, but this functionality does not natively exist in the sales module.  Here is the link to an enhancement request to include this in the standard offering if you want to give this an upvote.  www.sagecity.com/.../customer-referencing-parameter-value-to-restrict-product-sales-to-certain-customers

  • 0 in reply to Martins de Almeida

    Yeah, we have a customization from our reseller to restrict customers and whole countries from getting a specific product ID