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

commission in business central

(4) Share

Report

Posted on by Lethiwe Siwela

Hi All,

Please suggest how I can use commission in the sales invoice, or pull the commission from the posted sales invoice lines by sales person code.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Amit 2,557 on at

Like (1)

Report

Hi,

For this Setup Commission Percentage in Sales Person Master and then developed report and in that report develop logic-

Filter Sales Person code on Sales Invoice Header and get sum of value of total invoice and write percentage formula. In this way commission percentage calculate.

Regards

Amit Sharma

www.erpconsultors.com

www.linkedin.com/.../

Press Yes if info is useful.

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (1)

Report

Commissions work quite well in standard system.

You have Salespersons/Purchaser list - where You list all Your sales persons, and for each You can define Commission % for sales.

On each Sales document, the Salesperson code has to be provided.

Then at end of each month, You can run a report - "Salesperson - Commission" and see what commission each salesperson has earned.

Was this reply helpful? Yes No
JN-29042038-0 on at

Like (1)

Report

Does anyone know if it's possible to exclude certain products in the sales commission. Like for instace the freight to customer, which often is only the cost of the freight added to the sales order.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

As far as I know there is no way to exclude it except by customization.

Hopefully other experts can give you better advice.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Hello,

You need to customize the same based on your requirement.

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

Customization needed.

Was this reply helpful? Yes No