Skip to Content
author's profile photo Former Member
Former Member

Items in Warehouse based on Projects

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 28, 2011 at 05:59 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2011 at 05:27 AM

    Hi Vamsi........

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

    Regards,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.