Skip to main content
Solved

Calculate Replenishment Parameters failed with error

  • February 7, 2024
  • 9 replies
  • 208 views
  • Translate All

Forum|alt.badge.img

We are setting up and testing the “Calculate Replenishment Parameters” for certain items.  Not sure if we have missed some setting(s) in the Replenishment tab as the “Calculate Replenishment Parameters” process failed with a  message “IN Error:  InternalError: Sequence’s sorting order is wrong or it’s not sorted”.

Any suggestions would be really appreciated as this is our first time setup and try the Calculate Replenishment Parameters.  Please find attached the settings on the Replenishment Tab in one of the item, and also the Calculate Replenishment Parameters errors when we run the process.  Thanks...

Best answer by jwaldron46

Acumatica Support was able to find our specific issue.  For the two items that received this error, the “Periods to Analyze” were set to Zero instead of our standard periods we use.  Worked fine when I corrected the items.

View original

9 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+18

HI @dngu 

Can you pull the trace error and see what that is saying?

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • February 7, 2024

Hi @Kandy Beatty

I have attached the file ie. “Calculate Replenishment Parameters error” in my original message.  It’s the trace errors on some of the items that I exported from the error message.

 

Translate

Forum|alt.badge.img+1
  • Semi-Pro III
  • February 15, 2024

Any news on this?
I encountered this for the first time today too.
Here is part of the trace:
 

 

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • February 15, 2024

Hi @krausef77  There is no further update on this topic yet.  We are still searching an answer.  Thanks...

Translate

jwaldron46
Freshman II
Forum|alt.badge.img+1

We ran into this today also.  Following this thread now...

Translate

jdobish
Captain II
Forum|alt.badge.img+2
  • Captain II
  • June 4, 2024

We had a client run into an issue where they were unable to process because there was an invalid Date/Time parameter. It seemed to have happened related to an upgrade, but I can’t figure out why that would have mattered. 

Translate

jwaldron46
Freshman II
Forum|alt.badge.img+1
  • Freshman II
  • Answer
  • June 4, 2024

Acumatica Support was able to find our specific issue.  For the two items that received this error, the “Periods to Analyze” were set to Zero instead of our standard periods we use.  Worked fine when I corrected the items.

Translate

Hi all, to confirm what @jwaldron46 found, in testing I found the same. So against the replenishment class on the item (last column by default) must have non zero value to calculate (makes sense!).

Translate

jdobish
Captain II
Forum|alt.badge.img+2
  • Captain II
  • July 1, 2024

Acumatica also identified that if there is a leap year, the calendar may also break. 

Translate