Just wanted to share this with the group after trying to figure out how to display the supplier price list with vendor part number in a BAQ/Dashboard.
Â
Using VendPart to retrieve the vendor part number in a BAQ does not work in E9. You need to bring in the PartXRefVend table, which is not one of the logical joins thate are automatically generated in the BAQ designer.
Â
Use Company, PartNum, and VendorNum as the table relations to join vendpart and PartXRefVend tables if you want to display the supplier price list info along with the vendor part number
Â
Epicor is developing an answer book for this issue after I spoke with them about it
[Non-text portions of this message have been removed]
Â
Using VendPart to retrieve the vendor part number in a BAQ does not work in E9. You need to bring in the PartXRefVend table, which is not one of the logical joins thate are automatically generated in the BAQ designer.
Â
Use Company, PartNum, and VendorNum as the table relations to join vendpart and PartXRefVend tables if you want to display the supplier price list info along with the vendor part number
Â
Epicor is developing an answer book for this issue after I spoke with them about it
[Non-text portions of this message have been removed]