Do anybody the error message from session tdsls4223m000 "Invoice line could not be written to finance for order x/000"?
Please help, what do we have to do?
Regards, Juli

The message appears when the integration table can not be written.
I think "000" in the message is the order line number. This order line zero is used when an installment is invoiced. Does the order use installments, and if so, do you have the appropriate items set in the sales order parameters?

Hello,

it is a normal sales without installments, without proforma invoicing or something.
Yes, 000 is just the replacement for the order line, in the order it is 30.

Regards, Juli

Hi Juli,

The error comes from tdsls4223 when it gets a return from tfglddll4011 that it did not succeed to write an integration transaction for an invoice line.
The fields on the error text are:
tdsls045.orno
tdsls045.pono (I do not see why it is displayed as 000)

I do not see such a problem in BaaN case base.

I think that the problem can be found by debugging and / or you have to open a case.

By the way, if you want to continue processing other orders until the problem is fixed, you can temporarily remove this order lines from tdsls049 (or change their key).

Regards,
Moshe Almog

I have seen this error when one invoice results in more than 32.000 tfgld410 records. In that case Baan aborts the database transaction and gives the mentioned error message.
You should have a look at Baan solution 9316:
After printing invoices, an attempt to Process the Delivered Sales Orders results in an error message similar to "Invoice line could not be written to Finance for order 410275 line 960."
You could check in tdsls045 how many sales order lines are linked to the sales invoice. If there are a few thousand sales order lines linked to the sales invoice, this could be the cause of the problem.

I think the best way to solve this issue is to run the session tdcor4404m000 for the invoice that gave the error, change the value of the field maximum invoice lines to for example 8000 (this value depends on the number of tfgld410 records created per sales order line) in the session 'Maintain Performance boosters' (tcmcs0197m000) and print the sales invoice again.
Please note that this will result in a gap in your invoice numbering.