Method Community

 

Commission Report for possible new user - Suggestions needed.

Last post 05-30-2013 1:32 PM by borlandje. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-30-2013 8:59 AM

    Commission Report for possible new user - Suggestions needed.

    First...Thanks ...

    I have a client that is interested in using Method for their salespeople across the country.

    They are in need of a commission report right now.  I thought if I could create this report within Method...this might make the sale.

    The commissions are based on Inventory Item (Cost, Sales Price from Invoice and Spiff)  The spiff is different for each item/salesperson.

    Example:

    Widget 1

    Cost  $2.00 - Pulled from Inventory Item

    Sales Price $3.00 Pulled from Invoice

    Spiff for Salesperson A is $1.00 - Currently Pulled manually from Excel (This salespersons price list)

    Spiff for Salesperson B is $1.50 - Currently Pulled from manually Excel (This salespersons price list)

    They are using QuickBooks Enterprise 11

    Any suggestions....


     

  • 05-30-2013 11:22 AM In reply to

    Re: Commission Report for possible new user - Suggestions needed.

    Answer

    Hi Borlandje,

    Here are some recommendations. First create a table for the spiff, and then import your spiff data into Method. Once that is done, you can easily preform all the calculations you wish.

    As for the report part, here are 2 ideas on top of my head.

    1) You can create a grid. Grid data are also exportable to various file formats (RTF/Excel/PDF).

    2) You can create a report using the Report Designer. This way, you can have a beautiful PDF report with just a click. To learn about how to use the Report Designer, check this blog article for videos.

    -Kalvin

    Kalvin Ng
    Customization Solutions Specialist
    Method Integration Inc.
    Local and overseas: 416.847.0400 ext. 748
    Toll Free: 1.888.925.6238 ext. 748
    Fax: 416.640.6027
    Website: http://www.methodintegration.com
  • 05-30-2013 1:32 PM In reply to

    Re: Commission Report for possible new user - Suggestions needed.


    Thanks so much...I wil relay the message

     

Page 1 of 1 (3 items)