Update BAQ for ECO#, Holds, Product Code, Analysis Code, Primary Manufacturing Location

Epicor ERP 10
1

Hello,

I am interested in finding an example Update Query with list input to be able to modify these fields across a list of parts in Epicor.

Part.AnalysisCode
Part.ProdCode
Part.OnHold/Part.OnHoldDate/Part.OnHoldReasonCode
Part.PrimaryMfgLocation
PartRev.ECO

2

The built in Wizard should be able to create most of this for you. How far have you gotten?

3

Beginner-ish, somewhat confident with regular BAQ to get basic data and relationships; definitely not advanced. Waiting for update permissions still. Will try the update wizard once available to me. Item list input to BAQ didn’t seem to work well with a copy/paste functionality, only let me do line by line by line.

4

You need to make a Dashboard and deploy, then add that Dashboard Application to the menu to be able to paste many records.