Item Restrictions

Michelle D.

Active Member
Hi List,

I need some ideas on using Item Restrictions (for suppliers). As far as I
can tell, this is how it works:

1) In the address book under A/P, Purchasing Instr., Item Restrictions
- choose blank, I (include items listed), or E (exclude items listed).
Let's say I choose E.

2) On the same form, go to form exit Item Restrictions and enter in the
items that I want to purchase from this supplier. (FYI - I and E work
backwards. Use E to be able to purchase an item from the supplier; use I to
not be able to purchase an item.)

3) Now, I can only enter purchase orders for the item listed for this
particular supplier. I understand this and it works fine.

The problem is that I can still buy the items I had listed from any other

I need to be able to set something up so that I can only buy item number 123
from supplier XYZ without having to set up item restrictions for every
single supplier in our address book.

Any ideas?


Michelle Dulay
ERP Coordinator
BFGoodrich Aerospace
Chandler Evans Control Systems
email: [email protected]

OneWorld B7322 with the MFG Mini-Cum, coexistent with World A7.3
AS400 V4R3 Enterprise Server
Windows NT SQL V6.5 Deployment Server
SynQuest V5.07.02
NT Logic - between AS400 (OneWorld) and HP9000 (SynQuest)


Use advanced pricing, and setup a mandatory adjustment with zero price to
allow the combinations of item/vendor that you want to allow. You only need
one price detail record to accomplish allowing purchase of item 123 from
supplier XYZ. Email me off line if you would like a helpful link to
documentation on this.

Andy Klee

RMB, Inc.
J.D. Edwards Certified Professional
Phone: (970) 856-4811
Cel: (303) 591 7344


Active Member
U have to use the supplier/item information to do that (G43A16, P43090). In
that screen there is a field saying the status of the item for the supplier
: fully certificated, partially certificated and forbidden. U have also to
setup purchase order entry to not create on auto the supplier/item info. if
u do so u will have just to set up the item u want to buy to a specific
supplier and not to say it's ok for that one and not ok for all the other


----- Original Message -