Great Plains Var Newsflash: Sales Commission Report
Microsoft Dynamics GP serves vide spectrum of industries, and likely that very large percentage of Great Plains customers deploy Sales Order Processing module, especially if they also carry Inventory control and need Invoice or Sales Order itemization. In out-of-the-box Dynamics GP you should be able to setup basic commission schema for your sales persons and even sales territories, however real life is often different and requires commissions to be accrued on very complex rules. We would like to come through some commission calculation formulas and give you technical highlights:
1. Credit Card related Sales commission calculations. As credit card processor has in turn its own commission, you likely are trying to discourage your sales reps to sell on credit card. Instead, you probably encourage your sales folks to incline customer to send overnight checks or do wire transfers. However in eCommerce scenarios credit cards are often the only way to work with walk in customers and you got to accept credit cards. Complications with credit card acceptance business might be related to the gradation on preferred and less desirable credit card networks. In this scenario you would like to build sales commission report with credit card fees subtracted from the sales amount, subject to commissions
2. Project completion commission schemas. These are when you are having your sales people to be responsible for the project delivery, 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 orders and drop ship purchases should be placed on hold
3. Other sales commission schemas. These might be related to sales quota for the quarter or month, discounted items versus cash cow items differentiation, just to give your real life scenarios, which would be difficult to implement in standard Dynamics GP functionality
4. How commission logic might be implemented. In our opinion, Dynamics GP, being targeted for mid-size and smaller businesses makes it feasible to do commission on reporting level with following reports results data entry into either AP or Payroll module for commission disbursement
5. Technology insights. Commission reports should be based on complex commission calculation SQL stored procedure or view. Reporting tool might one of the industry standards: Crystal Reports, SQL Server Reporting Services, Excel, Microsoft Access, Great Plains Dexterity, C# or VB.Net report web publishing
Related Tags: dynamics gp
Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com Serving GP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Central America
Your Article Search Directory : Find in ArticlesRecent articles in this category:
- Improper Way Of Marketing Reflects Poorly On A Company.
New business, product or service everything requires visibility, awareness in order to come into the - Replacing Paper Prints With Online Versions
Nowadays saving out on resources and being additionally informative are both aspects that are in. In - Stop Smoking Effectively
If I told you of a way that you could stop smoking harmful tobacco would you believe it? Most people - What Is Runtime Error 182? And How To Fix It
Are you finding an effective way to fix runtime error 182? Do you think fixing runtime error 182 is - Do You Know How To Fix Runtime Error 87 In Minutes?
Are you finding an effective way to fix runtime error 87? Do you think fixing runtime error 87 is to - Knowledge About Avi, Avi Player, Avi Converter On Mac
Knowledge about AVI, AVI player, AVI Converter on MacWhat is an AVI?AVI, an acronym for Audio Video - Buy Your Highly Successful Email Survey Software Today
Email Survey Software- Boost Your Business and Increase ProfitsAn email survey software could be one - Xrm - The Anything Relationship Management Solution
I recently attended the Microsoft Dynamics West Region FY11 Sales Planning Retreat. This year's meet - What Are The Benefits Of Working With Electronic Medical Records
Recording medical information is a vital part of health care services. These records are necessary f - Basic Factor To Make Website Business Oriented
Internet is home for millions of websites. The online business is becoming more and more competitive
Most viewed articles in this category:
- Parental Control Software
Parental control software is software that can help parents protect their children when they are onl - Digital Asset Management Software
Managing and organizing your organization's documents is a critical component to your business's suc - AdobeRGB vs. sRGB
Understanding color spaces I'll try to explain it very simplified, but understandable for everyone - Confessions of a Prankster
I wanted to get a jump on April Fool's Day, partially because of the long, cold winter blues, and pa - Malicious Thoughts About The Spyware Ills Of My PC
Who would think I was capable of such revengeful thoughts about the parties responsible for inflicti - Recover File and Recover Deleted File Tools
Data recovery software is a very effective way of retrieving data from a worn or damaged hard disk d - Life without Windows
Ubuntu, a user-friendly version of Linux, has been running so nicely on my home PC that I decided to - What Benefit Does an Online Software Download Site Offer You?
Are you having a problem that where you find a good softeware when you consider to have a try or wan - Maintaining A Website
There was an era when people were talking about how to create a website using html coding or some ea - Benefits Of Proper Time Tracking
Have you ever written down time when you have started and finished your work? Maybe you have had mul