Hi,
I need to build query report in erpnext v13, to show the stock days for each item for example:
Item Code | Date | In | Out
X | 2023-12-1 | 2 | 0
X | 2023-12-2 | 0 | 3
X | 2023-12-3 | 0 | 4
X | 2023-12-5 | 7 | 0
X | 2023-12-6 | 0 | 6
As you see 12-4 is missing, which means we don’t have any buying or selling on this day.
If I want to know the stock for this day, how I can do it using a query report?