Export Sale Prices for Items in Sales Invoices

(2) Share

Report

Posted on by MS-17032020-0

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

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

YUN ZHU 95,574 Super User 2025 Season 2 on at

Like (2)

Report

It can be exported using Configuration Package.

More details: https://yzhums.com/4286/

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Nitin Verma 21,708 Moderator on at

Like (1)

Report

Hi,

You can try to run this report : Customer/Item Sales

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,439 Super User 2025 Season 2 on at

Like (2)

Report

more details: https://learn.microsoft.com/en-us/dynamics365/business-central/reports/report-113

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/about-export-data

Was this reply helpful? Yes No
KasparsSemjonovs 4,766 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No