My company is wanting to use Acumatica for forecasting. I have read several topics that I can find on this subject but haven’t found anything helpful yet. We are wanting to be able to put in a yearly forecast for each month. Some months will not be the same as others; example Jan. -25, Feb - 30, March =100 and so on. Is Acumatica able to do this kind of forecasting? I am new to Acumatica and have only usesd APO in the past.. I can only find where you enter 1 qty for the part code and it doesn’t appear to be taking what is in WIP or safety stock into consideration.
Solved
Using Forecasts in Acumatica
Best answer by Debbie Baldwin
+2
Debbie Baldwin
Acumatica supports forecasts via the Forecast (AM202000) form. You can either enter forecasts manually or generate them by by using the Generate Forecast (AM502000) form
Forecasts may depend on the sales orders created in the system; that is, the quantity of items in the sales orders will reduce the forecast quantity. For dependent forecasts, you select the check box in the Dependent column on the Forecast form. For example, suppose that the forecast is an item quantity of 200 for September 1 to September 30, and sales orders with promise dates between September 1 and September 30 have a total open quantity of 150. Then the remaining forecast of 50 is used by MRP.
Does the forecast need to be entered monthly or can it be entered for the entire year depending on the month?
+4Hi mdoerr!
To calculate for an entire year by intervals, users can use the Calculate By Month checkbox on the Generate Forecasts screen.
Currently, the only intervals available are monthly. Additional testing might be needed to see if users can define an interval in something other than a month - like 25, 100, etc.
Tested locally :
- Selected calculate by month
- Save and calculate
- It listed calculated numbers for each month ( multiple lines / per month for same item and warehouse combination )
- Selected the calculated lines and processed ( need to select all lines )
- Forecast was generated for each month for same item and warehouse combination
I hope this helps!
Hannah
Hannah Barnes
I see where i can enter multiple dates for forecast in the Forecast Form. I am needing to enter forecasts and safety stocks for our finished goods products. Then when I go into Release production orders, there isn’t any there for the test code that I am using. I have entered 50pcs for forecast, 50pcs for safety stock. I only have 9 pcs in WIP and I don’t have any sales orders for this part code that isn’t in completed status.
Yes, I did run MRP to get the planned orders. My forecast is 50pcs and my safety stock is 25pcs. I can get it to plan for safety stock or forecast but I cannot get it to consider both. Example - i have 9pcs on hand and either I get 41pcs to forecast or 16pcs to forecast. I am expecting a planned order for 66 pcs
+2Debbie Baldwin
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.