Export Sale Prices for Items in Sales Invoices

(1) 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

All responses (5)

Answers (1)

KasparsSemjonovs 4,177 Super User 2025 Season 1 on at

Like (0)

Report

Export Sale Prices for Items in Sales Invoices

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.
Suggested answer

Jainam M. Kothari 6,006 on at

Like (1)

Report

Export Sale Prices for Items in Sales Invoices

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

Khushbu Rajvi. 14,482 Super User 2025 Season 1 on at

Like (1)

Report

Export Sale Prices for Items in Sales Invoices

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

Nitin Verma 21,544 Moderator on at

Like (0)

Report

Export Sale Prices for Items in Sales Invoices

Hi,

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

YUN ZHU 81,415 Super User 2025 Season 1 on at

Like (1)

Report

Export Sale Prices for Items in Sales Invoices

It can be exported using Configuration Package.

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

Thanks.

ZHU