Where do I get Change log with timestamps for sales order status changes?
I am able to get the header overall status from CDHDR and CDPOS tables, but unable to find other statuses like Delivery status, Billing status, Rejection status changes (header and item).
If you want to see a record of changes in sales order status along with their respective timestamps, you can usually find it in your e-commerce platform’s order management system or transaction history. Look for a section named “Order History” or “Activity Log” which should give you a detailed report of all the status changes. If the information is not readily available, you can check your platform’s documentation or contact their support team to make sure you have a complete record of sales order tracking.
A time-stamped change log of sales order status changes in your sales management software is typically accessible from the order details or history section. Alternatively, the system can generate a report containing this information, providing a comprehensive overview of status changes and their timestamps.