Procurement Confirmation Wizard Order of Lines

[Former Member]

Hi,

I have a problem in SAP B1 8.81 whith Procurement Confirmation Wizard.

When I create a Purchase Order from a Sales Order the order of lines don't be respected.

Thanks for your help

Marco

[Former Member]

But, what is the logic of insertion of lines in POR1?

[Former Member]

That might be in random order due to different constrains might have to the items.

[Former Member]

Yes, the order of lines in Purchase Order is not the same of the Sales Order.

It happens for more than one document.

The select from Sales order

LineNum; VisOrder; ItemCode; BaseLine

0;0;6458009524;NULL

1;2;0334014190;NULL

2;3;0252207412;NULL

3;4;0542943200;NULL

4;5; 6458013069;NULL

5;9;0542943200;NULL

6;10; 0580164220;NULL

7;1;6458009512;NULL

8;8;6458013069;NULL

9;6;0542943200;NULL

10;7;0580164220;NULL

The select from Purchase order

LineNum; VisOrder; ItemCode; BaseLine

0; 0; 6458009524; 0

1; 1; 0334014190; 1

2; 2; 0252207412; 2

3; 3; 0542943200; 3

4; 4; 6458013069; 4

5; 5; 6458009512; 7

6; 6; 0542943200; 9

7; 7; 0580164220; 10

8; 8; 0542943200; 5

9; 9; 0580164220; 6

10; 10; 6458013069; 8

[Former Member]

Hi,

The relationship between two tables is: POR1.BaseLine=RDR1.Linenum. I do see it confirms the logic.

That is the only link system will maintain.

Thanks,

Gordon

[jitin_chawla]

Hi,

The line are not respected meaning that the lines displayed in the Sales Order is not the same as in the Purchase Order which is created?

Can you check the visorder and the linenum field values for both the Sales Order rows table and the Purchase Order row table?

Also, is the issue happening for a document or number of documents ?

Kind Regards,

Jitin

SAP Business One Product Support