List of items with commissions

Hi there,

Retail Analytics from Professional Advantage will enable you to create that report. Basically anything that is captured in RMS can be reported on in Retail Analytics. If you would like to take a look at the product, a quick movie is available at

We also have the UCAP (Up Close and Personal) program available for RA. UCAP - we have streamlined a process to get RMS Client's data in-house, load the product and then demonstrate the full power of the product at no cost.

Please feel free to contact me if you have any questions - I can be reached at 701 235 2363 ext 248 or at snipped-for-privacy@profad.com

Thanks,

Jen

"CP" wrote:

Hello CP I believe that when you create new items the commission mode (calculation) defaults to the commission rate assigned to the sales rep; if you are setting the commission mode to the third option in the commission tab (database - items - properties - commission) and assigning the commission based on an item schedule, then you can probably run a select query in administrator; if you are assigning the commission as a percent of the sale price, this query may work

select department.name, category.name, item.itemlookupcode, item.price, item.commissionpercentsale from department, category, item where department.id = item.departmentid and category.id = item.categoryid and item.commissionmode = 2;

if you are assigning a fixed commission amount at the item level then replace item.commissionpercentsale with item.commissionamount in the above query

Once you see the results of your select query, you can go to file - export and send the results to a csv file which you can open with excel...

If you are not comfortable working with store ops administrator and if you're working with an RMS partner maybe they can help you run this query.

H> Is there a report that will list items that have a commission set on

Is there a report that will list items that have a commission set on them? I want to be able to email our sales reps a list, but haven't found a good way to do it. The report I'd like, but don't know how to create would have department, category, item, price, and commission amount.

Thanks for any help, -CP

Thank you all SO much, the report from Jeff was just about exactly what I needed, but I can't wait to work with the .csv / Excel solution as well. We already use RAMP, and I didn't know this was an option there, either. Time to bug my rep...

Thanks Again,

-CP

-------------------------------- Chris Powell General Manager L> CP,

commission is calculated. BTW, do you really want a report out there for each sales rep that may have different commission rates?

messagenews: snipped-for-privacy@p77g2000hsh.googlegroups.com...

In case it helps anyone else, I modified the query for use in Administrator a bit. I may try to put this into Crystal Reports where it would look snazzy, but it accomplishes all my goals for the moment. All of our sales reps earn the same amount, so everything is based on the item, not individual sales reps. Obviously, that won't be the case for everyone, so this report may only be useful in a situation like ours...

The revised query:

select department.name, category.name, item.itemlookupcode, item.price, item.commissionpercentsale, item.commissionamount from department, category, item where department.id = item.departmentid and category.id item.categoryid and item.commissionmode = 2 and (item.commissionpercentsale 0 or item.commissionamount 0)

Thanks Again,

-CP

----------------------------- Chris Powell General Manager L> Thank you all SO much, the report from Jeff was just about exactly

commission is calculated. BTW, do you really want a report out there for each sales rep that may have different commission rates?

newsgroup reader to