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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Sales Revenue, Qty and Associated costs

(5) ShareShare
ReportReport
Posted on by 10
I am looking for a place in BC to find the costs that were assigned to an item when it was posted through the invoicing process.  Basically I want the gross margin per item.
I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    32,061 Super User 2026 Season 1 on at
    You can look at the Item Ledger Entries Page and find the entry that contains your item being sold. You can filter the page for Entry Type "Sale" and Document Type "Sales Shipment." The entries will contain both the sales price, and the cost. For example:
     

    You can also get this information for each posted sales invoice individually, in the invoice open the statistics page.



    You can then look at the following three fields



     
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    6,215 Super User 2026 Season 1 on at
    Hi,
     
    You can see the assigned cost per item in the Value Entries page. Each Value Entry shows the cost amounts posted during invoicing. To get gross margin, compare the Sales Amount (Actual) from Value Entries with the Cost Amount (Actual) for the same item. The Item Ledger Entries link you to the corresponding Value Entries.
     
    Thanks
    Rishabh
  • Suggested answer
    Jeffrey Bulanadi Profile Picture
    9,106 Super User 2026 Season 1 on at

    Hi,

    Tracking gross margin per item is essential for profitability analysis, and BC offers several clean ways to surface this data.

    Here’s how to approach it:
     

    • Use the Customer/Item Sales report: This built-in report shows invoiced quantity, sales amount, discounts, and profit per item grouped by customer. It includes applied costs and item charges, making it ideal for margin analysis.
    • Review Value Entries: Every posted sales transaction creates a value entry that links the revenue with the applied cost. You can filter by item and document type to see the exact cost applied during invoicing.
    • Combine Item Ledger Entries and Value Entries: For deeper analysis, build a query or use Power BI to join these tables. This lets you calculate gross margin per item based on actual cost application, not just standard cost.
    • Include Landed Costs via Item Charges: If you use freight, duty, or insurance charges, make sure they’re applied through Item Charges. These are included in the cost basis and reflected in the margin calculation.
    • Use Analysis Views or Inventory Valuation Reports: These can be configured to show cost and sales data by item, period, or dimension. They’re useful for trend analysis and strategic sourcing.
       

    Helpful Reference
    Customer/Item Sales report – Microsoft Learn
    Landed Cost and Item Charges – PrenticeWorx


    If you find this helpful, feel free to mark this as the suggested or verified answer.

    Cheers
    Jeffrey

  • Suggested answer
    Suresh Kulla Profile Picture
    50,269 Super User 2026 Season 1 on at
    You can use the standard reports, Sales Statistics, or Customer/Item Sales to view that information. 
  • Sumit Singh Profile Picture
    11,751 Super User 2026 Season 1 on at
    Hi All, 
     
    This question appears to date back to August 2024, and it is likely that the issue has already been resolved or the original poster has found a workaround. It is unclear why older questions are resurfacing in the latest posts. I kindly request that everyone check the posting date of query raised before responding, as the primary objective is to assist the original poster. If more than 13 months have passed, it is reasonable to assume that the user is no longer following the thread. Therefore, we should avoid commenting on such posts, as they appear in the latest feed and may lead others to engage unnecessarily. Thank you for your understanding and cooperation.
     
    @Rishabh Kanaskar, It seems that you may have started responding to older community posts. Could I kindly request you to avoid doing so?
  • Suggested answer
    Nimsara Jayathilaka. Profile Picture
    4,946 Super User 2026 Season 1 on at
    Hi
    • Cost assigned to an item on invoicing = Cost Amount (Actual) in Posted Sales Invoice Lines or in Item Ledger Entries.

    • Gross Margin per item = Revenue – Cost.

    • For bulk or historical analysis, use Item Ledger Entries or Analysis Reports / Views.

    Thanks

    Nimsara

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,821 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,122 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans