How to insert DocumentLines of Type - Text via DI API

[Former Member]

Hi ,

I need to insert in a document via DI API some lines that are not the classics one with article-item code, description, quantity, price….but the new types that have been released in version 2004 (Type: Regular, Text, SubTotal) that appear inserting the column Type.

I searched in Help documentation of DI but I don't find the way to insert a line of type text with only a string of character automatically via DI API.

I know that the real table should be INV10.

Do I have to insert manually the rows necessaries with a SQL INSERT or there is a better way to do this using some object or property?

In any case I have to insert the DocEntry in this table INV10 but I don't have it until I save the entire document.

I decided to execute the Add() method of the document only at the end of the inserting of the lines so I can't use this way of

Sql query.

INV10 will be mantained in future versions of SBO?

Thank you

Andy

[rasmuswulff_jensen · Accepted solution]

Via the SDK, its still not possible...

Via SQL ... Well everything "can" be done, but I would not recommend it at all... and SAP does not support it.

And to make it worse; its not a part of the SBO2005A either. So the guess is SBO2005A SP1 will be the first version with this... else 2006A

[Former Member · Accepted solution]

So somebody can give me some suggestion about the way to insert these lines?

Thank you

[Former Member · Accepted solution]

hi

With SQL use table Doc10-->RDR10, ADO10, ...

Note: not sap support

Andrea

[Former Member · Accepted solution]

Hi Andrea,

(I attended SDK course with you)

If I would like to use a standard item code, for example '-' with a different description passed via DI API without using other table INV10 ecc... is it possible to work around this problem?

Doing so with Sap B1 directly I would insert the itemcode '-' and then a CTRL+TAB to insert a particular different description. How can I have same behaviour using DI API?

Thank you

Andy

[Former Member · Accepted solution]

Hi

You can try to set with Di the property ItemDescription of document_lines object. If this not work, I think is not possible with this version

Andrea

[Former Member · Accepted solution]

It works well, I can change ItemDescription on line items without problem.

Do you think this is a good work around to insert textual information without using SQL INSERT directly in tables as INV10?

Thank you

Andy