The purpose of this blog is to educate clients and potential clients about issues we have run into broadly but also how we have addressed those issues with the Dynamics SL software we support.
Many companies use statistical data in combination with financial information to create key metrics that management uses to track the performance of a company. What many people don’t realize is that you can utilize Statistical Ledgers in Dynamics SL to add metrics to existing financial reports.
What is a Statistical Ledger? Statistical Ledgers are like regular Financial Ledgers except that they are for non-financial or statistical data. Instead of currency, they track units. (Financial>General Ledger>Ledger Maintenance)
For example, a company might use Revenue per Headcount to measure the efficiency and productivity of its employees. Accounts for headcount by department would need to be set up in the Chart of Account Maintenance. (Financial>General Ledger>Chart of Accounts Maintenance)
Tip: It is best to create an account using alpha charcters so the account does not get picked up in financial reports that use a range of account numbers.
Once a the accounts are set up, they can be used for reporting in Management Reporter or FRx. In our example, the calculation Revenue / Headcount could be added to the Income Statement so it would show Revenue per Headcount for each department.
Budget information can also be added by creating an additional Statistical Ledger. This would allow a company to report on variances just like financial accounts. A company can track headcount by department and not only report revenue by Headcount but also compare it to their budget.
Other examples of Unit Accounts would be number of units sold, number of calls received or resolved for a call center, number of attendees at a seminar, number of claims per month, or Voluntary/Involuntary Employee Terminations, which could be used with Total Headcount to report Turnover. Any data that is tracked and reported on could potentially be set up as an account in a Statistical Ledger.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics