Preventing Duplicate IDs in Integrations:
"Suppose two different external systems are both integrating vendor records into D365 F&O, and both are providing their own Vendor ID values. You start seeing errors due to duplicate vendor IDs in F&O. What might be causing this, and how can you redesign the integration to prevent duplicate or colliding IDs?"
Interviewer guidance: Expect recognition that multiple masters assigning the same identifier can cause collisions. The candidate should propose solutions like assigning different ID ranges or prefixes to each external system, or better, letting F&O generate the vendor IDs to maintain a single source of truth. They should also mention configuration (set vendor account number sequence to manual if external IDs are used) and possibly using prefixes or ranges per source system as a partitioning strategy to avoid overlaps.