I work for a wholesale seed company where we buy and sell raw and finished goods. We would like to start forecasting these products based on sales and usage. The raw goods are also used in manufacturing finished goods and we would like to forecast down to the bottom level of raw goods which could be up to 3 or more levels. We would like to include in the forecast any open sales orders, remaining quantity on blanket sales orders, open purchase orders and remaining quantity on blanket purchase orders, inventory on hand and last 3 years' sales. Since we have several locations, we would also like to see the forecast by location. The projected sales forecast can change frequently and we would like to forecast by the month up to 12 months and in some cases, up to 3 years. If possible, we would also like to create PO's, Transfer Orders and Assembly Orders based on the sales forecast. We were using Lanham's AFP but we were unable to forecast down to the BOM level. Would the MRP in NAV be sufficient for what we need or are there ISV's available that would work better for us? We just recently upgraded to NAV 2016.
The steps you described are available in the standard NAV package. Then Smart add-on for Dynamics https://smartcorp.com/dynamics-ax-and-nav/expands NAV's functionalities by creating Forecasts that boost productivity & efficiency.
If you've found this thread useful, dive deeper into User Group community content by role