Dynamics Community Forum Thread Details

Get retail transaction error message in OData

I'm using OData requests to get informations of sales order in retail transactions (the sales orders are created using the Commerce/CSU API, then a job creates the retail transaction, then another job synchronize them in F&O headquarter).

When the synchronization fails, I can get the status in the RetailTransactionsAuditable entity (field is AsynchronousOrderStatus). But I don't know where I can find the error message displayed in the F&O user interface. Do you guys know which data entity it is?

Here's a example of a failed retail transaction (menu is "Retail and Commerce" > "Inquiries and reports" > "Online store transactions" :

And here's the OData request to get the details:

GET /data/RetailTransactionsAuditable?cross-company=true&$filter=TransactionId eq 'CBtsToRKWv0LGyOm0y9veqM5yECr1snm'

{
 "@odata.context": "">test.sandbox.operations.dynamics.com/.../$metadata
 "value": [
 {
 "@odata.etag": "W/\"JzEsNTYzNzE0NTM0ODsyMDc1NjI2NTMsNTYzNzE1MjgyOSc=\"",
 "dataAreaId": "hfxx",
 "OperatingUnitNumber": "00000006",
 "StoreNumber": "",
 "RegisterNumber": "",
 "TransactionId": "CBtsToRKWv0LGyOm0y9veqM5yECr1snm",
 "TimeWhenTransactionClosed": 54523,
 "IsTaxExemptedForPriceInclusive": "Yes",
 "OperatingUnitRecId": 5637148336,
 "OperatorID": "",
 "DiscountAmount": 0,
 "ModeOfDelivery": "FED-Nation",
 "NetPrice": -59.18,
 "LastValidationTime": "1900-01-01T00:00:00Z",
 "TotalManualDiscountPercentage": 0,
 "CustomerAccount": "CS929000",
 "BusinessDate": "2023-02-28T12:00:00Z",
 "TransactionOrderType": "SaflesOrder",
 "AsynchronousOrderStatus": "Failed",
 "ChannelReferenceId": "0CAB8D5MORGA",
 "TransactionDate": "2023-02-28T12:00:00Z",
 "RequestedReceiptDate": "2023-02-28T12:00:00Z",
 "PaymentAmount": 0,
 "SalesOrder": "",
 "NumberOfPaymentLines": 1,
 "Comment": "",
 "Warehouse": "PON",
 "GiftCardActiveFrom": "1900-01-01T00:00:00Z",
 "TransactionType": "PendingSalesOrder",
 "RequestedShipDate": "2023-02-28T12:00:00Z",
 "EntryStatus": "None",
 "CreatedAtRegister": "",
 "GiftCardBalance": 0,
 "IsTaxIncludedInPrice": "No",
 "FiscalDocumentId": "",
 "InvoiceComment": "",
 "TaxCalculationType": "Regular",
 "DiscountAmountExcludingTax": 0,
 "GiftCardIdMasked": "",
 "ValidationStatus": "None",
 "LoyaltyCardNumber": "",
 "FiscalSerialId": "",
 "TransCode": "None",
 "Site": "",
 "GiftCardExpireDate": "1900-01-01T12:00:00Z",
 "NetAmount": -69.78,
 "NumberOfProducts": 2,
 "Description": "",
 "SkipAggregation": "No",
 "CustomerAccountAsync": "",
 "SalesPaymentDifference": 69.78,
 "SuspendedTransactionId": "",
 "Invoice": "",
 "ExchangeRate": 100,
 "SalesInvoiceAmount": 0,
 "TotalDiscountAmount": 0,
 "NumberOfProductLines": 2,
 "SalesGroup": "",
 "CustomerDiscount": 0,
 "SaleOnAccount": "No",
 "ShiftRegisterID": "",
 "IncomeExpenseAmount": 0,
 "StatementNumber": "",
 "Channel": 5637144581,
 "GrossAmount": -69.78,
 "ReceiptEmail": "test@test.com",
 "TransactionTime": 54522,
 "CreatedOffline": "No",
 "StatementCode": "",
 "GiftCardIssueAmount": 0,
 "ShiftID": 0,
 "Currency": "EUR",
 "SaleIsReturnSale": "No",
 "ReceiptNumber": "",
 "FinancialDimensionDisplayValue": "",
 "GiftCardHistoryDetails": "",
 "TotalManualDiscountAmount": 0
 }
 ]
}