Share
ReportHow can I run a report that will show costs and profits of the business?
You’re offline. This is a read only version of the page.
45
How can I run a report that will show costs and profits of the business?
Hi
As Mr Burvik mentioned
[quote user="Inge M. Bruvik"]It is impossible to give a good professional answer to your question without knowing how you are your business is using Business Central.[/quote]He also recommended perfect guideline for you. I just add some other methods to Mr Burvik fantastic guideline
You can look into "Cost Shares Breakdown" https://archerpoint.com/breaking-out-material-labor-and-overhead-balance-sheet/ and try it for different months.
Also, you can look into "Value Entries" as well. You can filter it for Type" = "Purchase" and "Entry Type" = "Direct Cost|Variance" to get some data.
In addition you can publish page 5802 (Value Entries) in Webservice then use Excel - ODATA - Power Query to build such a report.
For Excel - OData look into: https://archerpoint.com/how-to-use-business-central-odata-feeds-to-get-data-into-excel-for-reporting/
For similar topic look into: community.dynamics.com/.../1225246
Congratulation on your new controller. It sounds like she is asking a lot of relevant questions.
It is impossible to give a good professional answer to your question without knowing how you are your business is using Business Central.
Some companies put a lot of effort into having the accurate item cost in the system at all times, some put less or none effort into that.
Some companies have routines in place so that their financial reporting is up to date every day but others only makes sure their financial reporting is up to date by the end of every month or every quarter.
In general you can do your reporting based on item transactions or financial transaction, and in an ideal world those two views of your data should match.
One report you can use is the inventory - sales statistics for the item transaction part of things.
For the financial part of things you can start by analyzing your trial balance or look at the different financial report layouts available under the account schedules.
In some cases it is necessary to customize reports to give you figures you can relate to and trust.
But again it is crucial to know how the system is used and how your accounting is organized in order to understand what data the different reports really are presenting.
Hi
if you provide more info can help a lot. I mean what is the business goal or report goal?
Also, do you mean reports different than Income Statement? or balance sheet or Trial Balance?
Also you can look into Analysis View www.inkeysolutions.com/.../
All responses (
Answers (
