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

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





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