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

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

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