I thought of that. I think I hosed it up doing dmt after I moved Pilot to Test. I set the next po number to all 9s, since dmt won't import a po header larger than the last po number. Pilot doesn't get the error condition so I am good for the next round.
Got the info from support that the table KeyLast holds the next PO number. I did an update to reset the value and I am saved from doing DMT again this weekend.
This will come in handy as we normally set our POs to Year + ISO week + sequence, so I can just update the value each weekend.
Thanks
Greg
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, March 08, 2012 1:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RE: PO number 99999999
Work around, make a BPM which will set the PO Number for you? I know its kinda hacky but it may work.
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
Got the info from support that the table KeyLast holds the next PO number. I did an update to reset the value and I am saved from doing DMT again this weekend.
This will come in handy as we normally set our POs to Year + ISO week + sequence, so I can just update the value each weekend.
Thanks
Greg
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, March 08, 2012 1:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RE: PO number 99999999
Work around, make a BPM which will set the PO Number for you? I know its kinda hacky but it may work.
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Thu, Mar 8, 2012 at 1:44 PM, Greg Payne <gpayne@...> wrote:
> **
>
>
> Tried 0 and a number larger than our normal sequence. No change
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Mark Tellefson
> Sent: Thursday, March 08, 2012 9:56 AM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] RE: PO number 99999999
>
>
> Can you go into System Maintenance -> Company Maintenance -> Modules
> -> Materials -> Purchase and set the starting PO back to the next PO
> you want to use (or at least something other than all 9s)?
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:
> vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> Of Greg Payne
>
> Sent: Thursday, March 08, 2012 8:24 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
>
> Subject: [Vantage] PO number 99999999
>
> We had a po number of 999999999 - max in the system and now we are
> getting a message that this company can't issue po numbers since it is
> not the master company in consolidated purchasing. we don't use
> consolidated purchasing.
>
> Is there a fix to run for this issue? Support is on day two and no
> answer yet.
>
> we are not live yet, but are trying to do a conference room pilot. we
> can manually enter number and make new pos, so not totally non-functional.
>
> Thanks for any suggestions.
>
> Greg Payne
>
> Compulink Cable Assemblies
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including
> attachments, is privileged and confidential. It is intended only for
> the exclusive use of the addressee. If the reader of this message is
> not the intended recipient, or the employee or agent responsible for
> delivering it to the intended recipient, you are hereby notified that
> any dissemination, distribution or copying of this communication is
> strictly prohibited. If you have received this communication in error,
> please notify us at (727) 578-6258 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in
> the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
> Export of this material is restricted by the Arms Export Control Act
> (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
> without prior approval form the U.S. Department of State."
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________________
>
> [http://www.rapat.com/download/logoflat.jpg%5d<http://www.rapat.com>
>
> Mark Tellefson | Global IT Director |
> www.rapat.com<http://www.rapat.com>
>
> Phone: (218) 483-3344 | Toll Free: (800) 325-6377
>
> Confidentiality Notice: This e-mail message, including any
> attachments, is for the sole use of the intended recipient(s) and may
> contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not
> the intended recipient and received this in error, please contact the
> sender by reply e-mail. You are hereby notified that the copying, use
> or distribution of any information or materials transmitted in or with this message is strictly prohibited.
>
> [Non-text portions of this message have been removed]
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including
> attachments, is privileged and confidential. It is intended only for
> the exclusive use of the addressee. If the reader of this message is
> not the intended recipient, or the employee or agent responsible for
> delivering it to the intended recipient, you are hereby notified that
> any dissemination, distribution or copying of this communication is
> strictly prohibited. If you have received this communication in error,
> please notify us at (727) 578-6258 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in
> the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
> Export of this material is restricted by the Arms Export Control Act
> (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
> without prior approval form the U.S. Department of State."
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at (727) 578-6258 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."