web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Need help with running cost reports

(0) ShareShare
ReportReport
Posted on by 45

How can I run a report that will show costs and profits of the business?

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    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? 

    www.youtube.com/watch

    https://www.crestwood.com/2018/07/13/quickly-create-a-detailed-financial-statement-report-in-microsoft-dynamics-365-business-central/

    Also you can look into Analysis View www.inkeysolutions.com/.../

  • Ice1341 Profile Picture
    45 on at

    We're a small company with a new controller and she says we don't know what our costs are, raw materials up or down, ingredients, etc. and I'm trying to find a report that would have this information.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    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.

  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,468

#2
YUN ZHU Profile Picture

YUN ZHU 923 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans