haripra
5th June 2006, 08:18
Hi,
We Generate Excise invoice of all Sales orders & subsequently the sales Invoices & Finally PDSO. We have a sales order which is displaying the message 'Invoice data could not be written to finance for invoice no. xxxxxxx' on running PDSO for this particular Order.
What could be cause? Can anyone help me out from this situation?
Thanks in advance...
Haripra
Beniabdullah
5th June 2006, 10:51
Make sure u've Post Invoice for that Invoice Number when invoicing process.
haripra
5th June 2006, 14:53
How to Post Invoice without running PDSO? Could you please guide me.
Beniabdullah
9th June 2006, 09:50
I do not know exactly on baan 4 but try to look around at Invoicing menu for POST INVOICE process.
jan van dillen
9th June 2006, 17:17
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.
nilesh.bhosale
14th June 2006, 13:36
Typically this error is thrown when there is a mismatch in amounts from tables tdsls045 & tdsls901 due to improper updation of tables. You need to go into Change price & discount & tab through all the fields to rectify the updation error. Since Print sales invoice is done, to open the sales order line sequence from 'Change Price & Discount', you need to delete the transaction type from tdsls045 through GTM.
Tab through all the fields from 'Change price & discount' & revert the change made in tdsls045 & execute the PDSO.
THis message is followed by a error display where you can identify the error line showing amount as #########.
deepaksachdeva
14th June 2006, 16:23
Hari,
PDSO can not be re-executed, log a case with SSA global, they will help you out.
Deepak
nilesh.bhosale
18th June 2006, 13:49
PDSO has not been executed once due to error. PDSO can be executed when sales order is in the status of PDSO & record of the sales order line sequence is present in tdsls049.
haripra
27th June 2006, 13:43
The issue was resolved by verifying the amounts in tdsls901,there was a variation of amount of 0.01 in 4 records. The Order was Processed once this difference wasrectified through GTM.
Thank u Jan, Nilesh,Deepak & all for your valuable inputs.
Thank U all again
Hari Pra