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

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

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

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 :

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

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

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

Report No : whinh447701001
Derived from whinh447701000 ?

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

Document:

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