Need query to get the line level error message from the sales order
We have a business requirement to display the Error Message from the line level of the sales order in Fulfillment lines. We are getting error throw back end query for all the lines but front end does not display for all the lines.
Screenshot attached and query attached. Need to get this issue resolved as soon as possible.
Error Message to display in the report:
Order management can't schedule the item because supply isn't available. (DOO-2685270) Details: If you set the Latest Acceptable Date, then order management attempts to schedule the item no later than the Latest Acceptable Date. Here are some corrections you can try. A. Set the Requested Ship Date so there is enough time to schedule, ship, and deliver the item. B. To make sure the item doesn't ship before Requested Ship Date and arrives no later than Latest Acceptable Date, set the Latest Acceptable Date so it provides enough time to schedule and ship the item. C. If you don't set