Query (not purchased items)

[alex10]

Hi,

I am very new in QAD and would appreciate all your help.

I need a query to get all items that wasnt purchased in the last 24 months.

Many Thanks

 

[Max Viskov]

Hi
You can try something like this:

For each pt_mstr no-lock:
find first tr_hist where tr_part = pt_part and tr_type = 'RCT-PO' and tr_date >= (today - 730) no-lock no-error .
if not available tr_hist then
display pt_part pt_desc1
end .


____________________________________
Max Viskov
Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Have an MFG/PRO question?
I will answer your questions for free at http://www.32soft.com/site/modules/newbb/viewforum.php?forum=5[FONT=&quot][/FONT]

 

[alex10]

Many Thanks, may i have to consider the pod_det for the actual PO right?

 

[Max Viskov]

This is right
Open purchase orders are

pod_det where pod_qty_ord > pod_qty_rct or pod_status = " " .


____________________________________
Max Viskov
Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Need to extract MFG/PRO documents to Excel and Acrobat?
Free Tools at http://www.32soft.com/site/modules/xt_conteudo/index.php?id=12[FONT=&quot][/FONT]