help me,please

alberto

Hi,
is it possible to link different commissions (of the salesperson) to different items?
I'd like, for each salesperson, to assign different % commission to items.

Example

for each computer sold, my commision is 5%
for aech mouse, my commission is 1%

thanks

eromein

sure, it's possible. Although not in standaard Navision.

But contact your lcoal NRC, shouldn't be to much work....

Sbhat

Hi,

You could create another table which would have the following fields, Item No.,Commission %. This new table will also have a form and this new form will be linked to the Item card with subform link property.

You could then use this functionality in Purchase, Sales or anywhere you want. I hope you could take it from here.

Thanks
Best regards
Suresh.

eromein

I would make the following tables:

Table Comm. Group
  Table - Option - Item,Salesperson
  Commission Group Code - code - 10
  Description - Text - 30

Table Salespers. Item Commision
  Salesperson Comm. Group Code - Code - 10
  Item Comm. Group Code - Code - 10
  Commission % - Decimal - DecimalPlaces 0:2

Add "Salesperson Comm. Group Code" in the sales/purchaseperson table. With a relation to the Comm. Group table, filter table with salesperson.

Add "Item Comm. Group Code" in the item table. With a relation to the Comm. Group table, filter table with item.

This allows you to link item groups to salespersons or you can make unique groups per item. So no need to link thousends of items to salespersons.

apap

hi, to everyone and sorry to disturb the thread
i'm new in the navision and i would like also to link the salesperson to different commissions according to different items and also the commissions are changed as the time frame changes.
any help is appreciated
al.

Arhontis

Hi,

Eromein's proposal looks pretty good... Simple and flexible...

In case you want time frames, then add Starting Date and Ending Date to the Salespers. Item Commision table and maybe a additional field in the key to be able to add multiple commisions for every Commision Group...

I was planning to enable such case next week...
Thanks Eromein!

apap

hi,
thanks everybody.
I have started to implement it for a telecommunications company.