Price List Update - Open Order Update

Epicor ERP 10
1

Hi,

Following a price list update, I need to update some existing orders to reflect the new price on the price list.

I had hoped that I could update the order line using the ‘Sales Order Detail’ DMT however, when I upload a data file in update mode with the following columns:

  • Company

  • OrderNum

  • OrderLine

  • OrderQty

I get the following error:

Table: ttOrderHed Msg: There are no records in the table ttOrderHed Table: OrderHed Msg: Record not found.

Has anyone got any ideas why DMT is failing or another way f doing the update?

Thanks,

Andrew.

2

Wonder if you used the template builder, what other fields you included, e.g. PartNum, RevisionNum, DocUnitPrice, etc…
I have seen similar errors when a BO wants a column(s) I did not include in my template.

Maybe via UBAQ in a Dashboard → paste/update?

3

Hi,
In the end I created a BPM on a UD table and inserted an order number into Key1.

I then retrieved the sales order tableset using the GetByID and updated the DocUnitPrice by a percentage.using custom code.

Finally I updated the sales order using the SalesOrder.MasterUpdate method.

It worked, but its a shame that DMT doesn’t work as documented.