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

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 45

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 30th March 2006, 14:35
avpatil avpatil is offline
Join Date: Feb 2002
Posts: 720
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
HTML - Bill of Material

Hi Everyone,
I thought of sharing this. We develped an HTML based Bill of Material through Baan.
It has two section, one - Indented BOM and other Summarized section. All the part numbers has hyperlinks for the specification of compnents and that can be accessed via internet. We emailed such BOM to our manufacturers and it has helped us a lot in giving the information more quicker and easier. You may also like this. See the attachment.

Attached Files
File Type: html BOM.html (12.7 KB, 207 views)
Reply With Quote
Old 30th March 2006, 14:50
EdwinvdBorg EdwinvdBorg is offline
Join Date: Aug 2001
Location: Netherlands
Posts: 514
EdwinvdBorg is on a distinguished road
Baan: 2.2, 3.1, b40, b50, b51, ERP LN FP3, ERP LN FP7, ERP LN 10.2.1 - DB: ALL - OS: ALL
Hi Arvind,

I have seen a lot during my 14 years in the ERP arena and have to say a nice piece of work. Especially when you realize it is done for BAAN IV which is not that easy to expose.
Good that you share this kind of information with the rest of the user community.
Did you build this yourself?



Moderator BaanBoard
Reply With Quote
Old 30th March 2006, 14:53
avpatil avpatil is offline
Join Date: Feb 2002
Posts: 720
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Html Bom

Yes I did this my self. It took 2-3 days tomake it work. All it is doing is creating a HTML file from Baan (using Baan Reports), Emailing HTML file (we have command line email client for Windows that is called from Baan), and doing sftp to our servers for the hyperlink. SImple concept, but when put together can be powerful.

Reply With Quote
Sponsored Links
Old 10th May 2006, 13:08
baan_user baan_user is offline
Junior Member
Join Date: Jul 2004
Posts: 15
baan_user is on a distinguished road
Baan: IVc4 - DB: SQL Server - OS: Windows NT
Hi Arvind,

Very good job. I am doing the same but at SQL Server Level and the output will be in our report writer.

I will post my queries (SQL Server) once I have completed them.

Reply With Quote
Old 10th May 2006, 13:13
avpatil avpatil is offline
Join Date: Feb 2002
Posts: 720
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003

I am using Baan BOM logic, so I need not worry about exploding BOM. The BOM logic can be quite involved like revision, effective date, item type changes to Manufacture to purchase etc.
I would be interested to see SQL code.

Reply With Quote
Old 3rd July 2017, 08:11
Ishank Mangla Ishank Mangla is offline
Join Date: Feb 2016
Posts: 2
Ishank Mangla is on a distinguished road
Baan: ERP LN 10.4 - DB: SQL server - OS: Window 7

I also want to create a Label printing all lines report in HTML, I have designed the page by using the HTML code but i am unable to get the solution of printing the report in HTML with the help of LN 10.4, so can you please help me that how can I use HTML code in LN 10.4 to print the report in HTML format through LN 10.4

Reply With Quote

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
Substitution of item in material list frankadam Manufacturing & Supply Chain 3 20th October 2005 10:10
electricity as a raw material in the bom dinamm Manufacturing & Supply Chain 7 14th March 2005 20:05
Material surcharge frank holland Manufacturing & Supply Chain 5 10th August 2004 15:23
Bill of Material pbarbosa Distribution, Transportation & Warehousing 5 28th August 2002 10:22

All times are GMT +2. The time now is 16:12.

©2001-2018 - -