cancel
Showing results for 
Search instead for 
Did you mean: 

Item with no cost report

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

thank you fro reply

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

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

Take out t0.onhand > 0 and try.

Answers (1)

Answers (1)

Former Member
0 Kudos

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