Current PO sequence table name?

Epicor ERP 10
1

i created one PO ( 2345123) and i deleted that PO in back end , now i required that same PO number , where i can find Current PO sequence table name

2

You can configure the starting PO Number in the Company configuration screen image The table that holds the next sequence is Erp.KeyLast but Epicor does not support you changing these values directly as business logic applies and you could cause the ability to create new PO’s to fail if you do this wrong and cause any referential integrity issues.

1 Like
3

If there is a gap in the PO’s, and you want to insert a PO in that gap:

  1. Set the Starting PO to 1 more than the desired PO Num
  2. Save the Company Config
  3. in PO Entry, enter the desired PO Num and save

The trick is that any PO num above the Starting PO value must be auto generated via the highest number +1. Entering a number below that Starting PO allows it to be manually created.

image
image.png827×654 34.4 KB