HI, 

I need to be able to write a report that uses a custom field attached to every transaction in Sage X3. I have noticed that the Analytical Report contains balances and Net Monthly movements for accounts. What I need to be able to do is obtain transactions for a range of accounts over a defined period that have custom field that I am looking for. I have tried to use the Analytical GL Transaction Drill 2-1 report to achieve this, but it forces me to select only one single account, can you suggest a way to modify this report to allow me to select many rather than one account. I understand this may potentially bring back a lot of data, but I plan to limit it by a narrow date range, and just a range or revenue and expense account driven by say dimension type.