AIR Commission Code (Table 51304)
The AIR Commission Code table defines commission rates and G/L accounts for vendor commissions. Commissions are typically earned on hotel bookings and car rentals where the travel agency acts as an intermediary.
Page
Accessible via AIR Commission Codes page (search for "AIR Commission Codes" in Business Central). This is typically a small table and can easily be entered manually in the UI.
Field Reference
| Field ID | Field Name | Data Type | Description |
|---|---|---|---|
| 1 | Code | Code[10] | Unique commission code identifier (e.g., the rate code suffix from the booking) |
| 2 | Description | Text[100] | Human-readable description of the commission |
| 3 | Commission % | Decimal | Commission percentage (0–100). Applied to the booking line's unit price |
| 4 | Receivable Account | Code[20] | G/L Account to debit for commission receivables |
| 5 | Income Account | Code[20] | G/L Account to credit for commission income |
How Commissions Work
- When an AIR booking is processed, the system checks if the sales line has a Commission Code set
- The commission code is looked up in this table to get the percentage
- The Commission Amount on the sales line is calculated as:
Unit Price × Commission % / 100 - When the order is posted, the commission is recorded using the Receivable Account (debit) and Income Account (credit)
Example Configuration
| Code | Description | Commission % | Receivable Account | Income Account |
|---|---|---|---|---|
| 10Z | Hotel Commission 10% | 10.00 | 1510 | 3510 |
| 15Z | Hotel Commission 15% | 15.00 | 1510 | 3510 |
| 20Z | Hotel Commission 20% | 20.00 | 1510 | 3510 |
| 08Z | Car Rental Commission 8% | 8.00 | 1520 | 3520 |
Config Package Notes
- Create all commission codes that appear in the customer's booking data
- Both G/L Account references must exist before importing
- The Commission % field accepts values from 0 to 100
- The Code field is limited to 10 characters
tip
Review the customer's existing booking data to identify all commission rate code suffixes in use. Each unique suffix needs a corresponding row in this table.