In our last few entries, we have been discussing what it is like to use the financial tools in Microsoft Dynamics SL, including how batches are posted to the General Ledger, how transactions are corrected, how allocations are made, and how a posting period is closed. Today we’re going to take a look at inquiries and reporting for the General Ledger in Microsoft Dynamics SL.
In the General Ledger, under the Inquiries heading, you can click Account Summary Inquiry to open the Account Summary Inquiry window. This window enables you to see what you’ve put against an account. You can type in the account or do a lookup. When you have selected the account you want, you just click the Display Refresh button, and you’ll see the selected account’s balance and budget. Click the Details button at the bottom of the screen to see the information broken down by subaccount. If you select a subaccount, you can click the Details button again for more information, and you can drill down to the original transaction for any listed item.
Reports are handily listed under the Reports heading. Microsoft Dynamics SL comes with a great many reports, and you can customize them to show exactly what you want them to. The Trial Balance report, as one example, will show you the beginning, current, and ending balance for an account and/or subaccount. You’ll be able to see when transactions occurred, and you can mark items that require adjustments.
The Detail General Ledger report also shows transactions and beginning and ending balances, and it is good for auditing, for archiving, and for reconciling against Accounts Payable and Accounts Receivable. The General Ledger Transactions report lists all transactions, whether posted or unposted.
