List of items with commissions

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

0
genmgr1 (14)
5/1/2007 7:24:35 PM
pos 14173 articles. 0 followers. Follow

5 Replies
656 Views

Similar Articles

[PageSpeed] 57

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
> 
> 
0
JenLosch (82)
5/1/2007 8:51:02 PM
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
> 
> 
0
convoluted (621)
5/2/2007 12:30:00 AM
This is a multi-part message in MIME format.

------=_NextPart_000_04CD_01C78CFA.EB3F1100
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_04CE_01C78CFA.EB3F1100"


------=_NextPart_001_04CE_01C78CFA.EB3F1100
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 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

  "CP" <genmgr@lonestarcomics.com> wrote in message =
news:1178047475.477239.42070@p77g2000hsh.googlegroups.com...
  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>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Attached is&nbsp;a report that tells one if =
the items=20
are commissionable.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>It does not tell you the commission amount =
because of=20
the different ways commission is calculated.&nbsp; 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>&nbsp;</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>&nbsp;</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).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</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" &lt;<A=20
  =
href=3D"mailto:genmgr@lonestarcomics.com">genmgr@lonestarcomics.com</A>&g=
t;=20
  wrote in message <A=20
  =
href=3D"news:1178047475.477239.42070@p77g2000hsh.googlegroups.com">news:1=
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?&nbsp; I want to be able to email our sales reps a list, =
but=20
  haven't<BR>found a good way to do it.&nbsp; 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


------=_NextPart_000_04CD_01C78CFA.EB3F1100--

0
cptsoft (1248)
5/3/2007 3:46:11 AM
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"
<CptS...@Hotmail.com> wrote:
> 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
> =====================================================
>
>   "CP" <gen...@lonestarcomics.com> wrote in messagenews:1178047475.477239.42070@p77g2000hsh.googlegroups.com...
>   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


0
genmgr1 (14)
5/5/2007 3:21:06 AM
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
Lone Star Comics
http://www.mycomicshop.com

On May 4, 10:21 pm, CP <gen...@lonestarcomics.com> wrote:
> 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 Comicshttp://www.mycomicshop.com
>
> On May 2, 10:46 pm, "Jeff @ Check Point Software"
>
>
>
> <CptS...@Hotmail.com> wrote:
> > 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
> > =====================================================
>
> >   "CP" <gen...@lonestarcomics.com> wrote in messagenews:1178047475.477239.42070@p77g2000hsh.googlegroups.com...
> >   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- Hide quoted text -
>
> - Show quoted text -


0
genmgr1 (14)
5/5/2007 3:34:17 AM
Reply:

Similar Artilces:

Problems propagating user name changes to the global address list
May I start by saying that I do not in any way profess to be an Exchange administrator, I'm just trying to resolve this one (simple?) problem. To summarise, I am working with a small network (about 10 clients) with a Small Business Server 2003 server. All users have already been created and have their own email set-up which they access on their workstation via Outlook. All fairly standard stuff. During the set-up (some time ago!) one user's first name was spelt incorrectly. This has become more than a little niggling to said user and so I've been asked to correct it. No...

Refreshing Lists...
Greetings :) I wanted to know if anyone could tell me if there was any way to either change the list-refreshing interval, and/or disable it and force a manual list refresh. My reason for doing so is that the lagtime involved on a normal basis on my HQ Manager is becoming more and more troublesome as it tries to refresh lists multiple times every minute. Sometimes I experience hangtimes of over a minute in the middle of running a process while someone's on the line waiting. Any help would be GREATLY appreciated! This is a multi-part message in MIME format. ------=_NextPart_000_0...

Smart List #2
Trying to create a smart list accounts payable aging report and download to excel, insteat of using the report, purchasing, trial balance, etc. Need to download to excel and the "regular" report is an ugly csv file with wrapped lines. The smart list is so much easier with excel. A/R is easy in smart list, but how do you create the A/P aging? I don't see aging categories or the appropriate columns to allow you to create it. Any ideas? Thanks You could export the transaction details and exclude those transactions that have a current amount equal to 0. Then, in Excel, ...

How to change number of decimal places on an exsiting item unit pr
The existing item unit price is set to 2 decimal places. We need the item currency decimals set to 4 places. When we run the utility "Tools->Utilities->Inventory->Change Decimal Places" The audit reported generated report s the following message. "Item exists on an inventory transaction and could not be updated. "Item exists on a Purchase Order processing transaction and not be updated." Is there anythin I can do to solve the problem? Thanks GO As indicated by the error message, you cannot have any unposted inventory transactions or open purchase or...

Displaying data based on Drop Down List Selection
Hello, hope someone can help. I have a list of records in Excel which are attributed to teams in my organisation. Say its a list of staff. What I need is to be able to send the file out so that a user can select from a drop down menu the team name and the list displays all the staff in that team. I know that they could just use a filter for this themselves but these these users are not even comfortable doing that!! I need to make is simple so wanted a big obvious drop down list with the teams in, they select it and see all the relevant records. Has anybody got any ideas? Would be ver...

how to delete "Lists" tab from the left pane of project web access
I have created a document library in PWA page . In the left pane there is new document library under the Lists title with the name of EPM Support. but after 5 minutes i have deleted this one . but Lists title is still there. how can i delete this "Lists" . Kindly reply me soon. ...

Returning Items to Vendor for rework or credit
I have a couple of questions regarding returning items to vendors. We deal with inventory and non-inventory items. In most cases, the receipt of items is posted as well as the vendor invoice. How do I create a return shipping document for the shipping department? Is there a way to adjust inventory on hand? In cases where the wrong item was received, not as ordered but was posted in the receivings batch, how do I re-open this purchase order? Any help is appreciated. Debbie, Have a look at Returns Transaction Entry in Purchasing. I think it will do what you need it to,...

Excel filter list navigation
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi! <br><br>Can anyone please let me know if it is possible and/or how to navigate in a Excel list using the Autofilter drop down &quot;list&quot; without always going back to beginning of but, instead, going from the selected item (as in the PC version)? <br> I have lists of thousand items to check one by one and always going back to the beginning is a pain. <br><br>Thanks In article <59bb1352.-1@webcrossing.JaKIaxP2ac0>, RALEX@officeformac.com wrote: > Ve...

Distribution list not sending msg(s)
Hey everyone, We have a Windows 2003 domain and are running Exchange 2003 /sp1. I created a email enabled distribution list and added two people to it for a test. I selected it from the GAL and sent a test msg. but it never arrived. I went to the "Message Tracking Center" and found that it had been "Submitted to Categorizer" but never delivered local. Anyone have any ideas what might me wrong? TIA, Clayton do you have an expansion server specified on the "advanced" tab? any restrictions on the list? -- Susan Conkey [MVP] "Clayton Sutton&...

Outlook 2000 task list seems to be linked with my inbox
when I accept a task, it is added to my task list as it should be, but it also stays in my inbox. if I delete it from my inbox, it is also deleted from by task list. how can I fix this? ...

Item Import T-SQL
Does anybody have the T-SQL code to do bulk item importing in HQ. I have about 360,000 items, of which most were imported in SO before starting using the system in HQ. However, once you start using HQ, it has a new table called ItemDynamic, plus the SupplierList. I can still import items, but then you dont have info for the stores & tax. A utility can be built that updates these items, but is complex. Please reply if you already have a utility, or would like to help build one. I need one that will CREATE and item if not there, or UPDATE item description and cost if it is there...

Increasing speed when adding items to CListCtrl
Hello, Currently, in the code I've inherited, a CListCtrl is being updated by: 1. SetRedraw(FALSE) 2. DeleteAllItems() 3. value = InsertItem () 4. SetItemText(value, ...) 5. SetRedraw(TRUE) In some cases there are 10000+ records to update. Is there a quicker way to do this? Thanks /Loren ListCtrls are very slow. You could use a Listbox to speed things up. No other solutions that I know of. AliR. <loren.rogers@gmail.com> wrote in message news:1129060123.174381.36460@o13g2000cwo.googlegroups.com... > Hello, > Currently, in the code I've inherited, a CListCtrl is being ...

Sorting large Lists
I have been trying to sort large lists of data using various formulas but to no avail. The problem I have is my worksheets consist of approx 50 columns for products and 365 rows for the days of the year for each client. Because ordering patterns are not the same, I want to see when the last time a client had ordered: Example 1: Product no1, product no2 with product no18 Example 2: Product no3, product no10 with product no20 The problem I have encountered is that what ever formula I try, it always returns the last day the product was ordered not when it was last order with say product 1...

"Item Could Not Be Opened" Message
I am using Symantec Enterprise Antivirus products in conjunction with Exchange 2000. When the Antivirus program removes the virus package from an email, it still sends the header to the user's mailbox. If the user tries to open that email, they will receive a message that the item could not be opened, and sometimes they can't delete it. My Veritas Backup Exec codes these files as errors during my daily backup. Symantec says this is a limitation of VSAPI. They also said that Exchange would eventually clean these up, presumably through some maintenance feature, but that it co...

SP1 List of Fixes
Where is this document! The official link is useless http://support.microsoft.com/common/canned.aspx?H=Microsoft%20Exchange%202003%20SP1&Query=kbExchange2003sp1fix&CDID=EN-US-KB&LCID=1033&product=exch2003 Are we all mad applying this SP without knowing what it does? You can find all of the wonderful info your looking for here :D http://www.microsoft.com/technet/prodtechnol/exchange/2003/library/sp1rn.mspx -- Thanks Dave [MCP, MCSE} me@davidchadwick.com http://www.davidchadwick.com "Any intelligent fool can make things bigger, more complex, and more violent. It tak...

Sort address list by using LDAP query
I am not sure if it is possible on Exchange 2003. Currently our address book is sorted alphabetically by its display name entries. I want to sort it so all distribution lists will become on top of the list and followed by user names. On Exchange System Manager, under 'All Address Lists', I have an Address List with the following LDAP query (using 'Custom Search'): (&(&(mailnickname=*)(|(&(objectCategory=user)(company=*))(&(objectCategory=group)(displayName=*))))) Is there any LDAP keyword that I can add here so it can be sorted as I want? Thank you in adv...

Price List + Alias
Dear all, I have an upcoming catalogue/sale coming up and what would be incredible useful to have would be a report, such as the price list report, with the addtion of the barcodes. This would allow us to see what item lookup codes have a barcode (so would then need to be flagged to have them added as they come from the warehouse) and which stock could be put straight out. We did try the alias report but if there is no barcode for the product of course it will not appear on the report. We use sub description 1 as a filter to populate the report, example - LB208. Any help would be gr...

Deleting Distribution List
When I delete a Distribution List, is each Contact in the list deleted from the Address Book? -- Ed Morgan Since there is no information ever stored in the Address Book view, your question is confusing. Nor do we know if the members of the DL in question have underlying records in your Contacts Folder or just exist within the DL. If you created the DL using Contact Records that exist in your Contact Folder, the Contact Record will not be deleted when you delete the DL. -- Russ Valentine "Ed Morgan" <EdMorgan@discussions.microsoft.com> wrote in message news:...

Query Based Distribution List Note
We are running Exchange 2003 and using Query Based Distribution Lists (QBDL), viewable through the GAL. Our users are complaining (and building their own lists) because they can't see who is included in the list. We use desciptive names, but they need more information. All QBDLs are based on a company, a department or part of a title. I have asked our administrator to place in the "note" field of the QBDL what the parameter(s) were. For example, "people with COMPANY beginning with ABC". How do I tell my administrator(?) to edit the note field? Don In ADSIEdit, ...

bulleted list of parallel items
I am writing a memo that has to contain a bulleted list of parallel items I have 8 items and want to list 4x4 side by side with bullets Use two columns (Format | Columns). For more, see http://word.mvps.org/FAQs/Formatting/UsingColumns.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "peggyl" <peggyl@discussions.microsoft.com> wrote in message news:28C244B9-928B-4447-B5C5-148BFFCB347F@microsoft.com... >I am writing a memo that has to contain a bulleted list of parallel items > I have 8 items ...

File/folder drag/drop on List control
Hi, I am using a List control in an MFC application. How do I enable drag & drop of only files & folder on the List control (set to Report mode)? Regards, Steve Here is some code that might help you get started, but basically, you have an OnDropFiles() function, call DragAcceptFiles() and catch the WM_DROPFILES message: http://www.codeguru.com/cpp/controls/listview/dragdrop/article.php/c941/ // In message map ON_WM_DROPFILES() // In OnInitDialog() DragAcceptFiles(); // Handler function void CAddDataView::OnDropFiles(HDROP hDropInfo) { CDialog::OnDropFiles(hDropInfo); ...

Direct email adding items to activities list
When using direct email some emails are not sent to the contact but simply added to the activities list then I have to send them from there. This only occurs sometimes. it occrs when sending both individual mail and bulk mail. When sending to bulk mail, only some emails are added to the activities list and the rest send normally. any ideas?? ...

PDC down
Our primary domain controller bit the dust yesterday, but backup controllers took over as expected, with one exception. When using Outlook in our Exchange 2003 environment, the Global Address List is now being pulled from an old Exchange 5.5 installation, in a satellite office over the WAN, even though it's no longer an active member of the Exchange environment, (the computer is still online for other reasons, primarily as a DHCP server for the remote office where it's located), and our Exchange 2003 is still up and running fine in all other aspects. This is obviously causing problems ...

Distributing commission to multiple salesperson
Hi all, the invoices can be feeded into the sytem in either of the following ways: 1.Transactions->Sales->Invoice Entry 2.Transactions->Sales->Sales Trx Entry To distribute the commisison to multiple salesperson in case of (1) can associate more than 1 and distribute the comn amt in case of (2) can associate but there is a restriction as: the salesperson should be associated to the product Hence, it there are 2 products we can have max 2 sales person for comn and they should be associated with the product. Please suggest whether this understanding is correct or not? If this is co...

error message when sending to large distribution list
I receive the following error consistently on the same mailboxes when I send to the DL. Albany on 10/22/2003 6:20 PM The content length of the message is too long for the recipient to take delivery The MTS-ID of the original message is: c=US;a= ;p=Signature;l=OLMSES04-031022222004Z-11174 MSEXCH:MSExchangeMTA:EXFL01:OLMSES04 Any ideas? ...