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)

Sort by

Suggested answer

Amit 2,563 on at

Like (1)

Report
Copy link

Link copied!

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,840 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 101,995 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 17,024 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

You need to customize the same based on your requirement.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,792 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Customization needed.

Was this reply helpful? Yes No