I'm trying to create a tree structure in the Report Designer where I have to link 3 or more sets of accounts like the following:
4150-??? or 4160-??? or 4170-???
I find, though, that the Trees will only allow you to put one OR operator on each formula, and if I want to use more than 1 OR operator, I have to use parent-child relationships in the Tree structure, which seems to be a bit of a pain.
Am I missing something, or is this how the Tree structures in the Report Designer is supposed to work?
I am using this for Sage 300 2018.
Thanks for your assistance.
This is as per design. A parent-child relationship would be the way to go.