Skip to Content
0
Former Member
Jun 17, 2009 at 05:23 AM

Goods Issue Query

440 Views

Hello Experts!!!

Can anyone create a query which lookups the following wherein the Goods Issue is the base document:

1. Document No.

2. Item No.

3. Item Type (this is a UDF in the Item Master Data - OITM, UDF Name: U_ItmTyp)

4. Item Class (this is a UDF in the Item Master Data - OITM, UDF Name: U_ItmClass)

5. Item Group

6. Quantity

7. Price

8. Gross Amount (is equal to Quantity * Price)

The Parameters are:

1. Customer (this is a UDF in the Goods Issue Document-OIGE, UDF Name: U_BPCode)

2. Date Range (from and to dates)

Your inputs would be highly appreciated.

Regards,

Jen

Edited by: Jennifer Tinagan on Jun 17, 2009 7:24 AM