If your system looks messy you will complicate mathers with complex query's.
Q-ries are very powerfulle if you want to check prices for items.
If you want to use queries you need 2 things:
1 data dictionary (delivered with your software or you can get it at qad.com)
2 file relations to show how files are interrelated
Without these two "books" you will get lost.
In your situation I suppose that you first have to check if P (purchase) items have prices.
Make a simple querie to begin with.
A. First start with a queries to show you all purchase items. ie for each pt_mstr where pt_?? (Ctrl f to find out name) is "P". display pt_part and pt_desc and pt_??.
If this works then keep thsi querie for other users and go on with te copy.
B. Now you want find price data. I beleive that the sct_det is connected to the pt_mstr by key sct_part. I am not sure so use the file relation pdf to find out the relation. Be sure that the price is "standard".
C. If you have difficulty with the syntax, search at
www.qad.com or this site for a simple query. This will help you to define/build your own queries.
i believe this way you will start to learn (and appreciate
the way QAD did setup mfg/pro. I beleive the setup filosofie of mfg/pro is is one of the most powerfull features of this system.
Good luck, I know you will succeed.