Removing Vendor Price List

Epicor ERP 10
1

is there a way to remove a vendor price list without going through and deleting all parts that have been entered? I wasn’t sure if i could do it in SQL or if there is a way to remove them. I have a supplier with 5400 parts, did not want to delete part at a time.

2

@Mark_Wonsil might have a SQL script buried away somewhere…? :upside_down_face:

Use DMT - there is a Supplier Price List import. Compile the relevant data into Excel/CSV, and then use the Delete option in DMT. The parts are referenced by using #SupplierPart in front of the column name - check out the Template Builder within DMT

1 Like
3

Thanks @Mark_Wonsil, we currently don’t have access to the DMT tool so i was testing just removing in Sql and it seemed not to break anything. Haven’t tried in live.

4

:man_facepalming:

All the thanks goes to @markdamen. Mark Wonsil has no T-SQL Scripts for Epicor. :innocent: