I have some issue for Order Report #

Kronology:

• Order created on 30 july
• The customer paid on 6 aug

Issue:

• Transaction details is show by "order created". It should show paid date.
• When i generate on MCP ai. The report not show this order. The prompt i use "please generate csv report for sales order for 6 august 2026". because my client want to see report order transaction date. not order created date.
• How can i see the report by transaction date. not order date? im confius about the created order date. Because the customer create order by 30 july, and paid 6 august. when i filter the report sales to show me > sales report on 6 august (the calculation is not by transaction date) - the report is by order created. but why not the report to show by transaction date for sales report by day. why by order created day. (i hope get what i means :3)

Shahjahan Jewel Sarkar Ripon