Number sequence

(0) Share

Report

Posted on by Neil German

Hi,

What is the best approach to create number sequence ?

If I set continuous number sequence, will there be any impact?

Thanks.

Neil

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

RE: Number sequence

Hi Neil,

Please see below from MS documentation:

Unless there is a regulatory requirement that you use continuous number sequences, we recommend that you use non-continuous number sequences for better performance.

Take a look at link below:

docs.microsoft.com/.../number-sequence-overview

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Number sequence

Hi Neil German,

There is nothing called 'Best approach' in this case.

Would be great if you kindly share more information on this like below so that to understand the requirement clearly. Based on that, it will be easy to provide you a suggestion.

--- Do you mean all number sequence to be set as 'Continuous' ?

--- Is there a business requirement to set all sequences 'Continuous' ?

--- What are the types of transactions you will record in ERP ?

--- What could be the volume of transactions you are expecting to record in system on daily basis ?

--- Is there any integration related transactions can be considered too with large volume ?

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Neil German 20 on at

Like (0)

Report

RE: Number sequence

Hello Satish & Sourav,

Thanks for your fast and prompt response.

Yes client requirement is to set continuous number sequence as they will pass different journals like general journal, customer and vendor invoice and payment, purchase orders, sales orders, inventory related journal also. For all these they expect sequence to be continuous.

Hello Sourav; thanks for asking these questions. We are doing integration also which is actually pulling around 40000 transactions everyday from a 3rd party application into ERP system. These are mainly general journal type entries. But my project manager wants to confirm if these large volume of data will create any impact on system performance in future. I am not sure about that that's why asking.

Thanks & regards,

Neil.

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

RE: Number sequence

High volume, non-regulatory requirement - Use non-continuous. Show them the standard product documentation (link shared above).

Was this reply helpful? Yes No
Verified answer

SouravDam 11,730 on at

Like (0)

Report

RE: Number sequence

Hi Neil German,

Thanks for the response.

Would like to know; have you checked the link what Satish Panwar mentioned ? It explained detail about the number sequence.

For your question; yes I think it may create impact on system performance going ahead if you push that many records on daily basis in ERP especially when you set the sequence as "Continuous". In addition, users might be posting manual transactions too.

Better if you set the number sequence using Preallocation option. It will ultimately keep the process flow on a level where chances will be less to face the performance issue.

This is a very simple setup but quite helpful. You can try this in UAT system first. Just disable the Continuous check box. System will automatically enable the Preallocation check box and a default value of '5' will be set in the Quantity of numbers field. However; you can update this to any higher value of '5'. If you try to set lower value of '5', then you will get a popup message. Click on 'NO'.

For example; we have set this in 'GEN' series journal.

The Next and Largest number in 'Preallocation' will be set automatically by system itself.

When you start posting transactions using this journal name, system will allot the number based on 'Preallocation'. Once the largest number crossed here; system will pick the next number '17001' from Number allocation as shown in above screen shot.

Now, when the number '17001' is also utilized; then ERP will again allocate the number like the following.

--- The 'Next' number in Number allocation will be set to (17001 + 5) = 17006 (this is because I set '5' in Quantity of numbers field).

--- 'Next' and 'Largest' number fields will be set by ERP in Preallocation section as '17002' and '17005'.

As I mentioned; kindly test this intensively in UAT system and check the impact before applying anything in PROD environment.

We will be waiting for your feedback on this.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Neil German 20 on at

Like (0)

Report

RE: Number sequence

Hi,

Thanks to all of you for help and detailed explanation.

Tested in UAT and working fine. I never used this before actually.

Thanks again for much needed help.

Regards,

Neil

Was this reply helpful? Yes No