Hi Epicor community,
We have a very overdue initiative for bringing some historical data (mainly orders) into Epicor.
I am not sure why this was not done before moving to Epicor and am stuck with this.
The problem is all of these orders need to be placed at index 1 of the table (and push all other orders down). The challenge is I cannot use a prefix or even leading zeros and have run out of ideas plus those orders already have some order numbers from the previous platform and I need to preserve those as well (I could use a UD field, no problem though).
Could you please let me know if you can come up with any ideas?