Multiple Duplicate Line Numbers

Finance and Operations/AX Technical Forum
1

Hi All,

We have an issue where our PO’s are duplicating LINES numbers on the PO. I am just wondering if there is a reason AX allows this assides from the “Rules” e.g. when the Line been fully recieved, or possibly Fully invoiced? Not after a solution per say here, just a reasoning.

Regards and Thank you.

2

There is an unique index on PO number and Line number, so there should not be any duplicate line numbers for a given purchase order.

3

Thanks for the reply Kranthi.

I agree However I do have examples that show we do have A PO with Line level and Numbers are:

1

2

2

2

3

4

5

6

6

4

Are you not getting the synchronization errors?

5

NO, there are no errors to be had, it looks like it is allowing it, just not sure why?

6

see if the index is enabled and is unique

7

can you write a job like Purchline purchline1,purchline2; int i; ; while select purchline1.lineAmount==purchline2.linelineAmount && purchline1.recID!=purchline2.recID { i++; purchline1.dodelete(); }