I understand what you are asking but may I suggest that you are approaching this throng way. On a particular Work Order you may have several lines belonging to different suppliers. Some items may already be on order even if the quantity is currently on ZERO. What you really need is to have a look at our RR Allocation Module. This allows you to on daily base order the PO based on reorder point and reorder qty and have the system raise all the PO that are required [for multiple work orders]. The allocation module: > Allocates the PO raised to WO > Keeps track of the WO that do not have a PO > Keeps track of what QTY are available as soon as they are reecived > Tells you what stock that arrived belongs to whom and has a field for notify customer. When notified that items will mnot be allowed to be given to another customer by mistake. > There is a utility to print lables for items received so that they can be stuck on the actual items with reference to custoner and work order number.
If you wish to know more please contact me.
Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk] CEO - Retail Realm