Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jon Oswald]

When doing a PO receipt with auto-assignment of serial numbers the first receipt serial numbers (8) were assigned as expected.  The second receipt later in the day (6), the serial numbers skipped over a range of numbers before assigning numbers.  The sequence code is set to automatic and is not continuous.

Any ideas as to the cause?

Thanks. 

——————————
Jon Oswald
IBM Netherlands
——————————

[Dave Phillips]

Hi Jon –

You can create Serial Numbers in preparation for a Transaction. Could that have happened?

Thanks….Dave

——————————
Dave Phillips
MSFT Senior PFE
Microsoft
Fargo ND
——————————
——————————————-

[Jon Oswald]

Serial numbers were not manually created before hand or at anytime. 

——————————
Jon Oswald
IBM Netherlands
——————————
——————————————-

[Paul Martin]

my suggestion would be to go to inventtrans   Inventory management– inquiries– transactions and look for the item and serial numbers and see what you can determine there. Lots of people do not want to look at the transactions, but it is the record that AX keeps and often times is the only place you can go to figure out what happened.

——————————
Paul Martin
Expert ERP Analyst
TempurSealy Inc.
Trinity NC
——————————
——————————————-

[Scott Morley]

Jon,
Non-continuous number sequences can be set to preallocate, which will store a group of numbers in memory for performance improvement. Depending on where the 2nd process was run, it may get numbers from a second preallocation. If you want to make sure this doesn’t happen you can turn off preallocation on the specific number sequence on the Performance fast tab of the number sequence. This will mean each new number request will call the database, but you wont see phantom gaps. The performance loss will likely not be significant unless you are generating thousands of serial numbers at the same time. 

——————————
Scott Morley
Principal Application Architect
OneNeck IT Solutions
Bend OR
——————————
——————————————-

[Jon Oswald]

Hi Scott,
Pre-allocation is not marked on the number sequence.

——————————
Jon Oswald
IBM Netherlands
——————————
——————————————-

[Scott Morley]

Jon,
You may just be experiencing the nature of non-continuous number sequences. If you start a receipt, the number sequences will get generated, but then if you cancel the receipt before completing it, those generated numbers will be discarded. Since it is set to non-continuous, AX will not try to reuse them, so you will see gaps. If you really need to have no gaps, the number sequence should be set to continuos. 

——————————
Scott Morley
Principal Application Architect
OneNeck IT Solutions
Bend OR
——————————
——————————————-

[Jon Oswald]

The receipts were from two different PO’s, in addition we found some serial numbers were generated with no transactions.  We were expecting the serial numbers to be sequential.

——————————
Jon Oswald
IBM Netherlands
——————————
——————————————-

[Dave Phillips]

Hi Jon –

Is a Number Group for Serial in play and if so is it assigned to another Item(s)?  The other Item could have consumed the Serial Numbers and created the gap you noticed.

Check table InventSerial or go to Inventory | Inquiries | Dimensions | Serial Numbers to run down numbers in the serial gap to see if present and what they ended up on.

Thanks….Dave

——————————
Dave Phillips
MSFT Senior PFE
Microsoft
Fargo ND
——————————
——————————————-

[Jon Oswald]

Hi Dave,
Yes, it is used by other items but they are not within this range.  Some serial numbers were generated with no transactions.

——————————
Jon Oswald
IBM Netherlands
——————————
——————————————-

[Dave Phillips]

Hi Jon –

I have tried to replicate the issue based on my understanding of the setup but I cannot generate extra Serial Numbers.

The answer will take research of the pointers made in this thread and seeing if a user can replicate what happened.

Thanks…Dave

——————————
Dave Phillips
MSFT Senior PFE
Microsoft
Fargo ND
——————————
——————————————-