Parent Child Fix I hope

Well this query work for ordering all item including parent items with reorder min/max values set.

UPDATE Item SET notes='' where item.id in (select parentitem from item where parentitem 0 and reorderpoint=Quantity)

run these two querys and set the child items reorderpoint to the min you want on hand and parent min max levels need to be set. In po generation based on reorder information add a filter that searches for "order" in the notes field. I am far from being a SQL expert so if someone would let me know if this will work correctly or if I missed anything.

Thanks jason

Reply to
masttech
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.