Supply chain | Supply Chain Management, Commerce

Purchase order lines ordering

(1) Share

Report

Posted on by IA-11061332-0

Hello,

The purchase order is created by firming the planned purchase orders (grouped by supplier).

In the resulting PO we would like the lines to be ordered by item number (now it seems to be random).

For example, on the initial PO the lines are as follows:

Line number | Item number

1 banana

2 orange

3 apple

I'd like the order to be:

Line number | Item number

1 apple

2 banana

3 orange

If we change the lines' numbers and confirm the order, the order lines on the purchase order return to the initial ordering.

Do you know how to have the lines ordered by item number?

All responses (4)

Answers (0)

IA-11061332-0 49 on at

Like (0)

Report

Purchase order lines ordering

We start from "Master planning":

We firm several planned orders:

We have a new purchase order:

The lines are in some random order.

We can change the Line numbers to have Item numbers in order (I'd like to have it in order from the start!):

Now, we confirm the order:

In the Purchase order confirmation we find the original items' order.

Here, we have only 2 items. There could be 20, we always find the same original (random?) items' order.
Layan Jwei 7,715 Super User 2025 Season 1 on at

Like (0)

Report

Purchase order lines ordering

Hi Community member,

Can you please take a screenshot of the form you are referring to, showing before and after result to try and understand your issue
IA-11061332-0 49 on at

Like (0)

Report

Purchase order lines ordering

@Layan Jwei

No, it's not the view. There is a column "Line number". When I change those numbers I still get the initial ordering on the PO confirmation.

And it's not practical to have a lot of lines in some random order.
Suggested answer

Layan Jwei 7,715 Super User 2025 Season 1 on at

Like (0)

Report

Purchase order lines ordering

Hi Community member,

Do you mean on the form, you filtered on item number asc then you are losing this order?

One option is to save a new view and pin it as default.

Open the form - click on "Item number" field and sort it - save the view as - tick "pin as default view"

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future