Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Manufacturing & Supply Chain

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th July 2007, 07:19
er.maninder er.maninder is offline
Junior Member
 
Join Date: Jun 2007
Posts: 3
er.maninder is on a distinguished road
Baan: LN 6.1 - DB: SSA - OS: Windows XP
customization of BOM
Baan: ERP LN 6.1

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
Reply With Quote
  #2  
Old 11th July 2007, 08:18
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c - DB: SQL Server 2000 - OS: Windows 2003
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
Reply With Quote
Sponsored Links
  #3  
Old 11th July 2007, 09:04
shalini_narang shalini_narang is offline
Member
 
Join Date: May 2006
Location: Noida, India
Posts: 47
shalini_narang is on a distinguished road
Baan: BaaN IVc4, V, LN6.1 - DB: SQL, Oracle - OS: Window Server 2000/2002
Print Multilevel BOM in LN6.1

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
Reply With Quote
  #4  
Old 11th July 2007, 12:31
er.maninder er.maninder is offline
Junior Member
 
Join Date: Jun 2007
Posts: 3
er.maninder is on a distinguished road
Baan: LN 6.1 - DB: SSA - OS: Windows XP
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?
Reply With Quote
  #5  
Old 11th July 2007, 13:18
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c - DB: SQL Server 2000 - OS: Windows 2003
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
Reply With Quote
  #6  
Old 11th July 2007, 18:16
jim s's Avatar
jim s jim s is offline
Member
 
Join Date: Aug 2001
Location: NH, USA
Posts: 62
jim s is on a distinguished road
Baan: IVc4 - DB: Oracle - OS: Unix
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.
Reply With Quote
  #7  
Old 11th July 2007, 20:18
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
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
Reply With Quote
  #8  
Old 13th July 2007, 07:21
er.maninder er.maninder is offline
Junior Member
 
Join Date: Jun 2007
Posts: 3
er.maninder is on a distinguished road
Baan: LN 6.1 - DB: SSA - OS: Windows XP
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.
Reply With Quote
  #9  
Old 13th July 2007, 12:18
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
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
Reply With Quote
  #10  
Old 13th July 2007, 12:21
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
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
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Code : use gbf browser to display bom pconde Code & Utilities 37 6th March 2010 21:00
copying items in a BOM rajanbansal Manufacturing & Supply Chain 1 23rd November 2006 09:51
Print production BOM within customized BOM milsykor Manufacturing & Supply Chain 1 21st July 2004 14:47
BOM in the sale order Chufos Manufacturing & Supply Chain 1 29th November 2003 11:51
BOM Changes benito Manufacturing & Supply Chain 2 26th July 2002 20:05


All times are GMT +2. The time now is 01:05.


©2001-2017 - Baanboard.com - Baanforums.com