diff between bom and item

[Former Member]

hi.,

i need a small clarification..

in my item master  20  items are there..

what i need is...

some items are having bill of materials and some are does not have bill of materials..

how can i find  in item is  having  bom or not..

if i want to write a query from oitm  is there any parameter like where bom=yes like

[kothandaraman_nagarajan · Accepted solution]

Hi,

1. Under item master data, right click and then choose "Bill of materials". If the item already have BOM, then it will be displayed.

If not, you can create new BOM for that item.

2. Try this query:

SELECT T0.[ItemCode], T0.[ItemName], T0.[TreeType] FROM OITM T0 WHERE T0.[TreeType]  = 'N' GROUP BY T0.[ItemCode], T0.[ItemName], T0.[TreeType]

Thanks & Regards,

Nagarajan

[Former Member]

Thank u To Every one..

Little bit helpful to me...

Keep posting...

[KennedyT21]

Try This query

/************************************************************

* Code formatted by Kennedy

* Time: 1/29/2014 11:32:19 AM

************************************************************/

SELECT T0.[ItemCode],

       T0.[ItemName],T0.OnHand,

       T0.[TreeType],

       CASE

            WHEN t0.TreeType IN ('A', 'P', 'T', 'S') THEN 'Yes'

            ELSE 'NO'

       END AS [BOM ITEM]

FROM   OITM T0

WHERE  T0.[TreeType] = 'N'

GROUP BY

       T0.[ItemCode],

       T0.[ItemName],T0.OnHand,

       T0.[TreeType]

Regards

Kennedy

[Former Member]

Hi Srinivas,

Try this query in Query generator...

SELECT T0.[ItemCode], T0.[ItemName], T0.[DfltWH], T0.[TreeType] FROM OITM T0 WHERE T0.[TreeType] =[%0]

[jitin_chawla]

Hi,

The Tree Type field in the OITM table displays whether the Item is a BOM or not.

You can use the query as follows :

SELECT T0.[ItemCode], T0.[ItemName], T0.[TreeType], CASE when t0.TreeType IN ('A','P','T','S') Then 'Y' Else 'N' END as [BOM ITEM]

FROM OITM T0 WHERE T0.[TreeType]  = 'N' GROUP BY T0.[ItemCode], T0.[ItemName], T0.[TreeType]

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi,

Please check whether TreeType of Item is P  OITM.

Try This Query:

Select ItemCode,ItemName,TreeType from OITM where TreeType='N'

If TreeType='P' then Item has 'Production Type' of Bill of Material

If TreeType='N' then Item without Bill of Material

If TreeType='A' then Item has 'Assembly' Type of BOM

If TreeType='T' then Item has 'Template' Type of BOM

If TreeType='S' then Item has 'Sales' Type of BOM