(Trial) Financial and Income Statements with drill down capability like our current accounting solution

(0) Share

Report

Posted on by kenmacd

I am currently evaluating Business Central and am tasked with ensuring it would be a viable replacement to our current system (QuickBooks Enterprise Desktop). I've already imported a ton of master data and started working on the sales process flow and learning the ropes. So far we are extremely impressed. We have been trying to get away from QB for over a decade with no luck. This looks possible though. I showed some of the capabilities to the CEO and CFO the other day and they were also impressed, but brought some things to attention that they needed for this to work.

In QB, they run tons of financial and income statements and drill down through them to eventually get to the transactions details. QB makes it very easy to start at the top by running an income statement or report, and then drill down. So they would run the Profit and Loss report, then they could drill down through the amounts to show which accounts they were posted to (Transaction Detail by Account report), and then drill down again and it would open the Invoice, Payments, etc responsible for the transaction.

The first time we ran an Income Statement in Business Central it was just a flat preview that could be printed or saved as pdf. I started researching this, and I THINK the answer will be Analysis Views built on Analysis Columns and Analysis Rows, but I'm still very new to the process in BC.

Surely something like this is possible in such a robust system. The CEO and CFO live in these reports daily and want to be able to drill down to the transaction as easily as they can in QB. Am I on the right track with Analysis Views? Also, developing a customization wouldn't be out of the question as I have an extensive background in writing websites, web apps, working in databases, etc...

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

The easiest way to do drilldown is directly from the Chart of account pages.

That pages shows net change and balance and you can do drilldown directly on those amounts.

You can also build define totals directly in the chart of accounts and do drilldown on the totals.

This combined with the flowfilters is a really helpful tool for drildown and analysing transactions.

Was this reply helpful? Yes No
kenmacd on at

Like (0)

Report

Ahhh I see. So for reports like profit and loss where they need to drill down, just create the view they need? I'm not sure what flow filters are but I will look them up.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Yes exactly. Create the view they need in the chart of accounts.

Flow filters are used to limit the transactions shown in the net change an balance. You can use them to look at net change for a time periode or across different dimensions. F.ex. you can set datefilter to show data for one accounting periode or use dimension filters to look at transaction for a spesific department, project or any other dimension you might need to report on.

Was this reply helpful? Yes No
kenmacd on at

Like (1)

Report

Thank you! I will start here. Using the Account types headers and totals is so useful and will make it a bit easier. Thanks!

Was this reply helpful? Yes No
kenmacd on at

Like (0)

Report

Well I may have picked answer too soon. So I'm working on those views, specifically Profit and Loss. I can get the accounts on the view no problem, but when I click a total, it takes me to the list of General Ledger Entries that show all the Invoices in that total. But I can't just click an Invoice number in the list to open the invoice.

I have to click ENTRY-> FIND ENTRIES and then highlight the Posted Sales Invoice entry and either pick SHOW RELATED ENTRIES or click the NO. OF ENTRIES to FINALLY open that invoice. It seems like a couple of extra unnecessary steps when I could just click the invoice number in the list above.

Am I missing something obvious here? Thank you again!

Was this reply helpful? Yes No