help me,please

alberto
alberto Member Posts: 60
edited 2004-12-15 in Navision Attain
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

Comments

  • eromein
    eromein Member Posts: 589
    sure, it's possible. Although not in standaard Navision.

    But contact your lcoal NRC, shouldn't be to much work....
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • Sbhat
    Sbhat Member Posts: 301
    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
    eromein Member Posts: 589
    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.
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • apap
    apap Member Posts: 67
    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
    Arhontis Member Posts: 667
    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!
    Regards,
    Arhontis

    https://forum.mibuso.com/search
  • apap
    apap Member Posts: 67
    hi,
    thanks everybody.
    I have started to implement it for a telecommunications company.

Categories