I am relatively new to JET reports, learning mostly on the fly. That said.....
We utilize division/department/subdepartment structure in Dynamics 365. Along these lines, we loaded budget data down to the subdepartment level. However, we can't seem to get our P&L reports to pull the subdepartment budgets. (No issue if we only set division and department parameters). Some "trick" we must be missing. Appreciate any insights.
Here is what the parameters look like:
What Budget
Start 11/1/25
End 11/30/25
View (blank)
Division 90
Department 580
Subdepartment 12
Budget (blank)
Connection (company name)
The formulas in that column look like this:
=-GL(X$2,$B38,X$3,X$4,X$5,X$6,X$7,X$8,,,,,X$10)