Item with no cost report

[Former Member]

Dear all

I m working on two reports

1.) List any item that does not have an item cost in any warehouse

2.)List any item that has different costs in different warehouses

any one who can help me out with this reports

thank you

[Former Member · Accepted solution]

Hi,

Try:

Select T0.ItemCode, T0.WhsCode, T0.Onhand, T0.AvgPrice, T0.CreateDate, T0.UpdateDate from oitw T0 where t0.onhand > 0 and T0.avgprice != (SELECT Avg(avgprice) FROM OITW WHERE ItemCode=T0.ItemCode)

Thanks,

Gordon

[Former Member · Accepted solution]

thank you fro reply

2.)  can you please let me know about second report

[Former Member · Accepted solution]

This is the 2nd report. Your query looks fine for the 1st. The rule here is one question per thread. Please follow the rule.

[Former Member · Accepted solution]

Hi thank you

you are the master

If u look my screen shot i need this http://screencast.com/t/Vss7Bvcr4W

I doesn't want this in my query t0.onhand > 0

and it has to show the the differences

[Former Member · Accepted solution]

Take out t0.onhand > 0 and try.

[Former Member]

Hi

For 1.) I had found this report Select * from oitw where avgprice = 0 and onhand > 0

is it good??

For2.) Still working

I want these reports periodic basis