Looking for a way to create a list of all orders which the ship date changed

Epicor ERP 10
1

Hi, I’m looking for a way to create a list in which at some point in time the ship date was changed. I’m looking to automate some processes within my company and if I could export this information to excel it would be incredibly helpful.

2

There are a couple of different ways you could do this. First step is to make sure change tracking is on for OrderHed, OrderDtl, OrderRel if you want to use change logs. Then create a BAQ joining the change log tables to the corresponding ERP tables and add filtering looking for changes to RequestDate and/or NeedByDate.

You could also trace the BO call that’s made when one of the dates is changed, then put a BPM on it to log to a UD table.

1 Like
3

Create a BAQ on OrderRel. Where OrderRel.PrevReqDate <> OrderRel.ReqDate. This shows that a change was made. Use the OrderRel.ChangedBy and ChangeDate to see who and when it was changed. This only gets you the last change, not all the changes. If you want that, you need to use the change tracking method @spaceage showed.

4 Likes