Set Before/After data too slow on Sales Credit memo

nemandre · 2011-07-14

Hi Everybody,

We have got some sales invoices more than 500 lines. When we made credit memo to this invoice, we had set before/after datas.
Then I clicked OK button on Sales Correction Lines form, I'm waiting for one hour.

I tested this function:
10 lines makes about 3 sec
80 lines makes about 2 min
500 lines makes about 1 hour

Is this the normal function?

kriki · 2011-07-14

Probably there is something wrong with the C/AL in it. I have the idea that for each line in the sales invoice, it reads all lines.
so
-1 record only reads 1 record
-2 => reads 4 records
-10 => reads 100 records
-500 => reads 250.000 records

So check with the debugger what happens.

Set Before/After data too slow on Sales Credit memo

Comments

Categories