RE: JBA ML - Order numbers in SOP

Off hand I can't see too much of a problem here - if
your 'internally generated' orders started from
0000001 and the externally created from say 5000001
you'd be OK (until you created more than 5 million
orders from either source!).

Word of caution: although the order number is defined
in the database as alpha, in practice it's only ever
numeric in vanilla JBA. I'd be careful about
introducing an alpha prefix, there may be places where
the field is treated as numeric eg to eliminate
leading zeroes.

Also there may be reports which run on a range of
order numbers - you'd be looking at two ranges.

As always I'd run this through a test environment
first.

Good Luck

Peter Joel
Saltway Ltd

 --- "Duncan, Helen (MacGas)" <DuncanH2@bp.com> wrote:
> We are looking at an external package generating
> some orders while we
> continue to generate other orders on the system.
> All orders will eventually
> be confirmed on SOP and it will help our quality
> assurance system if the
> number that appears on the externally generated
> order documentation also
> appears on the SOP invoice.  So I was wanting a
> standard sequence of order
> numbers for SOP generated orders and a prefixed (if
> possible?) sequence of
> order numbers for the externally generated orders.
>
> Helen Duncan
> Direct line: 0141 307 4887
> e-mail: duncanh2@bp.com
>
>
> -----Original Message-----
> From: Saltway Limited
> [mailto:saltwayltd@yahoo.co.uk]
> Sent: 13 November 2001 15:32
> To: jbausers-l@midrange.com
> Subject: Re: JBA ML - Order numbers in SOP
>
>
> Despatch docs & invoices can have different
> sequences
> by stockroom/site(via 2/INU & 3/INU), orders cannot.
> Remember that an order can potentially have lines on
> different stockrooms. How would you want your 2
> sequences to work?
>
> Peter Joel
> Saltway Ltd
> 07884 306501
>
>  --- "Duncan, Helen (MacGas)" <DuncanH2@bp.com>
> wrote:
> > Is it possible to have 2 sequences of order
> numbers
> > running on SOP &
> > Inventory?  And if so. how do I set them up?
> >
> > Thanks in advance for all responses.
> >
> > Regards
> >
> > Helen Duncan
> > Direct line: 0141 307 4887
> > e-mail: duncanh2@bp.com
> >
> > _______________________________________________
> > This is the GEAC/JBA System 21 Users (JBAUSERS-L)
> > mailing list
> > To post a message email: JBAUSERS-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit:
> >
>
http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
> > or email: JBAUSERS-L-request@midrange.com
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/jbausers-l.
> >
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page from
> News and Sport to Email and
> Music Charts
> http://uk.my.yahoo.com
> _______________________________________________
> This is the GEAC/JBA System 21 Users (JBAUSERS-L)
> mailing list
> To post a message email: JBAUSERS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
> or email: JBAUSERS-L-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/jbausers-l.
> _______________________________________________
> This is the GEAC/JBA System 21 Users (JBAUSERS-L)
> mailing list
> To post a message email: JBAUSERS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
> or email: JBAUSERS-L-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/jbausers-l.
>

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and 
Music Charts
http://uk.my.yahoo.com