1. Home
  2. Point-Of-Sale Software
  3. Price List + Alias

Price List + Alias

Dear all,

I have an upcoming catalogue/sale coming up and what would be incredible useful to have would be a report, such as the price list report, with the addtion of the barcodes.

This would allow us to see what item lookup codes have a barcode (so would then need to be flagged to have them added as they come from the warehouse) and which stock could be put straight out.

We did try the alias report but if there is no barcode for the product of course it will not appear on the report. We use sub description 1 as a filter to populate the report, example - LB208.

Any help would be greatly appreciated.

Ryan Casey's Toyworld

Reply to
Ryan
Loading thread data ...

Hi Ryan - if you know how to edit reports, edit the price list report the following way First right click on the report name and uncheck "read only" - then open it with notepad.

First edit the tables queried section and join the alias table, so it reads.... LEFT JOIN Tax WITH(NOLOCK) ON Item.TaxID = Tax.ID LEFT JOIN Alias on Item.ID = Alias.ItemID"

Then add the alias column to the report Begin Column FieldName = "Alias.Alias" DrillDownFieldName = "" DrillDownReportName = "" Title = "Alias" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1800 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Go > Dear all,

Reply to
convoluted

Convoluted... I can not tell you how much this has helped us!!! Seriousily, this is now going to make our lives so much easier.

Many thanks for your very quick reply and support of this newsgroup (among the many ohters of course)

Sinerely,

Ryan Casey's Toyworld

"Ryan" wrote:

Reply to
Ryan

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.