List of items with commissions

Posted by CP on May 1, 2007, 3:24 pm

Please log in for more thread options

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

Posted by Jen Losch on May 1, 2007, 4:51 pm

Please log in for more thread options

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
http://www.profad.com/files/RAMP%20Movie/RADemoProfessionalAdvantage.wmv

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 jenl@profad.com

Thanks,

Jen

"CP" wrote:

> 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

Posted by convoluted on May 1, 2007, 8:30 pm

Please log in for more thread options

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.

Hope this helps....

"CP" wrote:

> 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

Posted by Jeff @ Check Point Software on May 2, 2007, 11:46 pm

Please log in for more thread options

: quoted-printable

CP,

Attached is a report that tells one if the items are commissionable.

It does not tell you the commission amount because of the different ways =
commission is calculated. BTW, do you really want a report out there =
for each sales rep that may have different commission rates?

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

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

------=_NextPart_001_04CE_01C78CFA.EB3F1100
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>CP,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Attached is a report that tells one if =
the items=20
are commissionable.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>It does not tell you the commission amount =
because of=20
the different ways commission is calculated.  BTW, do you really =
want a=20
report out there for each sales rep that may have different commission=20
rates?</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).  If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"CP" <<A=20
=
t;=20
wrote in message <A=20
=
178047475.477239.42070@p77g2000hsh.googlegroups.com</A>...</DIV>Is=20
there a report that will list items that have a commission set=20
on<BR>them?  I want to be able to email our sales reps a list, =
but=20
haven't<BR>found a good way to do it.  The report I'd like, but =
don't=20
know how to<BR>create would have department, category, item, price, =
and=20
commission<BR>amount.<BR><BR>Thanks for any=20
help,<BR>-CP<BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_04CE_01C78CFA.EB3F1100--

------=_NextPart_000_04CD_01C78CFA.EB3F1100
Content-Type: application/octet-stream;
        name="Custom - Items - Items on Commission.qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
        filename="Custom - Items - Items on Commission.qrp"

//--- Report Summary --- //

Begin ReportSummary
ReportType =3D reporttypeItems
ReportTitle =3D " Items on Commission"
PageOrientation =3D pageorientationLandscape
OutLineMode =3D True
Groups =3D 1
GroupDescription =3D ""
DisplayLogo =3D True
LogoFileName =3D "MyLogo.bmp"
ProcedureCall =3D ""
TablesQueried =3D "FROM Item WITH(NOLOCK) LEFT JOIN Department =
WITH(NOLOCK) ON Item.DepartmentID =3D Department.ID LEFT JOIN Category =
WITH(NOLOCK) ON Item.CategoryID =3D Category.ID LEFT JOIN Supplier =
WITH(NOLOCK) ON Item.SupplierID =3D Supplier.ID"
SelCriteria =3D ""
GroupBy =3D ""
SortOrder =3D ""
End ReportSummary

//--- Title Rows ---//

Begin TitleRow
Text =3D "<Store Name>"
Font =3D "Arial"
FontBold =3D True
FontSize =3D 16
Color =3D "Blue"
End TitleRow

Begin TitleRow
Text =3D "<Report Title>"
Font =3D "Arial"
FontBold =3D True
FontSize =3D 12
Color =3D "Black"
End TitleRow

Begin TitleRow
Text =3D "Generated On <Report Date>"
Font =3D "Arial"
FontBold =3D True
FontSize =3D 10
Color =3D "Black"
End TitleRow

Begin TitleRow
Text =3D "Designed and/or modified by Microsoft Corp. and/or Check =
Point Software"
Font =3D "Arial"
FontBold =3D False
FontSize =3D 8
Color =3D "Black"
End TitleRow

//--- Filters ---//

Begin Filter
FieldName =3D "Item.Inactive"
FilterOp =3D reportfilteropEqual
FilterLoLim =3D "0"
FilterHilim =3D "0"
End Filter

Begin Filter
FieldName =3D "Item.CommissionMode"
FilterOp =3D reportfilteropNotEqual
FilterLoLim =3D "0"
FilterHilim =3D "0"
FilterNegated =3D False
FilterConnector =3D reportfilterbooleanconAND
End Filter

//--- Columns ---//

Begin Column
FieldName =3D "Department.Name"
DrillDownFieldName =3D "Department.Name"
DrillDownReportName =3D ""
Title =3D "Department"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "Category.Name"
DrillDownFieldName =3D "Category.Name"
DrillDownReportName =3D ""
Title =3D "Category"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "Supplier.SupplierName"
DrillDownFieldName =3D "Supplier.SupplierName"
DrillDownReportName =3D ""
Title =3D "Supplier"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 825
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "Item.ItemLookupCode"
DrillDownFieldName =3D "Item.ItemLookupCode"
DrillDownReportName =3D ""
Title =3D "ILC"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1200
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "Item.Description"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Description"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.ExtendedDescription"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Ext'd Description"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "Item.SubDescription1"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "!CaptionItemSubDescription1"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "Item.SubDescription2"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "!CaptionItemSubDescription2"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "Item.SubDescription3"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "!CaptionItemSubDescription3"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "Item.Notes"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Item Notes"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2115
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "Item.WebItem"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Web Item"
VBDataType =3D vbBoolean
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1057
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
FieldName =3D "Item.BinLocation"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Bin Location"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1140
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.Quantity"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Qty"
VBDataType =3D vbDouble
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodNone
ColFormat =3D "####"
End Column

Begin Column
FieldName =3D "Item.QuantityCommitted"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Qty Comm."
VBDataType =3D vbDouble
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodNone
ColFormat =3D "####"
End Column

Begin Column
FieldName =3D "Item.Cost"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Cost"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.Price"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Price"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.PriceA"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Price A"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.PriceB"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Price B"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.PriceC"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Price C"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.PriceLowerBound"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Lo Bound"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.PriceUpperBound"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Hi Bound"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.SalePrice"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Sale Price"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.SaleStartDate"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Sale Starts"
VBDataType =3D vbDate
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.SaleEndDate"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Sale Ends"
VBDataType =3D vbDate
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.MSRP"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "MSRP"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 900
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.ReorderPoint"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Reorder Pt."
VBDataType =3D vbDouble
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1065
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.RestockLevel"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Restock Level"
VBDataType =3D vbDouble
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodNone
ColFormat =3D "####"
End Column

Begin Column
FieldName =3D "Item.LastSold"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Last Sold"
VBDataType =3D vbDate
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Item.Inactive"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Inactive"
VBDataType =3D vbBoolean
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1057
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
FieldName =3D "Item.CommissionMode"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Commission Mode"
VBDataType =3D vbBoolean
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

------=

Posted by CP on May 4, 2007, 11:21 pm

Please log in for more thread options

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
Lone Star Comics
http://www.mycomicshop.com

On May 2, 10:46 pm, "Jeff @ Check Point Software"

> CP,

> Attached is a report that tells one if the items are commissionable.

> It does not tell you the commission amount because of the different ways

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

> --

> Jeff

> Check Point Software

> =====================================================

> You must be using Outlook Express/Windows Mail or some other type of newsgroup

reader to

> see and download the file attachment(s). If you are not using a reader, follow

> the link below to setup Outlook Express. Click on "Open with newsreader"

> under the MS Retail Management System on the right.

> http://tinyurl.com/75bgz

> =====================================================

> 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

> Custom - Items - Items on Commission.qrp

> 12KDownload