on 05-20-2011 9:59 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Kindly revert back if there is any query or close the thread if your issue is solved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.