Top Selling Items report, by Departmentt

Posted by Ryan V on January 3, 2007, 10:23 pm

Please log in for more thread options

Is there a report out there, somewhere, that will show me the top (say, top
50, or top 100) moving items per department? I am setting up a distribution
company and would like to have a list of our top selling items so I can
negotiate directly with those manufacturers. Unfortunately, the top selling
items list doesn't break things down by department and is cluttered with
cheap items that we sell loads of (crickets, mice, rock, etc.).

Posted by Mickie on January 4, 2007, 6:52 pm

Please log in for more thread options

Ryan,

Do you have the "Detailed Sales Report" option in:

Reports|Sales|Detailed Sales

that one has date selection, and groups by Department with Total sales.
You can also see the individual items listed in each Department.

If you don't have it, I can post it.

Ryan V wrote:

> Is there a report out there, somewhere, that will show me the top (say, top

> 50, or top 100) moving items per department? I am setting up a distribution

> company and would like to have a list of our top selling items so I can

> negotiate directly with those manufacturers. Unfortunately, the top selling

> items list doesn't break things down by department and is cluttered with

> cheap items that we sell loads of (crickets, mice, rock, etc.).

Posted by Jeff @ Check Point Software on January 4, 2007, 10:13 pm

Please log in for more thread options

: quoted-printable

Ryan,

See if the attached report works for you.

--=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 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 out there, somewhere, that will show me the top =
(say, top=20
50, or top 100) moving items per department? I am setting up a =
distribution=20
company and would like to have a list of our top selling items so I =
can=20
negotiate directly with those manufacturers. Unfortunately, the top =
selling=20
items list doesn't break things down by department and is cluttered =
with=20
cheap items that we sell loads of (crickets, mice, rock, etc.).
------=_NextPart_001_080B_01C73034.7CDE8920
Content-Type: text/html;
        charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Ryan,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>See if the attached report works for =
you.</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 or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment(s).  If you are not =
using a=20
reader, follow<BR>the link below to setup Outlook Express.  Click =
on "Open=20
with newsreader"<BR>under the MS Retail Management System on the =
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>"Ryan V" <Ryan <A=20
=
A>>=20
wrote in message <A=20
=
7AD34-6039-4712-9010-A84FB05091C7@microsoft.com</A>...</DIV>Is=20
there a report out there, somewhere, that will show me the top (say, =
top=20
<BR>50, or top 100) moving items per department? I am setting up a=20
distribution <BR>company and would like to have a list of our top =
selling=20
items so I can <BR>negotiate directly with those manufacturers. =
Unfortunately,=20
the top selling <BR>items list doesn't break things down by department =
and is=20
cluttered with <BR>cheap items that we sell loads of (crickets, mice, =
rock,=20
etc.).</BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_080B_01C73034.7CDE8920--

------=_NextPart_000_080A_01C73034.7CDE8920
Content-Type: application/octet-stream;
        name="Custom - Items - Top.qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
        filename="Custom - Items - Top.qrp"

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

Begin ReportSummary
ReportType =3D reporttypeSales
ReportTitle =3D "Top Items Report"
PageOrientation =3D pageorientationLandscape
OutLineMode =3D True
Groups =3D 1
GroupDescription =3D ""
DisplayLogo =3D True
LogoFileName =3D "MyLogo.bmp"
ProcedureCall =3D ""
TablesQueried =3D <BEGIN>
        FROM TransactionEntry WITH(NOLOCK) INNER JOIN [Transaction] =
WITH(NOLOCK) ON TransactionEntry.TransactionNumber =3D =
[Transaction].TransactionNumber=20
        LEFT JOIN Item WITH (NOLOCK) On TransactionEntry.ItemID =3D Item.ID
        LEFT JOIN Department WITH(NOLOCK) ON Item.DepartmentID =3D =
Department.ID=20
        LEFT JOIN Category WITH(NOLOCK) ON Item.CategoryID =3D Category.ID=20
        <END>
SelCriteria =3D ""
GroupBy =3D "Department.Name,Category.Name,Item.ItemLookupCode"
SortOrder =3D "Sales DESC"
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 "[Transaction].Time"
FilterOp =3D reportfilteropBetween
FilterLoLim =3D "<YearStart>"
FilterHilim =3D "<Today>"
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 "ItemLookupCode"
DrillDownFieldName =3D "Item.ItemLookupCode"
DrillDownReportName =3D ""
Title =3D "ILC"
VBDataType =3D vbString
Formula =3D "MAX(Item.ItemLookupCode)"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1200
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

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

Begin Column
FieldName =3D "[Transaction].Time"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Date Sold"
VBDataType =3D vbDate
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D True
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "QtySold"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Qty Sold"
VBDataType =3D vbDouble
Formula =3D "SUM(TransactionEntry.Quantity)"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodSum
ColFormat =3D "####"
End Column

Begin Column
FieldName =3D "Sales"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Sales"
VBDataType =3D vbCurrency
Formula =3D "SUM(TransactionEntry.Price * TransactionEntry.Quantity)"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1800
GroupMethod =3D groupmethodSum
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "Profit"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Profit"
VBDataType =3D vbCurrency
Formula =3D "SUM((TransactionEntry.Price - TransactionEntry.Cost) * =
TransactionEntry.Quantity)"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1800
GroupMethod =3D groupmethodSum
ColFormat =3D ""
End Column

------=

Posted by Jen Losch on January 25, 2007, 11:16 am

Please log in for more thread options

Hi Ryan,

Retail Analytics from Professional Advantage is designed to help retailers
manage their business by delivering analytical reporting on business
performance. Easily identify trends, buying patterns, seasonality, and other
key performance indicators for your business.

RA will enable you to easily create the report you are looking for. We
offer demonstrations on RMS Client's live data at no cost. If this is
something you would be interested in or if you have any questions, please
feel free to contact me.

Thanks,

Jen
jenl@profad.com

"Ryan V" wrote:

> Is there a report out there, somewhere, that will show me the top (say, top

> 50, or top 100) moving items per department? I am setting up a distribution

> company and would like to have a list of our top selling items so I can

> negotiate directly with those manufacturers. Unfortunately, the top selling

> items list doesn't break things down by department and is cluttered with

> cheap items that we sell loads of (crickets, mice, rock, etc.).