Great,Plains,VAR,Newsflash,Sal computer Great Plains VAR Newsflash: Sales Commission Report
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
In out-of-the-box Dynamics GP you should be able to setupbasic commission schema for your sales persons and even sales territories,however real life is often different and requires commissions to be accrued onvery complex rules. We would like tocome through some commission calculation formulas and give you technicalhighlights: 1. CreditCard related Sales commission calculations. As credit card processor has in turn its own commission, you likely aretrying to discourage your sales reps to sell on credit card. Instead, you probably encourage your salesfolks to incline customer to send overnight checks or do wire transfers. However in eCommerce scenarios credit cardsare often the only way to work with walk in customers and you got to accept creditcards. Complications with credit card acceptancebusiness might be related to the gradation on preferred and less desirablecredit card networks. In this scenarioyou would like to build sales commission report with credit card feessubtracted from the sales amount, subject to commissions 2. Projectcompletion commission schemas. These arewhen you are having your sales people to be responsible for the projectdelivery, including manufacturing overhead and associated purchases. In this scenario you would like to calculate commission for delivered projects,meaning invoices, which are not yet delivered in the sense of production ordersand drop ship purchases should be placed on hold 3. Othersales commission schemas. These might berelated to sales quota for the quarter or month, discounted items versus cashcow items differentiation, just to give your real life scenarios, which wouldbe difficult to implement in standard Dynamics GP functionality 4. Howcommission logic might be implemented. In our opinion, Dynamics GP, being targeted for mid-size and smaller businessesmakes it feasible to do commission on reporting level with following reportsresults data entry into either AP or Payroll module for commission disbursement 5. Technologyinsights. Commission reports should bebased on complex commission calculation SQL stored procedure or view. Reporting tool might one of the industrystandards: Crystal Reports, SQL Server Reporting Services, Excel, MicrosoftAccess, Great Plains Dexterity, C# or VB.Net report web publishing
Great,Plains,VAR,Newsflash,Sal