How to exclude some summary accounts from summary template
I need your help in following:
Assume I have accounting flexfiled structure as follows: Company-Cost Center-GL Account-Project code-Spare code. I have to define summary template as follows: ALL-ALL-ALL-D-ALL-ALL. And I need to exclude some values from D. I tried with cross-validation rules but it did not have effect. For example I need to have summary accounts like ALL-ALL-ALL-3000-ALL, ALL-ALL-ALL-3026-ALL, but I don't want to have summary account like ALL-ALL-ALL-T01-ALL, ALL-ALL-ALL-C02-ALL. And I would like to avoid creating rollup group for each T01, C02 and create summary template for each such code. If I have to be more precise please let me know.