Did someone customize the report?

Do you have any enhancements that affect the GL (like DSD multi-currency)?

Did you try the Recalculate Account Balances GL utility?

I have reinitialized the GL_PeriodPostingHistory and run the Recalculate Account Balances GL Utilities. No resolution.

I am running the Standard report.

We have several Sage endorsed enhancements, but none should have an impact on GL.

DSD Multi-Bin Advanced

CertiPro eLink (web-site interface)

Paya AF Fee Recovery

MAPADOC for EDI

StarShip

I have reinitialized the GL_PeriodPostingHistory and run the Recalculate Account Balances GL Utilities. No resolution.

I am running the Standard report.

We have several Sage endorsed enhancements, but none should have an impact on GL.

DSD Multi-Bin Advanced

CertiPro eLink (web-site interface)

Paya AF Fee Recovery

MAPADOC for EDI

StarShip

The "STANDARD" report setting can be edited.  Did you check for a modified Crystal Report file?  (There are a few places to check).

Have you tried with and without this checkbox enabled to see if the results change?

I checked the GL_DetailReport.rpt against a fresh install copy; they have the same size & datetime stamp. 2/10/2022 19k

I ran it normal and condensed.  No difference.

I think its the routine that's populating the work file (screen shot of SQL) with the wrong beginning balance.

You might need to open a Sage case.  How the work table data is populated is completely hidden.  There might be a bad / blank / null value somewhere, throwing off the programmed calculations, and looking without Sage assistance would be guesswork.