In Dimensions there is an Access Crystal Report called 'Current Year Balance Sheet as at' that will produce a Balance Sheet for a specific date.
To run this report:
If you are using the ribbon style menu, click Financials, and click the ACR icon.
If you are using the Module Menu/Classic style menu, from the main menu/navigation bar, click Nominal Ledger, Access Crystal Reports.
Click the Current Year Balance Sheet as at report
At the top, set the output options for the report. For example, screen or printer
Click the green tick icon
Enter your desired date in the format as per the screen instructions
Click OK.