User trying to get the Ascending & Descending sequence of the Receipt Reference number while applyin

Summary:

User trying to get the Ascending & Descending sequence of the Receipt Reference number while applying the transaction to the receipt doesn't work as expected

Example

Users Expecting	System Deriving currently
7654	10166
7678	10900
7979	11800
8010	12500
8220	12800
8990	13100
9019	13500
9450	13900
9999	14100
10166	14800
10900	15000
11800	20000
12500	25000
12800	29000
13100	38000
13500	59000
13900	88000
14100	99999
14800	101000
15000	110000
20000	120000
25000	7654
29000	7678
38000	7979
59000	8010
88000	8220
99999	8990
101000	9019
110000	9450
120000	9999

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

11.13.24.01.0

Code Snippet (add any code snippets that support your topic, if applicable):