Skip to Content
author's profile photo Former Member
Former Member

diff between bom and item

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    Posted on Jan 29, 2014 at 06:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2014 at 06:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2014 at 06:57 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2014 at 07:34 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2014 at 07:01 AM

    Hi Srinivas,

    Try this query in Query generator...

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2014 at 10:49 AM

    Thank u To Every one..

    Little bit helpful to me...

    Keep posting...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.