1. Home
  2. Point-Of-Sale Software
  3. Easy way to get list of blocked from sale items

Easy way to get list of blocked from sale items

Hi, I was looking for a way to generate a list of all items in the store with the block sale check box active. If there is a way to get this inside RMS or through a SQL query that would be great.

Thanks, Skyler

Reply to
Skyler Lister Aley
Loading thread data ...

Hi Skyler - try

SELECT * FROM ITEM WHERE BLOCKSALESTYPE = 1;

H> Hi, I was looking for a way to generate a list of all items in the store with

Reply to
convoluted

hi I just add with the convoluated. is that in most reports where you have sales. you need to add the following code to accomplished (open the .grp file i.e. Sales - Detailed Sales Report.qrp) Add the following lines any where in your report and save the report.

Begin Column FieldName = "Item.BLOCKSALESTYPE" DrillDownFieldName = "" DrillDownReportName = "" Title = "Block Sales" VBDataType = vbBoolean Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1057 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignCenterCenter End Column

Run the Sales Detailed report and select Block Sales column click Yes /No per your requirement and add as criteria for the report. it will works.

"Skyler Lister Aley" wrote:

Reply to
Akber Alwani

Thanks! We will try both solutions

-Skyler

"Akber Alwani" wrote:

Reply to
Skyler Lister A

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.