E9 - Generate Serial Numbers Question

Yahoo Archive
1
I was going to try to customize the add serial numbers code when you are in serial number assignment, this helps
Â
Thanks Karen


________________________________
From: Karen Schoenung <kschoenung@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, December 26, 2012 2:18 PM
Subject: RE: [Vantage] E9 - Generate Serial Numbers Question

Â
You do not say how you are doing this (code, crystal etc). You can create a formula for 52 (current year - 1960), for 50 (current day number 360 for today for example...Integer((360+7)/7) where the +7 is date to end first week of the year) - not sure how your weeks run, you may need to change this formula but this may get you a start...

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Wednesday, December 26, 2012 12:33 PM
To: Vantage User Group
Subject: [Vantage] E9 - Generate Serial Numbers Question

We have a customer who has a requirement for the following serial number format:

52500001

52 is the 52nd year from 1960, 50 is the week of the year, and the other 4 numbers are sequential

I can add the 52 as a prefix to get by for now, but I dont know of anyway to generate the current week. Has anyone written any custom serial number generators like this? I want to be able to create them during serial number assignment. Since some of our jobs call for 300 or more parts I dont want to have to manually key in 300 serial numbers

Thoughts?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
2
We have a customer who has a requirement for the following serial number format:
Â
52500001
Â
52 is the 52nd year from 1960, 50 is the week of the year, and the other 4 numbers are sequential
Â
I can add the 52 as a prefix to get by for now, but I dont know of anyway to generate the current week. Has anyone written any custom serial number generators like this? I want to be able to create them during serial number assignment. Since some of our jobs call for 300 or more parts I dont want to have to manually key in 300 serial numbers
Â
Thoughts?

[Non-text portions of this message have been removed]
3
You do not say how you are doing this (code, crystal etc). You can create a formula for 52 (current year - 1960), for 50 (current day number 360 for today for example...Integer((360+7)/7) where the +7 is date to end first week of the year) - not sure how your weeks run, you may need to change this formula but this may get you a start...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Wednesday, December 26, 2012 12:33 PM
To: Vantage User Group
Subject: [Vantage] E9 - Generate Serial Numbers Question



We have a customer who has a requirement for the following serial number format:

52500001

52 is the 52nd year from 1960, 50 is the week of the year, and the other 4 numbers are sequential

I can add the 52 as a prefix to get by for now, but I dont know of anyway to generate the current week. Has anyone written any custom serial number generators like this? I want to be able to create them during serial number assignment. Since some of our jobs call for 300 or more parts I dont want to have to manually key in 300 serial numbers

Thoughts?

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]