Option to calculate commission for agents

[1-Net]

Hello,
Does anyone have a solution or an idea for calculating the commission for several agents?
We have several field representatives who work on commission.
And we have an entity where we record all customer orders, so we determine all invoice totals per order.
Now I would also like to calculate the commission for each order directly in ESPO.
You can do this per order using a formula, but we have no solution for combining several commissions into a monthly statement.

optimal solution:
1. Calculate the commission per order
2. Identify the commission per agent
3. Create a total of all commissions per agent per month or at the push of a button

Does anyone have any ideas on how this can be optimally structured or how it can be calculated via an export to an external tool (e.g. Excel)?

Thank you for your help and support

[shalmaxb]

1. In your order entity you may calculate the commission for that order
2. In your order entity you should have relationship to agents (one order, one agent), so you can link the agent to the order.
3. In the agent entity you place the relationship link to orders (many orders to one agent, displaying the commission field there also), so you can link one ore more commissions to the agent.
4. You may create an entity for collecting the commissions per month and relate that to the agent as well, so you can fetch all commissions from one agent to the choosen month. There you can sum up all commissions.

I suppose this is all possible with relationships and formula.

[1-Net]

Hello shalmaxb,
many thanks for Feedback. We will test your solution...