Skip to main content
Question

Quick Report Not Updating Values

  • August 14, 2026
  • 1 reply
  • 9 views
T
Sidekick (Customer)
Forum|alt.badge.img+3

 

Hi all,

My report LEFT JOINs proj_budget_control_rules to project, so projects with no budget rule at all still appear with combination_id null, and Get_Control_Total/Get_Consumed return 0 for them — same as a project with an actual $0 budget.

Is there a clean way to tell "no budget rule exists" apart from "budget rule exists with $0 consumed"? E.g. filtering on NULL combination_id before calling the API, or a status field on proj_budget_control_rules I should be checking instead. I’ve also tried adding funds and it just wont update haha.

Thanks!

1 reply

E
Hero (Employee)
Forum|alt.badge.img+10
  • Eugene Wager
  • Hero (Employee)
  • August 14, 2026

@TWilson,

If you’re willing to paste or attach your report’s SQL query to this post I could look at it and try to duplicate what you’ve done internally.  I might be able to get one or more of my coworkers who deal with supply chain and or GL data to help troubleshoot what you’ve reported here.

Terms & ConditionsAccessibility statement