Sales Order Entry when multiple items for same C customer item
I have one customer part number that relate to two different items. We want to load two items with the same customer item number but load one with expiration date of 12/30/40 and the other with 12/31/40 because we want the 12/30/40 item to default automatically.
Example
JDE item Customer Item Effective Date Expired Date
1001 KRISTIN1 9/17/19 12/30/40
2001 KRISTIN1 9/17/19 12/31/40
1001 is the one we want to default on sales order when enter order with #KRISTIN1. However, 2001 is defaulting and I think its because the short item is smaller.
Is JDE supposed to return the part number based on which one expires first - similar to what adv pricing does?