Sage Construction & Real Estate

I'm trying to run a task that pulls prior year actuals from the GL for all accounts not equal to zero at year end, but the task returns almost 400,000 results with dozens of duplicates for each account type. Is there a way to return only distinct values…

Hi. I'm looking for a formula that I can add as one of the custom JC total fields. I need it to show "Prior Year Job to Date Cost" . Any suggestions? I'm lost on this one... Thanks, Amanda