Does anyone have a report that will show me all products that are on sale? I would like one that would shows me items on sale, when the sale expires, gross markup for the sale, and # of sold on sale. If anyone could write that for me I would be willing to pay I'm not schooled enough to do it. If not I would settle for one that just shows me active sale items.
You can get most of this information except for # of sold on sale by filtering the Item Value List Report for Sale Start Date is less than or equal to today period and the Sale End Date is equal or greater than today.
You can get all that information on the detailed sales report and filter by sale start date. All the fields you mention and more are there, they are just hidden. You can pick which fields you want to show, and then memorize it for future use. Craig
Does anyone have a report on know how to run on that would show all items that have "This item is on sale" check mark set ?
The detailed and item value report will show items that have a date in sale ends field , but that are not "actively on sale"
Thanks Robert
"Jeff @ Check Po> Crossover,
the flag is in the item table called saletype
select descripti> Does anyone have a report on know how to run on that would show all items
hello
THANKS FOR THE REPLY I'm not good at report writing
I tried inserting this into one of my report but didn't work.
Do you have a working report with report that info ? Can you post or email it to me ? snipped-for-privacy@usa.com Thank you very Much
"Matt Hurst" wrote:
Here is the Item - Master Quantity List report with that column at the end:
//--- Report Summary --- //
Begin ReportSummary ReportType = reporttypeItems ReportTitle = "Item on Sale" PageOrientation = pageorientationLandscape WordWrap = False ShowDateTimePicker = False OutLineMode = True Groups = 1 GroupDescription = "Average" DisplayLogo = True LogoFileName = "MyLogo.bmp" ProcedureCall = "" PreQuery1 = "" PreQuery2 = "" TablesQueried = "FROM Item WITH(NOLOCK) LEFT JOIN Department WITH(NOLOCK) ON Item.DepartmentID = Department.ID
LEFT JOIN Category WITH(NOLOCK) ON Item.CategoryID = Category.ID LEFT JOIN Supplier WITH(NOLOCK) ON
Item.SupplierID = Supplier.ID LEFT JOIN ItemClassComponent ON Item.ID ItemClassComponent.ItemID LEFT JOIN
ItemClass ON ItemClassComponent.ItemClassID = ItemClass.ID" SelCriteria = "" GroupBy = "" SortOrder = "" End ReportSummary
//--- Title Rows ---//
Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 16 Color = "Blue" End TitleRow
Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 12 Color = "Black" End TitleRow
Begin TitleRow Text = "Generated On " Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow
//--- Filters ---//
Begin Filter FieldName = "Item.saletype" FilterOp = reportfilteropEqual FilterLoLim = "1" FilterHilim = "1" FilterNegated = False FilterConnector = reportfilterbooleanconAND End Filter
Begin Filter FieldName = "Item.SaleStartDate" FilterOp = reportfilteropBetween FilterLoLim = "1/1/1918" FilterHilim FilterNegated = False FilterConnector = reportfilterbooleanconAND End Filter
Begin Filter FieldName = "Item.SaleEndDate" FilterOp = reportfilteropBetween FilterLoLim FilterHilim = "1/1/2088" FilterNegated = False FilterConnector = reportfilterbooleanconAND End Filter
//--- Columns ---//
Begin Column FieldName = "Department.Name" DrillDownFieldName = "Department.Name" DrillDownReportName = "" StoreIDFieldName = "" Title = "Department" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2205 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "Category.Name" DrillDownFieldName = "Category.Name" DrillDownReportName = "" StoreIDFieldName = "" Title = "Category" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1065 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "Supplier.SupplierName" DrillDownFieldName = "Supplier.SupplierName" DrillDownReportName = "" StoreIDFieldName = "" Title = "Supplier" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 825 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "ItemClass.ItemLookupCode" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Class Lookup Code" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1665 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "Item.ItemLookupCode" DrillDownFieldName = "Item.ItemLookupCode" DrillDownReportName = "" StoreIDFieldName = "" Title = "Item Lookup Code" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1665 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Begin Column FieldName = "Item.Description" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Description" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1860 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.BinLocation" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Bin Location" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1140 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.Quantity" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Qty" VBDataType = vbDouble Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 405 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.QuantityCommitted" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Qty Comm." VBDataType = vbDouble Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1050 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.Cost" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Cost" VBDataType = vbCurrency Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 525 GroupMethod = groupmethodAverage ColFormat = "" End Column
Begin Column FieldName = "Item.Price" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Price" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 765 GroupMethod = groupmethodAverage ColFormat = "" End Column
Begin Column FieldName = "Item.PriceA" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Price A" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 735 GroupMethod = groupmethodAverage ColFormat = "" End Column
Begin Column FieldName = "Item.PriceB" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Price B" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 690 GroupMethod = groupmethodAverage ColFormat = "" End Column
Begin Column FieldName = "Item.PriceC" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Price C" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 735 GroupMethod = groupmethodAverage ColFormat = "" End Column
Begin Column FieldName = "Item.PriceLowerBound" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Lo Bound" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 915 GroupMethod = groupmethodAverage ColFormat = "" End Column
Begin Column FieldName = "Item.PriceUpperBound" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Hi Bound" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 855 GroupMethod = groupmethodAverage ColFormat = "" End Column
Begin Column FieldName = "Item.SalePrice" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sale Price" VBDataType = vbCurrency Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 945 GroupMethod = groupmethodAverage ColFormat = "" End Column
Begin Column FieldName = "Item.SaleStartDate" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sale Starts" VBDataType = vbDate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1020 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.SaleEndDate" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sale Ends" VBDataType = vbDate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 885 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.MSRP" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "MSRP" VBDataType = vbCurrency Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 945 GroupMethod = groupmethodAverage ColFormat = "" End Column
Begin Column FieldName = "Item.ReorderPoint" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Reorder Pt." VBDataType = vbDouble Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1065 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.RestockLevel" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Restock Level" VBDataType = vbDouble Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1305 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.LastSold" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Last Sold" VBDataType = vbDate Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 900 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "Item.Inactive" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Inactive" VBDataType = vbBoolean Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1050 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignCenterCenter End Column
Begin Column FieldName = "Item.SaleType" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "OnSale" VBDataType = vbBoolean Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1050 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignCenterCenter End Column
"Robert" wrote:
Thanks for the reply For the life of me i can n ot get this to work , I tried to copy it into new report, and edit existing but i keep getting errors. Can you email this to me Can you zip if first i had problems getting a report as a direct qrp file before
snipped-for-privacy@usa.com Thank you very Much
"Matt Hurst" wrote:
Hello
Does anyone know how to get this report working ? when i copy this to a new report i keep getting errors
Thanks
"Robert" wrote:
Hello
Thank you so much for this report. This is exactly what i was looking for .
I finding a lot of items that show active on sale but have expired dates , and this gives me a better idea of items actively on sale.
I don't know how this could of ended up in my spam folder.
Any idea why this didn't work when i coped the text into a new report ?
I believe it might have to do with text/ line wrapping .
I will try to compare them tonight
Do you have any other reports or anything that could be helpful in liquor sine shop.??
As far as the support , its sad but i have to say that my reseller is not able to provide any support, they should not even be allowed to sell this product. I believe now i know more about it than they do bout rms ( i have been using it for about 2 years now)
Again thank you for you help
Robert
"Matt Hurst" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.