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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

Export Sale Prices for Items in Sales Invoices

(2) ShareShare
ReportReport
Posted on by 7
Hi all,
 
I've been tasked with setting up a pricing system for our wholesale customers. Historically, the owner would quote based on what he felt appropriate, with prices loosely falling into markup rules, and we want to make the system more rigid.
 
I want to run a report comparing the prices for items we sold wholesale to their costs.
 
We have all the itemized invoices in Business Central under the General Posting Group of Wholesale. Is there a way to export all of these invoices to Excel, or to I need to do it invoice by invoice?
 
Thank you
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    101,995 Super User 2026 Season 1 on at
    It can be exported using Configuration Package.
     
    Thanks.
    ZHU
  • Verified answer
    Nitin Verma Profile Picture
    21,812 Moderator on at
    Hi,
     
    You can try to run this report : Customer/Item Sales
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    22,792 Super User 2026 Season 1 on at
  • Suggested answer
    Jainam M. Kothari Profile Picture
    17,006 Super User 2026 Season 1 on at
  • KasparsSemjonovs Profile Picture
    4,840 Super User 2026 Season 1 on at
    Report "Customer/Item Sales" as already suggested, 
    or just the Item Ledger Entries should be ok to see Cost amount and Sales Amount, that You can quickly export to excel and calculate the profit % etc.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,353 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,808 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,371

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans