Price List + Alias

Posted by Ryan on May 28, 2008, 8:30 pm

Please log in for more thread options

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

Posted by convoluted on May 28, 2008, 8:44 pm

Please log in for more thread options

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 into store ops manager and run the items - price list report - it will
show you your aliases. Hope this helps....

"Ryan" wrote:

> 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

Posted by Ryan on May 28, 2008, 8:53 pm

Please log in for more thread options

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:

> 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