Sales Order Unit Price not loading using DMT Tool

Epicor ERP 10
1

Hi,

We are using a combined Sales Order (SO) template to upload SO.

All fields get updated via the DMT file except unit price for each item.

Is there a reason for this? is there a work around for this?

Please assist. Screenshots attached below.

image
image1366×728 62.7 KB

image
image1366×728 31.4 KB

2

Add column ‘DocUnitPrice’ and try again.

3

@fakhruddin thank you, we tried to add the DocUnitPrice column but still fails.

We are also not able to upload the Qty field.

Please share a template if you have any.

image
image1366×728 64.1 KB

4

Sales Order Detail.csv (540 Bytes) Sales Order Header.csv (800 Bytes) Sales Order Line Misc Charge.csv (89 Bytes) Sales Order Misc Charge.csv (76 Bytes) Sales Order Release.csv (173 Bytes)

1 Like
5

Thank you @fakhruddin

Would you happen to have the SO Combined template

6

Hi,
Try some ways:

  • Add column CurrencyCode on OrderHed.
  • Check logic of pricing for this customer. Check what Price List the system gets after you import. Or validate price list.
  • Try to add column OrderDtl#LockPrice = true for fixed unit price.
7

Thank you @nguyennkerp

8

Would anyone be able to share the SO combined template? We are trying to load SO’s with OTS (one time ship) address using the DMT tool.

Thank you

9

SO Combined Template.xlsx (9.2 KB)

Here’s what we use

10

Thank you so much!