RE: SQL Question

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

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
+---