I am working in a manufacturing company and using Baan LN 6.1. We have thousands of items in ERP Item Data. I want to customize the BOM of an item while printing by using BOM session (tibom1110m000).

For Example:

A customize item ‘A’ has some ‘B’, ‘C’ & ‘D’ standard items in its BOM. And ‘B’ has some other standard items named ‘X’, ‘Y’ & ‘Z’. And same case in ‘D’ there has some ‘P’, ‘Q’ & ‘R’ items. But C is a purchase item. Whenever, I print BOM of ‘A’, it prints like:

• A
-------B
-------C
-------D

But it should be like as shown below

• A
-------B
--------Y
--------X
--------Z
--------C
--------D

Is it possible to print this type of customized BOM?

The requirement in BOM while printing is to print (Level, Position, Item Code, Description, Net Quantity, Units of Quantity, Effective Date, Expiry Date & Warehouse) columns. Here one column “Units of Quantity” that’s very necessary with others.

Thanks in Advance.

Maninder

Hi Maninder,
When you print the BOM, you should be getting an option to print it in MultiLevel format. Atleast it does provide this in Baan4 and i dont see why it would be taken off in Ln

sk

This functionality is also available in LN6.1. Go to Bill Of Material session (tibom1110m000), search the item, go to Print option through File Menu. There u will get 3 options: Bill of Material (Single Level), Bill of Material (Multi Level) & Multi-Level BOM (Summarized). Here u can select any option as per your requirement.

Shalini

Thanks for your reply

But my problem is not solved by using these 3 options. These 3 options (as you have written in your Email) have already been used by me.

By using these options, ERP prints as shown below:

In

1. Single Level

• A
-------B
-------C
-------D

2. Multi Level

• A
-------B
--------Y
--------X
--------Z
--------C
--------D
--------P
--------Q
--------R

3. Summarized (This option only shows total no. of purchased items in Top item ‘A’)

• A
--------Y
--------X
--------Z
--------C
--------P
--------Q
--------R

But I want that it should be like as shown below

• A
-------B
--------Y
--------X
--------Z
--------C
--------D

I hope you will understand what I mean to say.

Here, I also have another solution for this problem that is to print in ‘BOM Tree’ session. I have also tried this option in past few days but here one loose point is the non availability of “Units” column.

Is it possible to add this column in ‘BOM Tree’ session?

Hi,
I think there is a bit of formatting problem in your thread or is it just me, i wouldnt know. To me, the representation of multilevel report format given by baan and the one that you need seems identical...

Anyways, If you can customize this session that gives you the BOM in the tree structure format then well and good. Otherwise, the same could be easily created with a few SQL codes...

sk

If the single level is

• A
-------B
-------C
-------D

...then the multi-level should be

A
-------B
--------Y
--------X
--------Z
-------C
-------D
--------P
--------Q
--------R

(C & D report to A, not B)

From your request -

• A
-------B
--------Y
--------X
--------Z
--------C
--------D

it appears you are asking for the report to show the components of B indented under B, as they should, but then you want it to show C & D under B instead of A and then don't break down the components of D.

If that is indeed your requirement, I don't know what the logic would be in creating such a report - or why you would need it. How and why does it break down some levels and not others, and why would it shift the level that some items are shown reporting to?

This doesn't make sense to me.

Hi
You should use BOM conventions to make it clear instead of using "----"
I believe you need
A
.B
..Y
..X
.C
.D

I only see that you don't want to explode D. And any reason for not exploding D?

May be you can explain that.

Arvind Patil

I have observed that the way I have explained about the levels was wrong.

But Mr. PATIL has understood what I said.

So Mr. PATIL, if you have any solution for the same then please let me know.

My main problem is to add ‘Units’ column in the BOM Tree session (otibom7200). Can my IT department customize this session.

Maninder,
I am still not clear on what you need. If you want to take this offline, may be I can help you out. My email address is avpatil@hotmail.com


Arvind Patil

After reading your post, you want to have a unit column. It is always possible to add anything in the report. But if your requirement is not to explode "D" then you will need to be able to identify the criteria and can stop the layout from printing. Again, if you want to take this offline, I may be able to help you out.

Arvind