Each time supplier changes their price we have to manually change the supplier cost field and than calculate items cost . We have MPQ set for each item under suppliers so the calculations is rather simple but would help if it could be done automatically. Items cost=supplier cost /mpq
Anyone knows of a way to run this as SQL or any other form, I would like too run this based on either department or supplier
thanks you Robert