TextLine in new invoice

[Former Member]

Hi,

I'm building an AddOn that should periodically create standard invoices.

In these generated invoices I would like to be able te create textlines with the AddOn. Is it possible to create textlines?

B1 returns an error (-5002 itemcode missing OINV.ObjType) if I add lines without ItemCodes.

[jaccomoolenaar · Accepted solution]

As far as I know this can't be done through the DI-api. Hope this gets solved by SAP soon.

Kind regards

[Former Member]

Thanks a lot for your help (both).

I will start with the workaround by J.Moolenaar, this was my backup plan allready and it looks like there's no real option. Uploading directly into the table is possible but I don't like blocking B1's business logic.

I think we will send in a develop request for this as it is really strange that this functionality (just as subtotals) is not in the SDK.

[Former Member]

Thanks for your reply, this however is a big problem for me. If anyone knows a way to get around this problem I'ld be much obliged.

[jaccomoolenaar]

There is a "workaround":

You can use a dummy item, let's say item 'text'.

Add the text line with:

item = text

description = your text line

quantity = 0

Now all you have to do is suppress the item 'text' (and possibly other fields for this line) in your layouts.

Hope this helps.

Regards

[Former Member]

The SDK does not have the capability for text lines yet, I encountered this issue when we wanted to import text lines through DTW (DTW is written using SDK), SAP support confirmed this.

In addition, I dont see the 2005 documentations saying that it will be a feature in it too! yet.

for the data transfer, I got around the issue by direct importing to the INV10 table using a SQL script.

Indika.