One amount, three currencies, no mystery
A translated number with no rate attached is an artifact, not an answer. This page keeps the deal’s amount, the dated rate, and the converted figure on the same line, multiplying exactly, so currency questions end at the line that raised them.
◆ Two May lines, translatedamount times rate, exact and shown.
| Line | Transaction | Rate | Functional |
|---|---|---|---|
| UK services invoice | GBP 100,000.00 | 1.274 | 127,400.00 |
| EU license fee | EUR 50,000.00 | 1.082 | 54,100.00 |
| Functional total, may | 181,500.00 |
Each functional amount is the transaction amount times the dated rate, exactly, and both stay on the line forever. The pattern is the same one-amount-qualified discipline the SAP catalog applies to currency types and ledgers, wearing Workday’s vocabulary. Sample values are illustrative, never client data.
◆ The owned answerthree columns, one line, no mystery.
The GL star’s line fact carries transaction amount and currency, rate and rate date, and functional amount as separate columns, with reporting translation derived the same visible way. Retranslation at a new rate is a new dated column set, never an overwrite, so every translated figure can always answer how.
- GL
- General ledger, the books this module lands and proves.
- SAP
- The sibling platform whose currency discipline this page mirrors.
- transaction currency
- The currency the deal was booked in.
- functional currency
- The entity’s home currency for its books.
- reporting currency
- The consolidation currency of the group.
- rate date
- When the rate was taken; on the line, always.
- retranslation
- A new dated conversion kept beside the old one.