Re: Analysis of transfers

["Kevin G. Harper" <kharper@xxxxxxxxxxxxxxxxxxx>]

Dick,

Is there any reason the sequence# (TSEQ) wouldn't be consecutive between
the "T-from" and the "T-to"?  I believe on 8.3.4 the sequencing works fine.

If it is, then you should get accurate results by joining on TPROD, TTDTE
(excluding any highly unlikely cross-midnight transfers :)  ), ABS(TQTY),
and a.TSEQ = b.TSEQ-1 .

Using the time could cause misses, even up to the hour (e.g. 2:59:59 /
3:00:00) so I would exclude that part.

Kevin



On Wed, Feb 27, 2013 at 1:57 PM, Mark Sabol <msabol@xxxxxxxxxxxxxxxx> wrote:

> Are you using Lot Control?
> Or Shop order or some comment that could tie everything back together?
>
> -----Original Message-----
> From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
> Behalf Of Molyneux, Tom
> Sent: Wednesday, February 27, 2013 11:01 AM
> To: BPCS ERP System
> Subject: Re: [BPCS-L] Analysis of transfers
>
> Dick,
>
> We are on 8.3.2 so not sure if ITH changes in your version.
>
> I would think if you create a file of T transactions with negative
> quantities that will give you the "From" transactions. You should then be
> able to closely match them with the corresponding same but  positive
> quantities matched on Part Number (TPROD), Workstation (THWS), User
> (THUSER) and Date (TTDTE) to get the "To" transactions. Taking it down to
> the minute/second may miss matches if the "From" and "To" click over the
> second.
>
> Tom Molyneux
>
> NOV Mono
> MIS Department
>
> Tel.  +44 (161) 214 2142
> Fax. +44 (161) 214 2344
> E:mail  Tom.Molyneux@xxxxxxx
>
>
> -----Original Message-----
> From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
> Behalf Of Bailey, Dick
> Sent: 27 February 2013 15:14
> To: bpcs-l@xxxxxxxxxxxx
> Subject: [BPCS-L] Analysis of transfers
>
> We have a need to analyze transfers of parts based upon the combination of
> from-location and to-location.
>
> Transfers are recorded, however, in two pieces - the "from" piece and the
> "To". Joining them by part number, date, absolute quantity hour minute and
> second produces inaccurate results.
>
> Does anyone have an effective way to accomplish such a joining?
>
> We are on LX V8.3.4
>
> Dick Bailey
> MCFA, Inc.
> --
> This is the BPCS ERP System (BPCS-L) mailing list To post a message email:
> BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/bpcs-l.
>
>
>
> ________________________________
>
> Mono Pumps Limited
> Registered in England No. 300721.
> Registered Office : Martin Street, Audenshaw, Manchester. M34 5JA
>
> --
> This is the BPCS ERP System (BPCS-L) mailing list To post a message email:
> BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/bpcs-l.
>
> --
> This is the BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.