cancel
Showing results for 
Search instead for 
Did you mean: 

Warehouse

Former Member
0 Kudos

Hi,

i jus wanted a warehouse status report... we have five warehouse stage 1 ,stage 2, stage 3 , stage 4, stage 5 i need a report in this format...

item code-- item desc-- s1s2s3s4s5

0001 ecr 1 0 0 0 0...

is it possible in crystals... the main problem is we have more than 20 warehouse but we need onlt these s1-s5 warehouse ..

pls help..

regards,

Vignesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI

The format which you specified is available in Standard B1 iteself.

Its located under Inventory->Inventory reports->Inventory in Warehouse report.

So,no need of crystal

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello ,

If you using crystal report then you have made sql query andchange where condition in your query like.

Where wherehousecode in(1,2,3,4,5)

in is a sql keyword which work acoording your requirement.

Thanks

Manvendra Singh Niranjan

Former Member
0 Kudos

Hi Vignesh,

There is an option just using query. You can try Pivot function in SQL to achieve the result. Search the forum to find out more.

Thanks,

Gordon

Former Member
0 Kudos

HI

Kindly revert back if there is any query or close the thread if your issue is solved

Former Member
0 Kudos

Inventory -> Inventory Reports -> Inventory in Warehouse Report->

Give all info like item code range, item group, display normal

Then in By Warehoouse Folder you give Including WH and Excluding WH codes.