Report to show items with sale value ticked

Posted by Philip Gass on February 10, 2007, 7:25 am

Please log in for more thread options

I have noticed strange things happening with Items on sale, I know it sounds
crazy but there seem to be items on sale which nobody put on sale, im
extremely nervous we will erode profits if we dont keep an eye on items
which shouldnt be on sale.

Is there a report which simply shows things which have the sale tick
applied? I know i can filter by dates, but if i dont know the dates it
seems tricky.

I also could do with a wizard which did something like making sure there
were no items from s certain department catagory or supplier on sale, i
suppose i could use sql to do this?

thanks

Posted by Jeff @ Check Point Software on February 21, 2007, 3:44 am

Please log in for more thread options

: quoted-printable

Philip,

First make sure that you are not running version 1.3.1002 on any =
machine. SO Manager | Help | About

Attached is a report showing Items currently On Sale. Delete the date =
filter to see _all_ that have the On Sale flag set.

--=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

I have noticed strange things happening with Items on sale, I know it =
sounds=20
crazy but there seem to be items on sale which nobody put on sale, im=20
extremely nervous we will erode profits if we dont keep an eye on =
items=20
which shouldnt be on sale.

Is there a report which simply shows things which have the sale tick=20
applied? I know i can filter by dates, but if i dont know the dates =
it=20
seems tricky.

I also could do with a wizard which did something like making sure =
there=20
were no items from s certain department catagory or supplier on sale, =
i=20
suppose i could use sql to do this?

thanks=20

------=_NextPart_001_04F6_01C75551.73641800
Content-Type: text/html;
        charset="Windows-1252"
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=3Dwindows-1252">
<META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Philip,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>First make sure that you are not running =
version=20
1.3.1002 on any machine.  SO Manager | Help | About</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Attached is a report showing Items currently =
On=20
Sale.  Delete the date filter to see _all_ that have the On =
Sale flag=20
set.</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>"Philip Gass" <<A=20
=
>=20
wrote in message <A=20
=
@TK2MSFTNGP06.phx.gbl</A>...</DIV>I=20
have noticed strange things happening with Items on sale, I know it =
sounds=20
<BR>crazy but there seem to be items on sale which nobody put on sale, =
im=20
<BR>extremely nervous we will erode profits if we dont keep an eye on =
items=20
<BR>which shouldnt be on sale.<BR><BR>Is there a report which simply =
shows=20
things which have the sale tick <BR>applied?  I know i can filter =
by=20
dates, but if i dont know the dates it <BR>seems tricky.<BR><BR>I also =
could=20
do with a wizard which did something like making sure there <BR>were =
no items=20
from s certain department catagory or supplier on sale, i <BR>suppose =
i could=20
use sql to do this?<BR><BR>thanks <BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_04F6_01C75551.73641800--

------=_NextPart_000_04F5_01C75551.73641800
Content-Type: application/octet-stream;
        name="Custom - Items - On Sale Price.qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
        filename="Custom - Items - On Sale Price.qrp"

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

Begin ReportSummary
ReportType =3D reporttypeItems
ReportTitle =3D "On Sale Price List - While Supplies Last"
PageOrientation =3D pageorientationLandscape
WordWrap =3D False
ShowDateTimePicker =3D False
OutLineMode =3D True
Groups =3D 0
GroupDescription =3D "Average"
DisplayLogo =3D True
LogoFileName =3D "MyLogo.bmp"
ProcedureCall =3D ""
PreQuery1 =3D ""
PreQuery2 =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.SaleType"
FilterOp =3D reportfilteropBetween
FilterLoLim =3D "1"
FilterHilim =3D "2"
FilterConnector =3D reportfilterbooleanconAND
End Filter

Begin Filter
FieldName =3D "Item.SaleEndDate"
FilterOp =3D reportfilteropBetween
FilterLoLim =3D "<YearStart>"
FilterHilim =3D "<Today>"
FilterConnector =3D reportfilterbooleanconAND
End Filter

//--- Columns ---//

Begin Column
FieldName =3D "Department.Name"
DrillDownFieldName =3D "Department.Name"
DrillDownReportName =3D ""
StoreIDFieldName =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 ""
StoreIDFieldName =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 "Item.ItemLookupCode"
DrillDownFieldName =3D "Item.ItemLookupCode"
DrillDownReportName =3D ""
StoreIDFieldName =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 ""
StoreIDFieldName =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.Quantity"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "On Hand"
VBDataType =3D vbDouble
Formula =3D ""
ColHidden =3D False
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 ""
StoreIDFieldName =3D ""
Title =3D "Commited"
VBDataType =3D vbDouble
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1050
GroupMethod =3D groupmethodNone
ColFormat =3D "#"
End Column

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

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

Begin Column
FieldName =3D "Item.ExtendedDescription"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Ext'd Description"
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 "Supplier.SupplierName"
DrillDownFieldName =3D "Supplier.SupplierName"
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Supplier"
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 ""
StoreIDFieldName =3D ""
Title =3D "Sub Description 1"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
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 ""
StoreIDFieldName =3D ""
Title =3D "Sub Description 2"
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 ""
StoreIDFieldName =3D ""
Title =3D "Sub Description 3"
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 ""
StoreIDFieldName =3D ""
Title =3D "Item Notes"
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.WebItem"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Web Item"
VBDataType =3D vbBoolean
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1050
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
FieldName =3D "Item.BinLocation"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =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.Cost"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Cost"
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.PriceA"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Price A"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1000
GroupMethod =3D groupmethodAverage
ColFormat =3D ""
End Column

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

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

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

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

Begin Column
FieldName =3D "Item.SaleStartDate"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Sale Starts"
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.SaleEndDate"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =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.ReorderPoint"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =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 ""
StoreIDFieldName =3D ""
Title =3D "Restock Level"
VBDataType =3D vbDouble
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1305
GroupMethod =3D groupmethodNone
ColFormat =3D "#"
End Column

Begin Column
FieldName =3D "Item.LastSold"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =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.SaleType"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Sale Type"
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D True
FilterDisabled =3D False
ColWidth =3D 900
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

------=