Re: SQL Question

Joel,

That is, in fact, exactly how we handle it here. Your "cancelled" status is
what we refer to as a "voided" status. The status flag is set on, and the
item line remains in the file. However, any documention produced after that
point will no longer display the "voided" item(s), therefore, it appears on
paper as though you have an order where the item lines began numbering at 2.


Regards,

John Taylor
Canada

----- Original Message -----
From: "Joel Fritz" <JFritz@sharperimage.com>
To: <MIDRANGE-L@midrange.com>
Sent: Friday, June 30, 2000 09:46
Subject: RE: SQL Question


> Each line should have a status flag.  Line 1 has "cancelled" status.  You
> have to update all the related files, but it's something that's part of
the
> normal course of doing business.
>
> If the order has already been picked but not shipped, you can handle it as
a
> return with a different order that also contains a reference to the
original
> order and leave the original order intact.
>
> -----Original Message-----
> From: John Taylor [mailto:john.taylor@telusplanet.net]
> Sent: Friday, June 30, 2000 6:24 AM
> To: MIDRANGE-L@midrange.com
> Subject: RE: SQL Question
>
>
>
>
> > -----Original Message-----
> > From: owner-midrange-l@midrange.com
> > [mailto:owner-midrange-l@midrange.com]On Behalf Of R. Bruce Hoffman, Jr.
> > Sent: Friday, June 30, 2000 5:52 AM
> > To: MIDRANGE-L@midrange.com
> > Subject: Re: SQL Question
>
> Hi Bruce,
>
> How about another example?
>
> Customer places order for 5 items. Order is committed, and pick ticket is
> generated. Customer later calls back and cancels item line 1. Salesman
> "voids" item line 1, leaving an order with valid items lines 2 through 5,
> and life goes on. In order to reorder the item lines, you'll either have
to
> complicate your audit trail (because paperwork has already been
generated),
> or cancel and re-enter the entire order.
>
> How do you handle it?
>
>
> Regards,
>
> John Taylor
> Canada
>
> >
> > -----Original Message-----
> > From: James W. Kilgore <eMail@James-W-Kilgore.com>
> > To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
> > Date: Friday, June 30, 2000 5:06 AM
> > Subject: Re: SQL Question
> >
> >
> > >Bruce,
> > >
> > >The customer service representative is on the phone with the customer
> > >and keying in items and quantities as they speak, at the end of the
> > >conversation, the customer chooses not to order the first item for a
> > >myriad of reasons.
> > >
> >
> >
> > So, you commit ordered items to the database before the order is
complete?
> > <vbg> But I was asking Brad.  ;-)
> >
> > I can see this, but, again, design seems to be the issue.  As a user, if
I
> > were to see an order with 10 items numbered from 127 thru 136, I
> > would think
> > something is quite wrong with the system.  This would most likely
manifest
> > itself as "... I don't like the new system... ...it just seems wrong...
> > ...even though I can't quite put my finger on what...".
> >
> >
> > ===========================================================
> > R. Bruce Hoffman, Jr.
> >  -- IBM Certified AS/400 Professional System Administrator
> >  -- IBM Certified AS/400 Professional Network Administrator
> >  -- IBM Certified Specialist - AS/400 Administrator
> >  -- IBM Certified Specialist - RPG IV Developer
> >
> > "If all you have is RPG, then everything looks like a 400!"
> >
> >
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> > MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
> > david@midrange.com
> > +---
> >
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---