Division in Advanced Query

[Andrew_Vanis]

Is Division possible in Advance Query? [Trying to find transactions in Account “repairs” with Division “???” in 2024 (so I can bulk update Division to something else)]

This post seems to indicate so however it does not show for me (my screen grab below is from Receipts)

@Ealfardan

In Advanced Queries, however, you can only use document level Custom Field on tab data or use line level Division on line data, but not both.

my screen (from Receipts)

[Andrew_Vanis]

having “Division” in Advanced Query may also be a workaround if the Division Exception Report is not working

Division Exception Report (DER) - Faulty?

Division Exception Report (DER) - Faulty? - ideas on how to improve results? running the DER shows only two small expense accounts/transactions for 4 years [image] if I run a custom report where I set Division as “is empty” I get a bunch of results just for 2024 [image] [image] *************** how I got on the DER and issues with instructions and ChatBot Found Division Exception Report (DER) in this post the old guide link is lacking images etc. and asking chatBot “Division Excepti…