Instead of using period balances in column definitions, is there any way to ‘request’ XLone to extract transactions by transaction dates and not by period. This is specifically for generating Councillors’ Expenses reports with reporting period ending 14 November yearly (mayoral annual election cut off). Please share any solutions.
If you use a transactions datasource you can select transactions by Date. Start a new XLOne Report and choose Financials Data Sources/Analyser Items/Accounts and Transactions/Transactions or for AP Trans you could choose Financials Data Sources/Analyser Items/AP Transactions/AP All Transactions. The Date1 Transaction field is the default field for invoice date. Best Regards, Jamie Scott