Item Mapping Configuration
Item mapping tells Business Central which items to use on the sales order lines for each kind of travel booking. Without a valid mapping, bookings cannot be processed.
Search for AIR Order Item Mapping in Business Central to open the list. Each row is one mapping.
The Mapping Key
A mapping is found by matching five values from the booking. All five must match for a row to be used:
| Part of the key | Values | Where it comes from |
|---|---|---|
| Product Type | Flight, Hotel, Car Rental, Train, Ground Transport, Other | The kind of segment on the booking |
| Region | Domestic, Nordic, Nordic (Non EU), Europe, Europe (Non EU), International | Where the travel takes place (see below) |
| Service Type | Booking, Void, Exchange, Refund | The type of AIR file -- a refund uses a different item than a new booking |
| Is From Web | Yes / No | Whether the booking was made in the online booking tool |
| Plus Voucher | Yes / No | Whether the segment is a voucher booking or comes from a subcontractor vendor |
Items on the Mapping Row
Both items live on the same row -- there is no separate service fee configuration:
| Field | Purpose |
|---|---|
| Booking Item No | The item used for the travel line itself (the flight, hotel night, car rental, and so on) |
| Service Fee Item No | The item used for the service fee line that follows each booking line |
The descriptions next to each item number are shown for reference and cannot be edited here -- they come from the item card.
How the Region Is Determined
- Flights -- the system looks at every country visited on the journey and uses the widest region. A trip that stays within one country is Domestic; a trip that touches a country outside Europe becomes International.
- Hotels, car rentals, and ground transport -- the system takes the destination code on the segment, looks it up in the AIR Destinations list to find the country, and derives the region from that country. If the destination code is not in the list, the import stops and the segment goes to the Missing Destination Queue.
The region matters for more than the item choice: it also determines the VAT treatment of the service fee, which is why the destination has to be correct.
Is From Web and Plus Voucher
- Is From Web is set when the booking was made in your online booking tool. It is recognised from a marker text in the passenger comments, which an administrator can change in AIR Setup.
- Plus Voucher is set for hotel and car rental segments where your agency pays the vendor (a voucher booking) or where the vendor is marked as a subcontractor. It is always No for flights, train, ground transport, and other product types.
What Happens When a Mapping Is Missing
Processing fails, the import gets status Error, and the import log states exactly which combination was not found -- product type, region, service type, and web flag. To resolve it:
- Open AIR Order Item Mapping.
- Add a row for the missing combination and fill in both the booking item and the service fee item.
- Go back to the AIR Import List and choose Process to Order again.
Mapping problems are also caught when the items themselves are wrong -- if a mapped item does not exist, is blocked, is blocked for sales, or the service fee item has no price for that customer, the import fails with a message describing the problem.
When test mode is switched on, a missing mapping does not stop processing. The fallback items from AIR Setup are used instead and a warning is logged. See Test Mode.
Tips
- Review your mappings whenever you start selling a new type of travel product or expand into new regions.
- Remember that refunds, voids, and exchanges need their own rows -- a booking-only setup will fail the first time a refund arrives.
- Keep item descriptions clear, since they end up on the customer's invoice.