Work EngineRoots Solutions
Administration

Connecting…

Rules & Calculation Formulas · Executed rulesOperational Master Data RepositoriesRules & Calculation FormulasValue-added taxAR-2VAT · standard rate of the country of supplyIR-2

Executed rule: VAT · standard rate of the country of supply

RX-5
Failed
Result
—
By
Lina Saleh
At
15 Oct 2026, 15:49:56

Quote for the Dubai office: no VAT code for AE yet

Context

Day:
2026-10-15
Country:
AE · United Arab Emirates
Input service:
SRV-CARD-REPLACE
Input quantity:
1

Formula

VAT amount = × ÷ 100

= Waits for V-3: No record matches; there is no fallback value.

Click a term to unfold it in place; the i shows where a source value lives.

Variables in this execution

The values this execution used, each with the cell it was read from.

Click a term to unfold it in place; the i shows where a source value lives.
#Variable_idVariable_titleFormula_idFormula / value originType
1V-1Quantity [1]—
INPUT!quantity [1]
Source data
2V-2Service fee [150.00]—
MD-11!SRV-CARD-REPLACE.fee [150.00]
Source data
3V-9Service charge [150.00]IR-1
×
Calculated
4V-3VAT standard rate [!]—
MD-21|MD-22!?.rate [!]

No record matches; there is no fallback value.

Rule value
5V-10VAT amount [!]IR-2
× ÷ 100

Waits for V-3: No record matches; there is no fallback value.

Calculated
5 of 5 variables● References use stable variable IDs

Steps

Each variable in the order it was evaluated: sources first, then each formula with the values it used.

  1. #1V-1QuantitySource data1 units

    Address: INPUT!quantity · Given by whoever runs the calculation (Quantity)

  2. #2V-2Service feeSource data150.00 EGP

    Address: MD-11!SRV-CARD-REPLACE.fee · Master data cell, as of 2026-10-15 · record given by input "service"

    Master data table: MD-11 · Retail Service Offerings 2026 · Record SRV-CARD-REPLACE · Record version 1 · Column fee

  3. #3V-9Service chargeCalculated150.00 EGP

    IR-1 · AR-1 Service charge: 1 × 150.00 = 150.00

  4. #4V-3VAT standard rateRule valueStopped

    Address: MD-21|MD-22!?.rate · Selected from MD-21, MD-22

    Selection rule FN-12: jurisdiction = AE (context country), treatment = standard, in effect on 2026-10-15 · Records matched: 0

    Problem: No record matches; there is no fallback value.

  5. #5V-10VAT amountCalculatedStopped

    IR-2 · AR-2 Value-added tax: 150.00 × — ÷ 100

    Problem: Waits for V-3: No record matches; there is no fallback value.