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

Report - Salesperson Sales Statistics

(3) Share

Report

Posted on by RR-07061806-0

623

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

Salesperson Sales...

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

OussamaSabbouh 5,796 on at

Like (2)

Report

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 623 on at

Like (2)

Report

Good day,

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

Regards

Rosemary

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

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

AdjProfit:

ProfitLCY

Thanks

ZHU

Was this reply helpful? Yes No