Add leading zeros to PO numbers for JD Edwards and PeopleSoft
It is possible to configure the system to pad an extracted purchase order number with leading zeroes, so it better matches data held in the purchase order header table.
You can add leading zeroes to a purchase order number, by following these steps.
- Using the menu, navigate to the Field Settings.
- In the table of fields, scroll down until you locate the PONumber field.
- Enter a Max Length of 10.
- Select Right Justify.
-
Enter the
Pad Character as 0.
This means that if 1002334 is extracted from the invoice, the system formats the purchase order number so the value becomes 0001002334.