Hi, how do u enter Expected receipt for a month in which the plan is running and following 2 month =500
in the system, coz if u want this to be captured, you will have to tell the system about it. Let me know that and then I can guide you further On Fri, Feb 20, 2009 at 5:59 PM, ghoshsubhajit <ghoshsubha...@yahoo.co.in>wrote: > Dear All > > I am facing problem in following area : > > The client has multiple warehouse across among which there are 3 main > warehouse.These warehouses refill the other warehouses through transfer > order. > All the warehouse maintains individual item sales forecast on a monthly > basis. > > The monthly purchase planning is done using the following formula > > *Order to be placed for Current Month= Opening stock for the month > +Expected receipt of this month and following two month in the warehouse – > Foretasted Sales of this month and following two month. * > > I am trying to generate a planned purchase order for a specific item on a > particular site and warehouse on certain given parameter as below. > > I have set up Coverage group (which is attached to the item) with the > following parameter:- > > *Coverage code= "Requirement" > Coverage Time Fence and Period =90 Days > Forecast Plan Time Fence = 90 Days > Future and Action Time Fence =90 Days > Negetive and Positive Days =0 Days* > > In the individual item coverage apart from all the above parameter the min > and max level given as 0 and the Purchase Lead time is 60 Days for the main > warehouse and the transfer lead time is 15 days for the child warehouse. > On the basis of the above parameter when I am running the master schedule > and forecast schedule the system is generating requirement on the above > parameter which is proper. > > But how can I create a planned purchase order on the basis of the formula > given above. > > Example:- > For a particular item in a site and warehouse > > Opening Stock=1000 > Expected receipt for a month in which the plan is running and following 2 > month =500 > Foretasted Sales for a month in which the plan is running and following two > month=2000 > > Planned order to be created for Current Month= (1000+500)- 2000= 500 > > > Please suggest me how to do it. > > Regards > > Subhajit Ghosh > > > > -- With Regards, Mr. Vishtaspa Sethna Associate E.R.P. Consultant Godrej Infotech Ltd. Cell: +919718010823