Skip to main content
Solved

MRP Forecast Calcuation

F
Jr Varsity III
Forum|alt.badge.img

I am testing automatic forecast generation for a client that has been live for a year. I am testing in 2022 R1.

We previously uploaded manual forecasts since the client did not have any actual sales data to generate forecasts automatically. The forecast calculation is simple...10% growth per month. I am able to calculate the forecast however when I process the data, the forecast listing shows the items with an interval of One Time and they appear to be in addition to the old forecasts. The previous forecasts were entered with the interval Monthly. My questions are as follows:

  1. Is it possible to process the generated forecast with the interval of monthly and automatically update previously entered forecasts?
  1. What is the implication of one time vs monthly?
  1. There does not seem to be a way to easily mass delete old forecasts. I have thousands of lines as there are different forecasts by item by month and deleting one by one is not realistic.

Best answer by bthomas24

Hi @Kandy Beatty ,

 

I do not think it is possible to delete forecasts using an import scenario. Have you had success doing that?

UPDATE: it is possible, using the <Line Number> and =-2 value.

Thank you,

Ben Thomas

View original
Did this topic help you find an answer to your question?

7 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Kandy Beatty
  • Captain II
  • 2209 replies
  • August 11, 2022

HI @frankfiorentino81 

  1. You can generate forecasts monthly. It should be automatically updating previous forecasts. 
  2. There is no implication of one time vs. monthly. Can you elaborate on that?
  3. You could create an import scenario to delete the old forecasts. 

Here in the Help is a good place to start on forecasting:

https://help-2022r1.acumatica.com/(W(6))/Help?ScreenId=ShowWiki&pageid=05cb7223-9adf-4b4f-9230-09339c960eb2

 

Also, if you have a test environment, you could test there before doing any changes to your production environment. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
AndreasKleinfeld72
2 people like this
  • Chris Hackett
    Chris Hackett
  • AndreasKleinfeld72
    AndreasKleinfeld72
F
Jr Varsity III
Forum|alt.badge.img

Thanks for the reply. I did a test to see if forecasts would be updated. Here are the steps I took:

  1. I generated a new forecast for a single part number, by month for the next year.
  2. I went to the forecast listing and filtered on the same part number and changed the interval to One Time.
  3. I processed the forecast on the Generate Forecasts screen but instead of the forecast being updated, new lines were added so now I have two active forecasts for the same item.
  4. I wanted to see if there was an issue with the imported forecasts so I re-generated a new forecast for the same item using a different growth rate and upon processing the forecast, a 3rd forecast was added for the same item.

I have read the help articles and they are fairly light on this topic. I cannot see any reason why the forecast is not updating older forecasts. It feels like the ability to autogenerate and update forecasts is not working. What am I missing?

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Kandy Beatty
  • Captain II
  • 2209 replies
  • August 12, 2022

Hi @frankfiorentino81 

I looked as well for you and the Help doesn’t mention the updating of Forecasts nor could I find the logic to it. 

There are a few training recordings on the Open University that may help. 

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
F
Jr Varsity III
Forum|alt.badge.img

@kbeatty21 Thanks for the help.

Kandy Beatty
1 person likes this
  • Kandy Beatty
    Kandy Beatty
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2783 replies
  • October 31, 2022

Hi @frankfiorentino81 - were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
B
Jr Varsity II
Forum|alt.badge.img
  • bthomas24
  • Jr Varsity II
  • 34 replies
  • Answer
  • June 11, 2024

Hi @Kandy Beatty ,

 

I do not think it is possible to delete forecasts using an import scenario. Have you had success doing that?

UPDATE: it is possible, using the <Line Number> and =-2 value.

Thank you,

Ben Thomas

Kandy Beatty
Chris Hackett
AndreasKleinfeld72
3 people like this
  • Kandy Beatty
    Kandy Beatty
  • Chris Hackett
    Chris Hackett
  • AndreasKleinfeld72
    AndreasKleinfeld72
Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Kandy Beatty
  • Captain II
  • 2209 replies
  • June 11, 2024
bthomas24 wrote:

Hi @Kandy Beatty ,

 

I do not think it is possible to delete forecasts using an import scenario. Have you had success doing that?

UPDATE: it is possible, using the <Line Number> and =-2 value.

Thank you,

Ben Thomas

Thanks for the update on this! @bthomas24 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved