Update of existing bill of material line records rounding up method and qty rounding up multiples

(1) Share

Report

Posted on by MacNeg

Hello,

We would like to update our existing BOM line records using data management package import. We only need to update fields - rounding up method and quantity rounding up multiples from entity Bill of Materials lines V3. Which fields should we include in the excel source file? I checked data management entity Target fields and it does not tell me the key fields to include. Is there another way to detemine for a given entity to update, which columns to include so it only does updates and not inserts or creates? Thanks a lot!

Categories:

Data Integration

All responses (4)

Answers (0)

André Arnaud de Cal... 290,532 Super User 2024 Season 2 on at

Like (0)

Report

Update of existing bill of material line records rounding up method and qty rounding up multiples

Thanks for your reply, MacNeg. I have marked it now for you.
MacNeg 44 on at

Like (0)

Report

Update of existing bill of material line records rounding up method and qty rounding up multiples

Thanks Andre!

I marked your last response as answer to my question, but all I get is the processing icon but does not go anywhere or saves it. :( I will try it again later.
André Arnaud de Cal... 290,532 Super User 2024 Season 2 on at

Like (1)

Report

Update of existing bill of material line records rounding up method and qty rounding up multiples

Hi MacNeg,

The primary key for this entity is a combination of two fields: BomId, and LineCreationSequenceNumber. The entity key can be found in the development environment.
André Arnaud de Cal... 290,532 Super User 2024 Season 2 on at

Like (1)

Report

Update of existing bill of material line records rounding up method and qty rounding up multiples

Moved the question to the Dynamics 365 SCM forum.