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
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 2nd January 2017, 08:34
raghuvirk20 raghuvirk20 is offline
Junior Member
 
Join Date: Aug 2016
Posts: 29
raghuvirk20 is on a distinguished road
Baan: LN 10.3 - DB: Oracle - OS: Window
Not able to print customer comment in Tyco Delivery Note (Report)
Baan: ERP LN 6.1 FP3
C/S: Server

Hi All,

I have already put the customer comment (Field) in sales order session. Best on SO, WO and Tyco Deliver Note, I am trying to print the customer comment on Tyco Delivery Note (Report). but the customer comment is not printing on the report (Tyco Delivery Note). Even Customer Comment is also populated in SO table. and i am also running the application in Debugger mode. But still i am not able to find out the exact solution for that.

So any one can suggest me what is the reason behind of it.


Thanks,
Raghuvir
Reply With Quote
Sponsored Links
  #2  
Old 2nd January 2017, 09:13
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,639
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Be more specific, please

Hello,

Be more specific, please.

customer comment field ?

table.field ? tccom123.abcd, tdsls123.abcd
Is this field a text or table field ?

What is TYCO delivery note, a own developed Report in tdsls ?

Regards
__________________
//Bernd
Reply With Quote
  #3  
Old 2nd January 2017, 16:00
raghuvirk20 raghuvirk20 is offline
Junior Member
 
Join Date: Aug 2016
Posts: 29
raghuvirk20 is on a distinguished road
Baan: LN 10.3 - DB: Oracle - OS: Window
Hi,

Sorry for inconvenience, Customer Comment is a label on a report (TYCO delivery note)
tdsls400.refa , tdsls400.refb are two fields which is currently used in Sales Order Session.
TYCO delivery note is a report which is already develop in LN FP3.
The purpose of this report is to print the delivery related details for a particular item along with the customer comment.

Process : 1) Gen SO
2) Gen WO best on SO.
then after that we are generating a Tyco Delivery Note Report.

Best on SO, WO and Tyco Deliver Note (Delivery Number) , I am trying to print the customer comment on Tyco Delivery Note (Report). but the customer comment is not printing on the report (Tyco Delivery Note).

Please find the screenshot for your ref..

Please help me on this...
Thanks,
Raghuvir
Attached Images
File Type: png Tyco-Delivery Notes.png (47.4 KB, 11 views)
File Type: gif Report Output.GIF (46.3 KB, 12 views)
Reply With Quote
  #4  
Old 3rd January 2017, 12:51
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,639
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Read from tdsls400

Hello,
i can't see a field in your Layout.

If the customer comment is stored in tdsls400.refa and tdsls400.refb you have to read this Information in reportscript of delivery note.

For example :
Code:
function get.order.data()
{
	r.cofc = ""
	r.crep = ""
	r.osrp = ""
	r.bpid = ""
	r.odat = 0
	r.corn = ""
	r.refa = ""
	r.cdat = 0
	
	select	whinh431.worg,
		whinh431.worn,
		whinh431.wpon,
		whinh430.cdat:r.cdat					|su#02
	from	whinh431, whinh430					|su#02
	where	whinh431._index1 = {:shipment, :shipment.line}
	and	whinh430._index1 = {:shipment}				|su#02
	as set with 1 rows
	selectdo
		on case whinh431.worg
			|* VK-Auftrag
			case whinh.oorg.sales:
				select	tdsls400.cofc:r.cofc,
					tdsls400.crep:r.crep,
					tdsls400.osrp:r.osrp,
					tdsls400.ofbp:r.bpid,
					tdsls400.odat:r.odat,
					tdsls400.corn:r.corn,
					tdsls400.refa:r.refa
				from	tdsls400
				where	tdsls400._index1 = {:whinh431.worn}
				selectdo
				endselect
			break
			
			|* Bestellung
			case whinh.oorg.purchase:
				select	tdpur400.cofc:r.cofc,
					tdpur400.ccon:r.crep,
					tdpur400.otbp:r.bpid,
					tdpur400.odat:r.odat,
					tdpur400.sorn:r.corn,
					tdpur400.refa:r.refa
				from	tdpur400
				where	tdpur400._index1 =  {:whinh431.worn}
				selectdo
				endselect
			break
			
			|* Service
			case whinh.oorg.maint.sales:
				select	tsmsc100.soff:r.cofc,
					tsmsc100.srep:r.crep,
					tsmsc100.ofbp:r.bpid,
					tsmsc100.ordt:r.odat,
					tsmsc100.corn:r.corn,
					tsmsc100.refa:r.refa
				from	tsmsc100
				where	tsmsc100._index1 =  {:whinh431.worn}
				selectdo
				endselect
			break
		endcase
	endselect
}
Regards
__________________
//Bernd
Reply With Quote
  #5  
Old 6th January 2017, 06:29
raghuvirk20 raghuvirk20 is offline
Junior Member
 
Join Date: Aug 2016
Posts: 29
raghuvirk20 is on a distinguished road
Baan: LN 10.3 - DB: Oracle - OS: Window
Hi,

Report No : whinh447701001
-----------------------------------------
Now i have attached the customer comment Layout (screenshot). Still i am facing a problem to identify the exact reason for customer comment. i mean, why the customer comment is not printing on a report. Even i am new to LN and am trying my best to know the reason. But still i am not able to identifying the reason So,could you please help me to know the complete reason that why the customer comment is not printing.

Please help me on this.

Thanks,
Raghuvir
Attached Images
File Type: gif Customer Comment Layout.GIF (66.1 KB, 0 views)
Reply With Quote
  #6  
Old 6th January 2017, 06:31
raghuvirk20 raghuvirk20 is offline
Junior Member
 
Join Date: Aug 2016
Posts: 29
raghuvirk20 is on a distinguished road
Baan: LN 10.3 - DB: Oracle - OS: Window
Attached Customer Comment Layout

Hi,

Report No : whinh447701001
-----------------------------------------
Now i have attached the customer comment Layout (screenshot). Still i am facing a problem to identify the exact reason for customer comment. i mean, why the customer comment is not printing on a report. Even i am new to LN and am trying my best to know the reason. But still i am not able to identifying the reason So,could you please help me to know the complete reason that why the customer comment is not printing.

Please help me on this.

Thanks,
Raghuvir
Attached Images
File Type: gif Customer Comment Layout.GIF (66.1 KB, 4 views)
Reply With Quote
  #7  
Old 6th January 2017, 09:37
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,639
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Transport document

Report No : whinh447701001
Derived from whinh447701000 ?

inh 447701000 B61U a stnd 4GL Report 0 Delivery Notes 1 0 1

Document:
Code:
Customer Comment : FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF <- tdsls400.refa
                   FFFFFFFFFFFFFFFFFFFF           <- tdsls400.refb
In reportscript:
before.delnote.copy.7:
before.layout:

-- you have to read the fields (Information) from tdsls400 -- !

Regards
Attached Images
File Type: jpg whinh447701000.jpg (107.5 KB, 5 views)
__________________
//Bernd

Last edited by bdittmar : 6th January 2017 at 13:03.
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
Print History Report working correct? Judgement Project & Services 1 22nd December 2009 04:32
Report Needs to Print in Land Scape Paper Type U.R.Naga Kumar Tools Development 0 10th November 2009 05:21
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
Print multiple images in report en@frrom Tools Development 21 25th September 2006 11:20
Print a PDF file as last page in a BaaN report Bogdan Tools Development 2 9th May 2006 11:09


All times are GMT +2. The time now is 08:43.


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