I tried several criteria already but still the result does not match. Upon further checking, this is still a system limitation and it is already filed under related Enhancements:
#281398 Lists > Search > saved Searches > Transaction > Results tab > Add Quantity or Amount column > Please provide an ‘Alternate Date/Period Range’ on saved searches, like what reports have.
Trial Balance show the accumulated amount (as of basis) for all Balance Sheet accounts (Asset, Liability, and Equity) while keeping only the current period amount (per period basis) for all Income Statement accounts (Income and Expense). Saves Search works a bit different from that of the Report Builder. We do not have an As Of option in Saved Searches similar to a Report.
Here’s the documented alternate solutions you may try: (Please note that for some cases the alternate solution might work and for some it does not)
You can create a Transaction saved search with Criteria (ex for as of Sept 2023):
Under Results:
The Preview would look like this:
Note: Some balances may have rounding off differences and the Retained Earnings Account will not match with the total.
This is because the Retained Earning is a system generated account that gets its balance from two different sources:
1) Cumulative Net Income
2) Direct posting (through Journal Entry)
The ending balance of Retained Earnings account in a period (ex. December) will be Cumulative Income + Journal Entry posting + Additional net income.
Because both beginning balance and additional net income are calculated as reporting values (instead of actual Journal Entry posting), they are not caught by the Account Register Detail report. For more information, please refer to SuiteAnswers ID 50490 : Trial Balance and Account Details do not Match for Retained Earnings.
Currently, the ability to fetch the value of the Retained Earnings and Cumulative Translation Adjustment Accounts to match the Consolidated Balance Sheet and Trial Balance is under #460818 Reports/Saved Search > Have the ability to fetch the value of the Retained Earnings and Cumulative Translation Adjustment Accounts to match the Consolidated Balance Sheet values