MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 2014

Re: Update a field in a file from the trigger on the same file



fixed

Here's another business case. You get in a shipment. The receiver has a
fork lift accident before entering the receipt and is taken away. The
product is shipped out right away before the receipt is entered. Bam -
negative amount! So you just zero it out with your trigger. Now someone
enters the receipt. Which now says you have all this balance which you
really do not have.

Your SW will ship even if out of stock? Is this common? Our software
won't. Be gentle as I am ignorant, having worked at the same place for 40
years.






On Fri, May 30, 2014 at 3:04 PM, <rob@xxxxxxxxx> wrote:

Is this something like this?
You buy 3000' feet of wire. You don't measure it. You trust your
supplier.
Someone orders 1500'. You spool that off with an automatic counter and
get them that on the dot. Your on hand is now 1500'.
Someone orders another 1500'. You spool that off and you find there's
1510'. You ship that. Your supplier had tossed in a little extra, but
didn't bill you for it. Nice guy.
So now you have a negative on hand balance of -10'. You want to zero that
out instead of doing a manual inventory adjustment.

While your trigger could do that automatically, as myself and others have
noted, there is nothing stopping you from trying to generate an automatic
inventory adjustment. Yes, it will take a lot more work if your ERP
doesn't decouple the logic from their 5250 based inventory adjustment
manual entry screen.

Here's another business case. You get in a shipment. The receiver has a
fork lift accident before entering the receipt and is taken away. The
product is shipped out right away before the receipt is entered. Bam -
negative amount! So you just zero it out with your trigger. Now someone
enters the receipt. Which now says you have all this balance which you
really do not have.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.









Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact