SBX - Search With Button

SBX - Forum Post Title

BOM Sequence Mask

Microsoft Dynamics SL Forum

Chris McCoy asked a question on 8 Aug 2018 12:26 PM
My Badges

Question Status


Using SL 2015 CU2. Have some old BOMs that were created way back in Solomon version 4. We had some customizations done that used an item number as the then sequence number was not good enough (to short). At least that's what I think, I could be wrong

Anyway, several years back, I ran a sql routine that updated the sequence numbers with the values from the custom field, so the BOM report would sort the items correctly. User3 was the custom field. User3 had a decimal in the mask followed by two numbers. So, the update statement did not work correctly on all of the BOMs. So the update would put E+0006 (or somesuch) in the sequence field, which would cause the BOM report to crater. I figured out the correct update statement to fix these. Users will periodically run up against these bad sequence numbers and ask me to fix them.

This morning a user found one, with a bunch of sub BOMs, so I opened management studio to fix it, and one of the sub BOMs I looked at the select results and noticed that two lines had E+0007 there, meaning they had a 6 digit "sequence" number. I set that one aside, and found another one that User3 had 12345.10 (for example), and I could not update that one either.

The Mask for the BOM sequence is 99999. My question, can I update the mask using customization manager to 99999.99 without breaking anything?

Thanks in advance.


Carolyn Froton responded on 22 Aug 2018 1:43 PM
My Badges

you can update the mask, yes.  Will it break anything?  Not certain on that.  As with any customization, something can arise and it is suggested that you test this.  The BOM sequence number in standard sl is 99999.  Adding a period in the sequence could possibly cause SL to be unable to follow that sequence appropriately, but again, this would have to be tested out as it has not been reported before.

StuartN responded on 22 Aug 2018 1:56 PM
My Badges

You know you're using two different data types? Sequence is a character field, five characters in length. User3 is a float/numeric field. Since the table limits the length of the Sequence field to 5, I'm not sure you can expand on it with a mask.


SBX - Two Col Forum

SBX - Migrated JS