Might need to leverage GLPeriod Bal - this thread might help explain
Also tagging @JasonMcD @dr_dan for advice