There is a feature available in the Sales Order module that may be exactly what you need to address this business need (restricting customers from buying specific items or product lines).  Check out Purchase Control Maintenance in the setup menu of Sales Order.  This would first need to be enabled in Sales Order Options, Line Entry folder, Purchase Control (third frame on the left).

There is a feature available in the Sales Order module that may be exactly what you need to address this business need (restricting customers from buying specific items or product lines).  Check out Purchase Control Maintenance in the setup menu of Sales Order.  This would first need to be enabled in Sales Order Options, Line Entry folder, Purchase Control (third frame on the left).

Yes of course!  I completely forgot about this feature.  (I've only used it once, a long time ago).

We looked into that and we thought it would work, but it didn't work on our web orders and import orders.

We have used that feature on our web orders, although we do just have 1 customer for all our B2C orders and then have different accounts for our B2B orders.  It has worked well for us.  It used to be an enhancement that DSD offered but now I think it is included as part of Sage 100.

Purchase Control works at the business object level.  Importing with VI or anything using BOI to import orders would use the Purchase Control logic.

We sometimes set up web orders to be brought in under a generic customer number... in which case Purchase Control would not work.

Good to know it is at a business object level though.  That makes sense.  Perhaps there is a Role permission override causing Darkjedi problems?