Hello,

I want to add tccom010.refa to the sale invoice layout.

This extra field has been inserted in the before.field inco 70 layout and I have added the following to the report script: -

before.inco.70:
before.layout:
select tccom010.cuno, tccom010.refa
where tccom010.cuno = :tdsls041.cuno
selectdo
endselect
The report script compiles with no errors.

But nothing gets shown on the sales invoice and I'm sure that tccom010.refa data exists for the customer on the sales invoice.

Can anybody point me in the right direction please?

Thanks

PJ

I would put it in debug mode to make sure that the select works. Is it a mis-print in your post or did you forget to add the from table tccom010 in the select statement. Did you declare the table in the script?

Mark

I think the problem is that the field tdsls041.cuno isnt defined as a Input Field of the Report.

Try to use tdsls040.cuno instead.

Good Luck


Holger

Holger - Your solution was the one I wanted, thanks

Mark - Thanks to you too for your input.

Regards

PJ