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

Report - Salesperson Sales Statistics

(5) Share

Report

Posted on by RR-07061806-0

854

Good day,

I'm looking at the attached report and I have a couple of questions. I checked the values from the Customer Ledger Entries as per a date range and the Sales(LCY) per codes are correct.

1. There's a difference between Profit(LCY) and Adjusted Profit(LCY), how is this profit calculated?

2. Why will there be a difference?

I'm interested in recommending this for the Sales Managers.

Regards

Rosemary

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

OussamaSabbouh 10,875 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello Rosemary,

Ultra-short:

Profit (LCY) = Sales − initial cost at invoice posting

Adjusted Profit (LCY) = Sales − final cost after cost adjustments

Why different?

Costs updated later (AVCO/FIFO, late purchase invoices, item charges, revaluation)

BC adjusts COGS after posting → profit changes

Recommendation:

Use Adjusted Profit for Sales Managers (it’s the real margin).

Regards,

Oussama Sabbouh

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

RR-07061806-0 854 on at

Like (2)

Report
Copy link

Link copied!

Good day,

Thank you very much, you were on point thanks again.

Regards

Rosemary

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,970 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Below is the calculation method for the standard code, which hopefully will give you some hints.

AdjProfit:

ProfitLCY

Thanks

ZHU

1 people found this reply helpful.

Was this reply helpful? Yes No