1. Home
  2. Point-Of-Sale Software
  3. Item report: Price <> PriceC

Item report: Price <> PriceC

Hello,

Is there a possibility to generate an report / filter to see the items where the Price is not equal to PriceC?

This is for an report and printing labels of items which are updated through import.

Hope somebody can help me?

Reply to
Raymond Bakker
Loading thread data ...

Hi Raymond,

You can do it your self, very easy... Edit one of the Standard reportes (using Notepad, for example), I recomend, on what you are searching for, You edit the "Items - Item Price List" and add a new column, something like this:

Begin Column FieldName = "" DrillDownFieldName = "" DrillDownReportName = "" Title = "Difference" VBDataType = vbString Formula = "CASE WHEN Price PriceC Then 'True' Else 'False' End" ColHidden = True ColNotDisplayable = True FilterDisabled = False ColWidth = 1000 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Save the Report. With this, now at opening the report, You will get a new filter "Difference" which You can use, by putting the text True or False, which will filter the Items who do have the Price PriceC or not... If You don't use this filter, the report will work exactly the same, like before editiing it...

If you have problems, contact me on my mail antonijo snipped-for-privacy@hotmail.com ... and wote me!!!

Regards, A.

Reply to
Antonijo Todoro

Hi Antonijo,

Thank you for your answer! this is very usefull. Do you also know if it's also possible to use this filter in the label wizard??

Reply to
Raymond Bakker

Hi Raymond, Antonijo - Antonijo's solution is very elegant, my first inclination would be to run a SQL query but Antonijo's report syntax is very nice and a more user-friendly (as most RMS users are probably not familiar with running queries)

Anyway - the report syntax that Antonijo sent you only applies to a report. The label wizard allows you to select items based on a filter, and on that filter you could filter by subdescriptions 1, 2, or 3. If you are NOT using subdescriptions 1, 2, or 3, you could run an "update item" that flags in SD1, SD2 or SD3 those items where price does not match price C. For example, flag SD3 with "Price PriceC", so that you can then filter by this variable in the label wizard.

First backup your database and run this after hours if possible Your update query is: UPDATE ITEM SET SUBDESCRIPTION3 = 'pricepricec' WHERE PRICE PRICEC

Then in the label wizard filter for subdescription 3 = pricepricec - it should work.

H> Hi Antonijo,

Reply to
convoluted

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.