How to show 1 copy of User data from ERP connection in BOM

Hi,

I've got an ERP connection set up to our PDM database, and I'd like to show our own part number in a BOM table.

It's mapped to User Data 0 on the manufacturer part and appears correctly in the ERP data tab in the manufacturer part properties.

I've created a bom table, and when I choose columns:

  • if I choose "Component User Data 0" nothing appears in the column
  • If I choose "User Data 0" the data gets repeated as many times as the quantity.

How can I get the ERP field listed once in a BOM column?

Thanks,

Sandy

SolidworksElectrical