Items in Warehouse based on Projects

[Former Member]

Hi Guys,

One of My Real Estate Client Wants to know the Status of Items at each stages for different projects.(Some thing similar to inventory in warehouse report).

Actually we have created a Project and a Project Warehouse(Same as project name) and another 5 Warehouses(5 Stages - S1.S2,S3,S4,S5) commong for all projects,like wise there will be 10-15 projects and 15 Project WareHouses.

When ever they Finished a Stage they will move the items from one stage to other through inventory transfer.

Now they want a report to know status of each item , at which stage it is and for which project.

I tried inventory in warehouse report but each time they have to select the Project warehouse and 5 Stage Warehouses .

So i need a report like , they will input the project and it has to display all the items related to that project, and it has to show only the Relevant project Warehouse Selected and 5 Common Stage Warehouses, and in item master data i have created a udf to capture the project for item (U_PrjCode).

Somebody Provide me a query or help me in this............

Regards,

Vamsi

[Former Member]

Hi Vamsi........

You should have to create User Defined Report for your solution......

Regards,

Rahul

[Former Member]

Hi,

Please response for your old threads. When you just ask for help but not respect others' work, I doubt you can get help easily.

Thanks,

Gordon