× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.