03-26-2024 06:18 AM
I'm having an issue with getting the VAT on an order over the API, via the web interface I can see the on the invoice my order correctly is 20% VAT but when I get the order via the API the totals are all correct but the VAT isn't listed, the web UI says £8.99 (incl. VAT), the API response says £8.99 with a TotalTaxAmount for the order line of £0.00. The listing is on the Global Shipping Programme but the order "eBayCollectAndRemitTax" value is set to false (if its relevant the sale/delivery is from a UK seller to a UK buyer).
I believe the API response is missing OrderArray.Order.TransactionArray.Transaction.Taxes values but I'm unsure why this would be the case.
Can anyone provide any assistance?
The invoice looks like so:
Quantity | Price | VAT rate | Total |
3 | £8.99 | 20% | £26.97 |
Subtotal (excl. VAT) | £22.48 |
Postage (excl. VAT) | £2.92 |
VAT amount | £5.07 |
Order total | £30.47 |
And the API response for this order (filtered out any identifying information):
<?xml version='1.0' encoding='UTF-8'?>
<GetOrdersResponse xmlns="urnapis:eBLBaseComponents">
<Timestamp>2024-03-25T16:32:36.638Z</Timestamp>
<Ack>Success</Ack>
<Version>1349</Version>
<PaginationResult>
<TotalNumberOfPages>1</TotalNumberOfPages>
<TotalNumberOfEntries>1</TotalNumberOfEntries>
</PaginationResult>
<HasMoreOrders>false</HasMoreOrders>
<OrderArray>
<Order>
<OrderID>**REMOVED**</OrderID>
<OrderStatus>Completed</OrderStatus>
<AdjustmentAmount currencyID="GBP">0.0</AdjustmentAmount>
<AmountPaid currencyID="GBP">30.47</AmountPaid>
<AmountSaved currencyID="GBP">7.0</AmountSaved>
<CheckoutStatus>
<eBayPaymentStatus>NoPaymentFailure</eBayPaymentStatus>
<LastModifiedTime>2024-02-15T05:05:40.000Z</LastModifiedTime>
<PaymentMethod>CreditCard</PaymentMethod>
<Status>Complete</Status>
<IntegratedMerchantCreditCardEnabled>false</IntegratedMerchantCreditCardEnabled>
<PaymentInstrument>CreditCard</PaymentInstrument>
</CheckoutStatus>
<ShippingDetails>
<SalesTax>
<SalesTaxPercent>20.0</SalesTaxPercent>
<ShippingIncludedInTax>false</ShippingIncludedInTax>
<SalesTaxAmount currencyID="GBP">0.0</SalesTaxAmount>
</SalesTax>
<ShippingServiceOptions>
<ShippingService>UK_RoyalMailSecondClassStandard</ShippingService>
<ShippingServiceCost currencyID="GBP">10.5</ShippingServiceCost>
<ShippingServicePriority>1</ShippingServicePriority>
<ExpeditedService>false</ExpeditedService>
<ShippingTimeMin>2</ShippingTimeMin>
<ShippingTimeMax>3</ShippingTimeMax>
</ShippingServiceOptions>
<SellingManagerSalesRecordNumber>**REMOVED**</SellingManagerSalesRecordNumber>
<GetItFast>false</GetItFast>
</ShippingDetails>
<CreatedTime>2024-02-11T14:52:55.000Z</CreatedTime>
<ShippingAddress>
<Name>**REMOVED**</Name>
<Street1>**REMOVED**</Street1>
<Street2>**REMOVED**</Street2>
<CityName>**REMOVED**</CityName>
<StateOrProvince>**REMOVED**</StateOrProvince>
<Country>GB</Country>
<CountryName>United Kingdom</CountryName>
<Phone>**REMOVED**</Phone>
<PostalCode>**REMOVED**</PostalCode>
<AddressID>**REMOVED**</AddressID>
<AddressOwner>eBay</AddressOwner>
</ShippingAddress>
<ShippingServiceSelected>
<ShippingService>UK_RoyalMailSecondClassStandard</ShippingService>
<ShippingServiceCost currencyID="GBP">3.5</ShippingServiceCost>
<ShippingPackageInfo>
<ActualDeliveryTime>2024-02-14T11:25:22.000Z</ActualDeliveryTime>
</ShippingPackageInfo>
</ShippingServiceSelected>
<Subtotal currencyID="GBP">26.97</Subtotal>
<Total currencyID="GBP">30.47</Total>
<TransactionArray>
<Transaction>
<Buyer>
<Email>Invalid Request</Email>
<VATStatus>VATTax</VATStatus>
<UserFirstName>**REMOVED**</UserFirstName>
<UserLastName>**REMOVED**</UserLastName>
</Buyer>
<ShippingDetails>
<SalesTax>
<SalesTaxPercent>20.0</SalesTaxPercent>
</SalesTax>
<SellingManagerSalesRecordNumber>**REMOVED**</SellingManagerSalesRecordNumber>
<ShipmentTrackingDetails>
<ShippingCarrierUsed>Royal Mail</ShippingCarrierUsed>
<ShipmentTrackingNumber>**REMOVED**</ShipmentTrackingNumber>
</ShipmentTrackingDetails>
</ShippingDetails>
<CreatedDate>2024-02-11T14:52:55.000Z</CreatedDate>
<Item>
<ItemID>**REMOVED**</ItemID>
<Site>UK</Site>
<Title>**REMOVED**</Title>
<SKU>5810</SKU>
</Item>
<QuantityPurchased>3</QuantityPurchased>
<Status>
<PaymentHoldStatus>None</PaymentHoldStatus>
<InquiryStatus>NotApplicable</InquiryStatus>
<ReturnStatus>NotApplicable</ReturnStatus>
</Status>
<TransactionID>**REMOVED**</TransactionID>
<TransactionPrice currencyID="GBP">8.99</TransactionPrice>
<ShippingServiceSelected>
<ShippingPackageInfo>
<ActualDeliveryTime>2024-02-14T11:25:22.000Z</ActualDeliveryTime>
<EstimatedDeliveryTimeMin>2024-02-14T00:00:00.000Z</EstimatedDeliveryTimeMin>
<EstimatedDeliveryTimeMax>2024-02-15T00:00:00.000Z</EstimatedDeliveryTimeMax>
<HandleByTime>2024-02-12T23:59:59.000Z</HandleByTime>
<MinNativeEstimatedDeliveryTime>2024-02-14T00:00:00.000Z</MinNativeEstimatedDeliveryTime>
<MaxNativeEstimatedDeliveryTime>2024-02-15T00:00:00.000Z</MaxNativeEstimatedDeliveryTime>
</ShippingPackageInfo>
</ShippingServiceSelected>
<ShippedTime>2024-02-12T17:00:26.000Z</ShippedTime>
<TransactionSiteID>UK</TransactionSiteID>
<Platform>eBay</Platform>
<Taxes>
<TotalTaxAmount currencyID="GBP">0.0</TotalTaxAmount>
<TaxDetails>
<Imposition>SalesTax</Imposition>
<TaxDescription>SalesTax</TaxDescription>
<TaxAmount currencyID="GBP">0.0</TaxAmount>
<TaxOnSubtotalAmount currencyID="GBP">0.0</TaxOnSubtotalAmount>
<TaxOnShippingAmount currencyID="GBP">0.0</TaxOnShippingAmount>
<TaxOnHandlingAmount currencyID="GBP">0.0</TaxOnHandlingAmount>
</TaxDetails>
</Taxes>
<ActualShippingCost currencyID="GBP">3.5</ActualShippingCost>
<ActualHandlingCost currencyID="GBP">0.0</ActualHandlingCost>
<OrderLineItemID>**REMOVED**</OrderLineItemID>
<InventoryReservationID>**REMOVED**</InventoryReservationID>
<ExtendedOrderID>**REMOVED**</ExtendedOrderID>
<eBayPlusTransaction>false</eBayPlusTransaction>
<GuaranteedShipping>false</GuaranteedShipping>
<GuaranteedDelivery>false</GuaranteedDelivery>
<eBayCollectAndRemitTax>false</eBayCollectAndRemitTax>
</Transaction>
</TransactionArray>
<BuyerUserID>**REMOVED**</BuyerUserID>
<PaidTime>2024-02-11T14:52:54.591Z</PaidTime>
<ShippedTime>2024-02-12T17:00:26.000Z</ShippedTime>
<EIASToken>**REMOVED**</EIASToken>
<PaymentHoldStatus>None</PaymentHoldStatus>
<IsMultiLegShipping>false</IsMultiLegShipping>
<MonetaryDetails>
<Payments>
<Payment>
<PaymentStatus>Succeeded</PaymentStatus>
<Payer type="eBayUser">**REMOVED**</Payer>
<Payee type="eBayUser">**REMOVED**</Payee>
<PaymentTime>2024-02-11T14:52:54.591Z</PaymentTime>
<PaymentAmount currencyID="GBP">30.47</PaymentAmount>
<ReferenceID type="ExternalTransactionID">**REMOVED**</ReferenceID>
<FeeOrCreditAmount currencyID="GBP">0.0</FeeOrCreditAmount>
</Payment>
</Payments>
</MonetaryDetails>
<SellerUserID>**REMOVED**</SellerUserID>
<SellerEIASToken>**REMOVED**</SellerEIASToken>
<CancelStatus>NotApplicable</CancelStatus>
<ExtendedOrderID>**REMOVED**</ExtendedOrderID>
<ContainseBayPlusTransaction>false</ContainseBayPlusTransaction>
<eBayCollectAndRemitTax>false</eBayCollectAndRemitTax>
</Order>
</OrderArray>
<OrdersPerPage>50</OrdersPerPage>
<PageNumber>1</PageNumber>
<ReturnedOrderCountActual>1</ReturnedOrderCountActual>
</GetOrdersResponse>