Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 28th June 2017, 11:47
leonchin leonchin is offline
Junior Member
 
Join Date: Nov 2008
Posts: 8
leonchin is on a distinguished road
Baan: baanLNFP3 - DB: sql - OS: win XP
Easy SQL - to Print Bar Code - LNUI

A new blog entry has been added:

Easy SQL - to Print Bar Code - LNUI

Quote:
Dear all master,
I have customise label by using easy SQL.
I would like to print out the bar code in label as well.
I try but can not get it.

Seeking your advise and guidance.

Thank you.
 leon
Reply With Quote
  #2  
Old 29th June 2017, 15:17
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
 
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 149
sasikanth is on a distinguished road
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 - DB: SQL Server - OS: Windows
Hi Leon,

Could you elaborate your Requirement, so I can check if I can help you in any way?
__________________
Sasi Kanth V
Infor ERP LN Solution Architect

Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
Reply With Quote
  #3  
Old 29th June 2017, 22:08
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,320
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Please post your questions in proper forums instead of creating blogs.

Moved to Tools Development Forum.

For printing bar codes on report, you an use bc$() function.

Check this thread for more information.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #4  
Old 25th July 2017, 09:51
leonchin leonchin is offline
Junior Member
 
Join Date: Nov 2008
Posts: 8
leonchin is on a distinguished road
Baan: baanLNFP3 - DB: sql - OS: win XP
Dear,

sorry for late reply.
I would like to print a label after warehouse receive to stick on the material.
I use whinh312 and select require data by using easy sql to print out data as label paper size format.
I would like the label i create also print the bar code on the label as well but i'm not manage to do it.
Or if I use InforLN Standard is able to print bar without any customization?

Regards
leon
Reply With Quote
  #5  
Old 1st August 2017, 13:19
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
 
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 149
sasikanth is on a distinguished road
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 - DB: SQL Server - OS: Windows
Print Bar Code Label - Standard Feature.

Hello Leon,

Infor ERP LN Supports the Label Printing as part of its standard functionality, which you can use during the Inbound/Shipment Procedures.

The fields that you can print on a Label are pre-defined. If you need any additional fields, you might have to go with Customization.

Just to give you an idea, I've quickly created a Label which is automatically printed after confirming the Receipt. Kindly find the attached sample label (including Bar code).

If you could let me know the details that you would like to print on the Label, I can check the possibilities (available in Standard) and let you know.

Hope this helps you!
Attached Images
File Type: png Receipt_Label.png (21.0 KB, 19 views)
__________________
Sasi Kanth V
Infor ERP LN Solution Architect

Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
Reply With Quote
  #6  
Old 7th August 2017, 04:42
leonchin leonchin is offline
Junior Member
 
Join Date: Nov 2008
Posts: 8
leonchin is on a distinguished road
Baan: baanLNFP3 - DB: sql - OS: win XP
Dear sir,

thank you for the below advise.

I manage print label with bar by using LN standard feature.

Just some info not able to get in the list like:-

- BP lot number
- location we specify.

Regards
leon



Quote:
Originally Posted by sasikanth View Post
Hello Leon,

Infor ERP LN Supports the Label Printing as part of its standard functionality, which you can use during the Inbound/Shipment Procedures.

The fields that you can print on a Label are pre-defined. If you need any additional fields, you might have to go with Customization.

Just to give you an idea, I've quickly created a Label which is automatically printed after confirming the Receipt. Kindly find the attached sample label (including Bar code).

If you could let me know the details that you would like to print on the Label, I can check the possibilities (available in Standard) and let you know.

Hope this helps you!
Reply With Quote
  #7  
Old 1st September 2017, 08:31
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
 
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 149
sasikanth is on a distinguished road
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 - DB: SQL Server - OS: Windows
Hello Leon,

Sorry for the late reply...

Please find the attachments with possible fields that you can print on a LABEL.

The first attachment (Number-1) contains the list of fields that you can print during the Inbound Process & the second attachment (Number-2) is for the Outbound Process.

Hope you find it useful.

Let me hear from you in case more details are required!
Attached Images
File Type: png Inbound_Possible_Fields.png (27.0 KB, 15 views)
File Type: png Outbound_Possible_Fields.png (29.4 KB, 13 views)
__________________
Sasi Kanth V
Infor ERP LN Solution Architect

Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
Reply With Quote
Sponsored Links
  #8  
Old 4th September 2017, 17:45
leonchin leonchin is offline
Junior Member
 
Join Date: Nov 2008
Posts: 8
leonchin is on a distinguished road
Baan: baanLNFP3 - DB: sql - OS: win XP
Dear Sasi,

Thank you for helping.

for the 1st attachment not able to find receive location.

Thanks again for your guidance.

regards
leon
Reply With Quote
  #9  
Old 5th September 2017, 13:02
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
 
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 149
sasikanth is on a distinguished road
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 - DB: SQL Server - OS: Windows
Hi Leon,

Can you try printing the Label with "Ship To Location" Field? I believe that would print the Location we specify in the Destination Location Field during the Receipt Process.

Do let me know your feedback.
__________________
Sasi Kanth V
Infor ERP LN Solution Architect

Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
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


All times are GMT +2. The time now is 02:25.


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