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 30th March 2006, 14:35
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
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.

Arvind
Attached Files
File Type: html BOM.html (12.7 KB, 195 views)
Reply With Quote
  #2  
Old 30th March 2006, 14:50
EdwinvdBorg EdwinvdBorg is offline
Guru
 
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?

Regards,

Edwin
__________________
Regards,

Edwin
Moderator BaanBoard
E-Mail: edwin@baanboard.com
Reply With Quote
  #3  
Old 30th March 2006, 14:53
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Html Bom

Hi,
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.

Arvind
Reply With Quote
  #4  
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.

Thanks
Reply With Quote
Sponsored Links
  #5  
Old 10th May 2006, 13:13
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

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.


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

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

Ishank
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
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 13:59.


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