Something wrong on RDR10 LineNum?

[dausto]

Hello guys,
here again for your support, please.

I can't understand why in the draft A/R Invoice posted in the image below, I can see a correct sequence of the Test Lines, but in the table RDR10 it seems wrong, also if I try to print the draft CR layout. 

As you can see, in the table RDR1 I've 9 records (VisOrder from 0 to 😎 and LineNum between 1 and 11 (Line 0, 2 and 7 have been deleted), but in the RDR10 LineSeq and AftLineNum are between 0 and 8, including 2 and 7...

The result is that if I'll print the CR layout, the last text line is printed under the 8 LineNum which is wrong.

May be a bug?
It's the first case occurred and probably it depends by having modified the draft Invoice deleting LineNum 0, 2 and 7 and contextually inserting the new lines  9, 10 and 11 before saving (this did not update the RDR10) but I can't understand why in the GUI the sequence of the text lines is correct if in the table not.

SBO FP 2402 (10.00.240) MSSQL
Thank you in advance.

[ANKIT_CHAUHAN]

Hi dausto ,

Select nextNumber = VisOrder, OrderNum = 0, lineType = 'R', ItemCode from inv1 whereDocEntry = XXXX
union all
select nextNumber = AftLineNum, OrderNum, lineType, lineText from inv10 where DocEntry = XXXX
order by nextNumber, OrderNum

Please use the above logic when you are creating custom crystal layouts and share the results.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[dausto]

Hi Ankit, thank you.