Quote Number Reset

Yahoo Archive
1
Perfect thanks!



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Daniel Laidig
Sent: Monday, February 09, 2009 1:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quote Number Reset



Using SC would be pretty easy. You could just run a BAQ on a timer to export
each month and have one calculated field be exported with your calculations
below.

Daniel

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Monday, February 09, 2009 1:26 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Quote Number Reset

All,

Each month I have to manually go in and reset our starting quote number its
basically formatted like this ((year-2000) * 100,000) + (month * 1,000) + 1.
Which means this month's first quote will be numbered 902001.

I was wondering if there would be anyway to schedule this change to occur on
the first day of each month so that 12:01 this number would be updated
correctly.

I have SC at my disposal but it seems that doing this with a BPM may be
easier but I'm not sure how to schedule this action to take place at the
beginning of each month with a BPM.

Any Suggestions?

~Charlie

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

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



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.233 / Virus Database: 270.10.17/1933 - Release Date: 02/03/09
17:48:00




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



Each month I have to manually go in and reset our starting quote number its
basically formatted like this ((year-2000) * 100,000) + (month * 1,000) + 1.
Which means this month's first quote will be numbered 902001.



I was wondering if there would be anyway to schedule this change to occur on
the first day of each month so that 12:01 this number would be updated
correctly.



I have SC at my disposal but it seems that doing this with a BPM may be
easier but I'm not sure how to schedule this action to take place at the
beginning of each month with a BPM.



Any Suggestions?





~Charlie





[Non-text portions of this message have been removed]
3
Using SC would be pretty easy. You could just run a BAQ on a timer to export
each month and have one calculated field be exported with your calculations
below.



Daniel

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Monday, February 09, 2009 1:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Quote Number Reset



All,

Each month I have to manually go in and reset our starting quote number its
basically formatted like this ((year-2000) * 100,000) + (month * 1,000) + 1.
Which means this month's first quote will be numbered 902001.

I was wondering if there would be anyway to schedule this change to occur on
the first day of each month so that 12:01 this number would be updated
correctly.

I have SC at my disposal but it seems that doing this with a BPM may be
easier but I'm not sure how to schedule this action to take place at the
beginning of each month with a BPM.

Any Suggestions?

~Charlie

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





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