Found differences in estimated, billed and actual cost in LCM
Sometimes the billed and actual amts are equal, sometime estimated and actual amts are equal, sometimes none are equal. What is the math behind this how the actual amt generating.
Component Number |
| Component Type | Shipment Date | Component Reference | Source Type | Item | Estimated Amount | Billed Amount | Actual Amount | LC Variance | Primary Qty | Primary UOM | Unit LC | Project | Task | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2296 |
|
| Shipment | 9-Feb-24 | LCM_SHIPMENT |
|
| 4087.81 |
| 4084.02 | -3.79 |
|
|
|
|
| |
| 1 |
|
| Line Group |
|
|
|
| 4087.81 |
| 4084.02 | -3.79 |
|
|
|
|
|
| 11 |
| Shipment Line |
| LCM_SHIP_LINE | PO | XXXXX | 4087.81 |
| 4084.02 | -3.79 | 2 | Each | 2042.01 |
|
| |
|
| TaxLine Allocation |
| BME_OFFSET_T |
|
| 0 | 0 |
|
|
|
|
|
|
| ||
|
| ||||||||||||||||
| TaxLine Allocation |
| BME_VAT_T |
|
| 0 | 0 |
|
|
|
|
|
|
| |||
|
| ||||||||||||||||
| ShipmentLine Allocation |
| LCM_SHIP_LINE |
|
| 3672.24 | 3673 | 3673 | 0.76 |
|
|
|
|
| |||
|
| ||||||||||||||||
| ChargeLine Allocation |
| AIR Freight charges |
|
| 0 |
|
|
|
|
|
|
|
| |||
|
| ||||||||||||||||
| ChargeLine Allocation |
| Customs BME |
|
| 334.45 | 298.41 | 334.45 | 0 |
|
|
|
|
| |||
|
| ||||||||||||||||
| ChargeLine Allocation |
| DO charges-Delivery Order | ||||||||||||||