Query Report For a Forecast

[Former Member]

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

[jitin_chawla · Accepted solution]

Hi,

Have you started with query regarding the data which you want. if yes, you can post here and members can check the same and help you out with.

If you have not started then you can check following tables :

OFCT, FCT1, OITM, ITM1, OMSN, MSN2, OITT, ITT1

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Saman......

Whay you want query report?

If you run MRP for such Items System will give you the recommendations as per the criteria like should not consider present stock, purchase order,sales orders.

Try to run the MRP wizard once.......

Regards,

Rahul