I am more developer than functional consultant. Maybe there is a way in standard AX 2009 that I may not be aware of.
However, I did make a small customization once -- you can create a small software task to modify the "safety stock" levels to match sales forecast before running master planning. Provided that the "expected" receipts are actually on POs, that should create a planned order for the correct amount. You can manually try using the safety stock menu item to try this out manually - where you enter the sales forecast value and see if meets your need. Then do the development to cause the same to happen. On Fri, Feb 20, 2009 at 5:29 AM, 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 > > > ------------------------------------ News-Flash of Axapta Knowledge Village ======================================= VISIT THE Microsoft Dynamics AX Knowledge Village at LINKEDIN: http://www.linkedin.com/e/gis/165338. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/join (Yahoo! ID required) <*> To change settings via email: mailto:axapta-knowledge-village-dig...@yahoogroups.com mailto:axapta-knowledge-village-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: axapta-knowledge-village-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/