# AX2009 : Number Sequence List shows Active and Used number of Posted transactions!

**URL:** <https://www.dynamicsuser.net/t/ax2009-number-sequence-list-shows-active-and-used-number-of-posted-transactions/50322>\
**Category:** User Forum\
**Created:** [January 16, 2014, 9:17am UTC](https://www.dynamicsuser.net/t/ax2009-number-sequence-list-shows-active-and-used-number-of-posted-transactions/50322 "2014-01-16T09:17:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anvilx](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@Anvilx](https://www.dynamicsuser.net/u/Anvilx)\
**Post date:** [January 16, 2014, 9:17am UTC](https://www.dynamicsuser.net/t/ax2009-number-sequence-list-shows-active-and-used-number-of-posted-transactions/50322/1 "2014-01-16T09:17:40Z")

</div>

Hi All,

One of my customers feedback is that the Number sequence List for Journal is always piling up with Active and Used numbers of posted transactions, some dating up to a year ago.

Yes, we can do a number sequence cleanup and solve the problem,

But why do Active and Used numbers go back to the list ? Is there anyway to prevent this or is it an AX 2009 limitation ?

Thanks

.Adrian

---

<div class="post-metadata">

**Author:** ![ingalesd](https://avatars.discourse-cdn.com/v4/letter/i/e9bcb4/32.png) [@ingalesd](https://www.dynamicsuser.net/u/ingalesd)\
**Post date:** [January 16, 2014, 11:12am UTC](https://www.dynamicsuser.net/t/ax2009-number-sequence-list-shows-active-and-used-number-of-posted-transactions/50322/2 "2014-01-16T11:12:42Z")

</div>

We have resolve this problem with Cleanup process batch run in every 24 Hrs.

Another way is to patch the code to check the next number is present in LedgerTrans or not using While loop at posted voucher number generation.

Its a limitation on Continuous Number sequence as per me. Many time it happens that vouchers do not post in a serial.

Hope same will work for you also.

Regards,

Shantaram

---

<div class="post-metadata">

**Author:** ![Anvilx](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@Anvilx](https://www.dynamicsuser.net/u/Anvilx)\
**Post date:** [January 17, 2014, 2:00am UTC](https://www.dynamicsuser.net/t/ax2009-number-sequence-list-shows-active-and-used-number-of-posted-transactions/50322/3 "2014-01-17T02:00:17Z")

</div>

Thanks Shantaram.

I will test with manual as well.

Regards,

Adrian