Range item should use store's primary language description from ITEM_MASTER_TL

User_AZJDX

At the time of ranging, the system should check the store's primary language and populate ITEM_LOC.LOCAL_ITEM_DESC accordingly:

• Store with English as primary language: use ITEM_MASTER.ITEM_DESC.
• Store with French as primary language: use the corresponding ITEM_MASTER_TL record for that language.
• If no translated record exists for the store's primary language, fall back to ITEM_MASTER.ITEM_DESC.

Business scenario

Items are created for sale in both the United States and Canada. The primary description is maintained in English in ITEM_MASTER, and a French description is maintained in ITEM_MASTER_TL to serve stores in Quebec.

Business justification

Quebec legislation requires that POS receipts be issued in French. Because the ranging process does not respect the store's primary language, the local description has to be corrected manually, item by item, after ranging. This creates:

• Recurring manual effort for the business team on every new item ranged to Quebec stores.
• A compliance risk whenever a correction is not applied before the item is sold.
• No scalable control, since the exposure grows with item volume.

Supporting translated descriptions natively at ranging would remove the manual step and make multi-language store operations compliant by default.