a query from the order to the bill of materials

alex oosterom

hello everybody,

i need a query from the order to get all the fields of the bill of materials (itt1) for the items in my order. I have a lot of udf's there and with the standard coresuite query's i can't reach it.

can someone help me with that?

Thanx,

Alex

Geir Parlati

Hi Alex,
I'll gladly help You if could provide some more details about what fields this query is going to collect from Order.

Display bill of materials items from Parent Item in Order?

Kind regards,
Gary

E-mail: geir(at)completeone.no

Lars Pelzer

Hoi Alex!

Is building UDF's in your order grid an option?
Then you can fill those with an FMS.
RDR1 and ITT1 have both a relation with OITM. You can build an FMS like this:

SELECT { the field you want to display in the UDF }  
FROM [dbo].[RDR1]  T0
  INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
  INNER JOIN ITT1 T2 ON T1.ItemCode = T2.Code
WHERE T0.[ItemCode] = $[$38.1.0]

When you have added the UDF's, you can use them in your designer.

Greetz
Lars

alex oosterom

Thank you very much.
This is a nice solution!

Greets,

Alex Oosterom

Philipp Knecht

Hi

UDF is of course a solution but if its only needed for reporting you can also solve that by adding an own query (linking it) to the existing datasource.

hth