Lesson 2 — The three tables and the seven sections
The specification thinks in three tables, and both variants of the file use the same three: Company Information, Purchase Listing and Supply Listing. Each has header, body and footer rows. That is the shape an auditor expects to open, and it is the shape your software has to be able to produce without hand editing.
Odoone produces seven sections, and the arithmetic between the two is worth holding in your head. Company Information is one section. Each listing gets its own section plus a separate total. And the module adds the General Ledger with its own total, which is not one of the three tables named in the specification — it is there so the listings can be tied back to the books they came from.
| Specification table | Odoone section | Its total |
|---|---|---|
| Company Information | Company Information | — |
| Purchase Listing | Supplier Purchase Listing | Supplier Purchase Listing total |
| Supply Listing | Customer Supply Listing | Customer Supply Listing total |
| — | General Ledger | General Ledger total |
The Company Information table is the one people skim and then get wrong, because it is the only part of the file that is about you rather than about your transactions. Several of its fields describe a tax agency or a tax agent acting for you, and carry content only if you use one. The specification asks it to carry:
- the taxable person's name in English and in Arabic;
- the TRN;
- the tax agency name and its TAN;
- the tax agent name and its TAAN;
- the period start and end dates;
- the FAF creation date;
- the accounting software name and version;
- the FAF version.
The TRN is not configured in this module. It is read from the shared UAE tax configuration that you set once in the VAT & Corporate Tax Reports module, so the number is defined in one place for the whole Odoone UAE tax suite. That single fact explains the most common Company Information complaint, which is in the failure mode below.
Every amount in the file is in company currency — AED. Each journal line already stores its balance in AED, and the per-line VAT on a foreign-currency invoice is converted at the posting rate, not at today's rate and not at a period-average rate. If you invoice in euros or dollars, that is the number your auditor will see, and it will not move when the exchange rate does.
Here is what the first section of Al Quoz Industrial Supplies LLC's file looks like for the quarter this course follows. The period is chosen in the wizard; everything else is read from configuration, so a blank here is a configuration gap rather than a data gap.
| Company Information field | Value in the Q2 2026 file |
|---|---|
| Taxable person name (English) | Al Quoz Industrial Supplies LLC |
| TRN | 100123456700003 |
| Period start | 1 April 2026 |
| Period end | 30 June 2026 |
| FAF version | FAFv1.0.0 |
The failure mode: an empty TRN in Company Information. It means the Tax Registration Number was never entered in the shared configuration of the VAT & Corporate Tax Reports module. Nothing in the FAF module will fix it, and there is nowhere here to type it. Enter the TRN once in that module and the FAF picks it up automatically — including in the generated file's name, which embeds it.