Padding zeros on the SO line to match PO line sequence in case of automatic PO creation (Drop ship)
Summary:
Create Purchase Order Lines in the Same Sequence as Sales Order Lines - Feature Does Not Work for Dropship Sales Order with More than 10 Lines.
Require steps to do the below solution:
padding zeros on the SO line number (e.g., 001, 002, 003,,,, 010,011,012)
Below is the snippet from the Oracle Idea labs:
We reviewed internally and agreed this is expected behavior as the SO line number is alphanumeric while the PO number is numeric. If you want them to match you can use padding zeros on the SO line number (e.g., 001, 002, 003,,,, 010,011,012) so that when the lines are processed into POs the order is maintained. Note this only applies to requisitions automatically processed. For manual processing, you need to review the document builder and ensure the lines are in the order you want them to be.