Commission Question

[sbrader]

Let me preface this by saying that I am an IT consultant, not an accountant. I have been building some custom reports, etc. for my client's accounting needs. They are switching to Peachtree Complete and I'm not sure how/if Peachtree handles this.

My client is a manufacturer who sells through sales reps. The sales reps earn commissions, however, the commission is not a flat percentage. Different products earn different commission rates and different reps earn different rates. There could be a number of different commission rates paid on a particular product or to a particular sales rep.

Is there a way I can easily export the necessary data to calculate this in Excel/Access/Etc?

Thanks,
Scott

[JDewey]

We have several programmers on staff that we usually have create reports like these. We have found that using PawCom or even Crystal is the easiest way, especially for these types of commissions reports. Hope this helps.