ET Customer Invoice Details: Difference between revisions
David.weller (talk | contribs) Created page with "== Summary == This report was developed as a custom request from the Brazil-based Operations team to enable them to quickly generate an invoice report for sharing with carrier ET. It forms part of an ongoing effort to streamline their workflow and support fast, efficient invoice generation and communication with the carrier. == Filters == {| class="wikitable" |+ !Filter !Description |- |Site |This is locked to the Brazil site |- |Carrier |This is locked to ET Brazil |-..." |
No edit summary |
||
| Line 131: | Line 131: | ||
|- | |- | ||
|Due Carrier (BRL) | |Due Carrier (BRL) | ||
| | |Due Carrier (BRL) = if [Exchange_rate] = null or [Exchange_rate] = 0 then "NOEXR" else [Due Carrier (USD)] * [Exchange_rate] | ||
| | |This formula calculates the Due Carrier amount in BRL by multiplying [Due Carrier (USD)] by the [Exchange_rate]. | ||
If the [Exchange_rate] is null or zero, the formula returns the text "NOEXR" to indicate that no valid exchange rate exists. | |||
Otherwise, it performs the conversion from USD to BRL. | |||
|- | |- | ||
|Total Revenue | |Total Revenue | ||
| Line 151: | Line 155: | ||
|- | |- | ||
|HAE Margin BRL | |HAE Margin BRL | ||
| | |HAE Margin BRL = | ||
| | if ([Exchange_rate] = null or [Exchange_rate] = 0) then null | ||
else [HAE Commission] * [Exchange_rate] | |||
|This formula calculates the HAE Margin amount in BRL by multiplying [HAE Commission 2] by the [Exchange_rate]. | |||
If the [Exchange_rate] is null or zero, the formula returns null to prevent an invalid calculation. | |||
Otherwise, it performs the conversion from the commission value to BRL. | |||
|- | |- | ||
|ET Refund (Cost BRL) | |ET Refund (Cost BRL) | ||
Revision as of 10:53, 17 July 2025
Summary
This report was developed as a custom request from the Brazil-based Operations team to enable them to quickly generate an invoice report for sharing with carrier ET.
It forms part of an ongoing effort to streamline their workflow and support fast, efficient invoice generation and communication with the carrier.
Filters
| Filter | Description |
|---|---|
| Site | This is locked to the Brazil site |
| Carrier | This is locked to ET Brazil |
| Customer | Allows the user to specifically select the customer they want to view the booking details for. Can only select a single customer, or show all. |
Data Import Calculations
[WIP]
| Calculation | Description |
|---|---|
Calculations
| Columns | Calculation | Description |
|---|---|---|
| id | ||
| master_airwaybill | ||
| Customer | ||
| Flight_Number | ||
| Depart Date | ||
| AWB Issue Date | ||
| Exchange_rate | ||
| Fixed_exRate | ||
| origin | ||
| Destination | ||
| gross_weight | ||
| chargeable_weight | ||
| Buying Rate | ||
| Buying Rate Total | ||
| Buying Currency | ||
| AWB Rate | ||
| Due Agent | ||
| HAE Over | ||
| HAE Tax USD | ||
| HAE Tax (charge currency) | ||
| HAE Tax BRL | ||
| Due Carrier (USD) | ||
| Due Carrier Total | ||
| Due Carrier (BRL) | Due Carrier (BRL) = if [Exchange_rate] = null or [Exchange_rate] = 0 then "NOEXR" else [Due Carrier (USD)] * [Exchange_rate] | This formula calculates the Due Carrier amount in BRL by multiplying [Due Carrier (USD)] by the [Exchange_rate].
If the [Exchange_rate] is null or zero, the formula returns the text "NOEXR" to indicate that no valid exchange rate exists. Otherwise, it performs the conversion from USD to BRL. |
| Total Revenue | ||
| Total Revenue Currency | ||
| HAE Invoice Customer Total (Sales BRL) | ||
| HAE Commision (BRL) | ||
| HAE Margin BRL | HAE Margin BRL =
if ([Exchange_rate] = null or [Exchange_rate] = 0) then null else [HAE Commission] * [Exchange_rate] |
This formula calculates the HAE Margin amount in BRL by multiplying [HAE Commission 2] by the [Exchange_rate].
If the [Exchange_rate] is null or zero, the formula returns null to prevent an invalid calculation. Otherwise, it performs the conversion from the commission value to BRL. |
| ET Refund (Cost BRL) | ||
| Selling Rate | ||
| Selling Rate Currency | ||
| Mode Of Payment | ||
| Due Carrier Total |