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
}
]
}
We can see the status in the response: "AsynchronousOrderStatus": "Failed". But I can't find the error message.
