I got it!!!
Never Mind!!
Please disregard....
If anyone can help me I would greatly appreciate it...
I am having some difficulties building a report from QAD by ro_det (routing), by pt_mstr and by ff_mstr. Each table has data i need
My ultimate goal is this.
I need a report to run by ff_mstr data with
part number (ff_part)
volume (ff_adj_fc)
date (ff_date)
and forecast Id (ff_id).
From there I need the part description so I have to bring in the pt_mstr table to get pt_desc1 (*our qad table system does not have the desc in the ro_det table I already tried it so I have to get it from pt_mstr)
then in the ro_det table
I need the part number (ro_routing) = ff_part (pt_part)
the start and end time
this is break by ro_wkctr and ff_part..
Here is what I have but it does not like the white space...
Someone please help...
[FONT=r_ansi]for each ff_mstr no-lock:[/FONT]
[FONT=r_ansi]find first pt_mstr where pt_part = ff_part no-lock no-error.[/FONT]
[FONT=r_ansi]find first ro_det where ro_routing = ff_part[/FONT]
[FONT=r_ansi]and ((ro_end = ? and ro_start = ?) or[/FONT]
[FONT=r_ansi](ro_start <= today and ro_end >= today) or[/FONT]
[FONT=r_ansi](ro_start <= today and ro_end = ?) or[/FONT]
[FONT=r_ansi](ro_start = ? and ro_end >= today)) and[/FONT]
[FONT=r_ansi](ro_wkctr >= w-cell-from and ro_wkctr <= w-cell-thru) no-lock no-error.[/FONT]
[FONT=r_ansi]for each wc_mstr where wc_wkctr = ro_wkctr break by ro_wkctr:[/FONT]
Never Mind!!
Please disregard....
If anyone can help me I would greatly appreciate it...
I am having some difficulties building a report from QAD by ro_det (routing), by pt_mstr and by ff_mstr. Each table has data i need
My ultimate goal is this.
I need a report to run by ff_mstr data with
part number (ff_part)
volume (ff_adj_fc)
date (ff_date)
and forecast Id (ff_id).
From there I need the part description so I have to bring in the pt_mstr table to get pt_desc1 (*our qad table system does not have the desc in the ro_det table I already tried it so I have to get it from pt_mstr)
then in the ro_det table
I need the part number (ro_routing) = ff_part (pt_part)
the start and end time
this is break by ro_wkctr and ff_part..
Here is what I have but it does not like the white space...
Someone please help...
[FONT=r_ansi]for each ff_mstr no-lock:[/FONT]
[FONT=r_ansi]find first pt_mstr where pt_part = ff_part no-lock no-error.[/FONT]
[FONT=r_ansi]find first ro_det where ro_routing = ff_part[/FONT]
[FONT=r_ansi]and ((ro_end = ? and ro_start = ?) or[/FONT]
[FONT=r_ansi](ro_start <= today and ro_end >= today) or[/FONT]
[FONT=r_ansi](ro_start <= today and ro_end = ?) or[/FONT]
[FONT=r_ansi](ro_start = ? and ro_end >= today)) and[/FONT]
[FONT=r_ansi](ro_wkctr >= w-cell-from and ro_wkctr <= w-cell-thru) no-lock no-error.[/FONT]
[FONT=r_ansi]for each wc_mstr where wc_wkctr = ro_wkctr break by ro_wkctr:[/FONT]