Item substitutes and cross-references in Business Central

Inventory operations are rarely as tidy as the master data suggests. Customers ask for items you've discontinued. Suppliers ship the new generation when you ordered the old. Multiple suppliers offer functionally-equivalent parts. Business Central's item substitutes and item cross-references handle this complexity natively.

Item substitutes. A substitute is an alternative item that can replace the originally-requested one. Each item can have a list of substitutes with:

• Substitute No. — the alternative item.
• Interchangeable — Yes / No. Interchangeable means the substitute fully replaces; No means it requires customer approval or qualification.
• Condition — optional priority or condition.

When substitutes engage. During sales order entry, if the requested item is out of stock or otherwise unavailable:

• The sales line shows availability warning.
• The user can open the Item Substitutions action to see available alternatives.
• Selecting a substitute replaces (or adds) the line with the alternative.
• If "Interchangeable", the substitution is automatic with documentation; if not, customer approval is captured.

Use cases.

• Generation upgrades — Model 2024 substitutes for Model 2023 of the same product family.
• Brand alternatives — Brand X premium battery substitutes for Brand Y standard.
• Equivalent components — different SKUs that fit the same application.
• Discontinued items — old item still in stock; substitute is the replacement going forward.
• Quality grades — premium grade substitutes for standard if standard is out of stock.

Item cross-references. A cross-reference maps your item number to an external party's item number — most commonly:

• Customer item number — the customer's part number for the same goods. A wholesale customer may use their own SKUs that differ from yours. With cross-references, they place orders using their numbers; BC resolves to your item numbers automatically.
• Vendor item number — the supplier's part number for the same item. Useful for purchase order processing — print the vendor's part number on the PO, save the supplier from translation.
• Bar code — the EAN / UPC / GTIN code for scanning.
• Manufacturer number — when reselling another manufacturer's product, their reference number for compatibility lookups.

Cross-references are bidirectional — looking up by your item gives the cross-reference; looking up by the cross-reference (e.g. a scanned barcode) finds your item.

Cross-references at order entry. When entering a sales line, the user can:

• Type your item number directly.
• Type the customer's part number (looked up via cross-reference).
• Scan a barcode (looked up via cross-reference).

All three resolve to the same item ledger entries. The customer receives an invoice with both your part number and (optionally) their part number, depending on the document layout configuration.

Cross-references on purchases. On the purchase side, the vendor's part number can print on the PO so the supplier sees their own reference, not your internal number. Reduces translation errors and miscommunications.

Limits.

• Cross-references are flat key-value mappings; not hierarchical alternatives.
• Substitutes don't handle complex multi-item substitutions (replace one item with three different ones); for that, use BOMs or assembly orders.
• No automatic price re-evaluation when substituting — the substitute uses its own price, which may differ from the original.

Reporting and analysis.

• Substitution log — what substitutions happened, when, for which customers. Useful for product-management analysis.
• Cross-reference list per item — see all external references mapped to your items.

Common patterns.

• Distributor business — heavy use of customer cross-references; customers order with their part numbers, BC resolves.
• Industrial equipment — manufacturer cross-references for compatibility lookups.
• Aftermarket parts — substitutes for generation changes.

Common pitfalls.

• Cross-reference duplicates — the same customer's part number mapped to multiple of your items causes lookup ambiguity. Audit.
• Outdated substitutes — substitutes for discontinued items still surfacing in lookups.
• No cross-reference for major customers — every order requires manual translation, slowing the AR team.

Operational discipline. Build the cross-reference catalogue during customer / vendor onboarding. Maintain as relationships evolve. Audit during periodic data-quality reviews.