web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to know how much w...

Small and medium business | Business Central, N...

Suggested answer

How to know how much we earned from the sold items tied to its Purchase Cost?

(1) Share

Report

Report

Posted on by joshtechsolutions

4,933

Hi Community,

I wonder if anyone has any advise for this.

Whenever we sell an item, AR accounts would like to know how much we earned from the sold items tied to the sold item's Purchase Cost .

Is there a way to do this in Business Central?

Thank you!`

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Rishabh Kanaskar 3,032 on at

Like (1)

Report

How to know how much we earned from the sold items tied to its Purchase Cost?

Hi,

You can analyze this directly in Business Central using the Item Ledger Entries and Value Entries tables.

> Each sales transaction links revenue with the applied purchase cost through cost application.

> To see earnings (gross margin), run the Item Sales by Customer/Item reports or build a query combining sales value and cost amount from value entries.

> This will show profit per item based on actual purchase cost applied at time of sale.

Thanks

Rishabh

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Our Community Code of Conduct has been updated!

Quick Links

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

#1

Nimsara Jayathilaka. 3,666

#2

Sumit Singh 2,885

#3

Rishabh Kanaskar 2,293

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans