missing object in document lines

[Former Member]

Hi to all,

I want to create a draft document (type invoice) based on an order document. Now I have the problem, that I can't find an object in the document lines, representing the field 'Text' in RDR1, so how to take over the value of this field to the target document. Any ideas?

I'm using DI API Version 2004

Kind regards

Eduard

[Former Member]

Hi,

That happen to me some time ago. I used FreeText field instead of it. They are both 100 length, so I don´t think it´s going to be very difficult to change the field... unless you are already using it for another purpouse.

Regards,

Ibai Peñ

[Former Member]

Hi Ibai,

thanks for your hint, but unfortunately I have to use the mentioned field, because it has a certain behaviour in Busines One. If the user works on a document (order, delivery ...) in the lines area, he has the possibility - after a double click - to edit comfortably this field in a separate window - and as far as I know, no other text field in the document lines offers this possibility.

Kind regards

Eduard

[Former Member]

OK, now I understand.

The thext field you are talking about is not stored in the RDR1 table, it is stored in the RDR10. And the line type should be set to Text. This text lines gives you that possibility.

I havent tryed to use them using DI API, and a fast search in the help file doesnt give me any info about it.

Perhaps you could try it with the Recordset object.

Sorry,

Ibai Peñ

[Former Member]

Hi Ibai,

no, not RDR10, the field i mentioned is stored in RDR1, the database field name is Text and the database datatype is ntext, it is new in SAP Business One 2004A.

Kindly regards

Eduard