Skip to Content
0
Former Member
Aug 08, 2011 at 06:35 AM

Query Report For a Forecast

344 Views

Hi Members,

I want a Query report showing items Consumption From A to Z for a proposed Forecast, that mean when i plane Finish items like this in MRP forecast, for a one month

Item - Qty For September

A - 20

B - 10

A,B are Finish items which having BOM,

BOM are contains several components items

i want a report giving details of item wise total

requirement for the above forecast,in this case we should not consider present stock, purchase order,sales orders. so please help me to do it.

tell me how can i do it with a query .

thank you,

saman

Edited by: saman_wm on Aug 8, 2011 8:36 AM