Question 130
At fictional Trinity Trading, the Business Central development team is supporting cross-border purchasing and reviewing AL business logic and user experience during a code quality review (MB820-4.2-139). The observed development issue is that a table stores multiple unrelated customer shipping addresses in repeated address1/address2 fields. Which observed result would most clearly show the intended correction works?
Explanation
Correct Answer
This is the outcome that directly verifies the intended correction: a customer may have multiple addresses without overwriting unrelated entries. The related solution is to represent repeating related records with an appropriate child table and explicit relationship; it is based on the principle that normalized relationships model one-to-many master data correctly.
Incorrect Answers
“Posted transactions update related entries and balances consistently” supports the separate task “use supported posting codeunits and integration events to preserve core business invariants”, not the reported problem: a table stores multiple unrelated customer shipping addresses in repeated address1/address2 fields. This case instead calls for “A customer may have multiple addresses without overwriting unrelated entries”.
“Multiple order lines retain identity, quantities and document-level relationships” concerns the separate step “use document header and line table patterns with proper linked records”. The reported issue is that a table stores multiple unrelated customer shipping addresses in repeated address1/address2 fields, so the direct response is to a customer may have multiple addresses without overwriting unrelated entries.
“Repeated imports identify existing vendors rather than multiplying records” concerns the alternative task “use stable vendor identifiers and defined match/merge rules for master data”, but the stated failure is that a table stores multiple unrelated customer shipping addresses in repeated address1/address2 fields. The required measure is to a customer may have multiple addresses without overwriting unrelated entries.