Hello Dick
If you do file joining then Minute/Sec may create problem in some cases. What we have done is report written based on ITH sequence number for transaction type 'T'. For trf. these would be consecutive numbers hence it gives always correct result.
Regards,
_____________________________________________________________________________
Umed Sethia ¦ Proud to be Indian ¦ M. +91 99710 96596 ¦ Skype ID : umed.sethia
KARNI SOFT SOLUTIONS PVT. LTD ¦ . . . . . . . . Aligning IT to BUSINESS ¦ Website : www.KarniSoftSol.com
Delhi Office: F - 6/10, Krishna Nagar, 2nd Floor, New Delhi - 110 051 (India) ¦
Kolkata Office: 1,Chandney Chowk Street, 1st Floor, B-Block, Room No.-7, Kolkata-700072, West Bengal,(India) ¦
ERP(BPCS/LX and TIM) ¦ SCM(Infor SCM Planning) ¦ BI&DW ¦ Retail Solutions ¦ i Series/AS400 (Administration, DR Solutions(MIMIX), Application Development & Maintenance) ¦ System Audit ¦ Project Management ¦
----------------------------------------
From: bpcs-l-request@xxxxxxxxxxxx
Sent: Wednesday, February 27, 2013 11:30 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: BPCS-L Digest, Vol 11, Issue 8
Send BPCS-L mailing list submissions to
bpcs-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
bpcs-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
bpcs-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of BPCS-L digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. Analysis of transfers (Bailey, Dick)
2. Re: Analysis of transfers (Norman.Boyd@xxxxxxxxxxxxxx)
3. Re: Analysis of transfers (Molyneux, Tom)
4. Re: Analysis of transfers (Al Mac Wow)
----------------------------------------------------------------------
message: 1
date: Wed, 27 Feb 2013 15:13:33 +0000
from: "Bailey, Dick" <Dick.Bailey@xxxxxxxx>
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.
------------------------------
message: 2
date: Wed, 27 Feb 2013 10:36:40 -0500
from: Norman.Boyd@xxxxxxxxxxxxxx
subject: Re: [BPCS-L] Analysis of transfers
Join the ITH file to itself. The first instance of course is a negative
transfer and the from-location, the second instance is a positive transfer
and the to-location, the item number matches AND the second sequence
number is equal to the first sequence number plus one, and the date is the
same.
We're on 6.00.04 but I can't imagine that things have changed that much.
I hope it helps.
Norman K. Boyd
Keihin Thermal Technology of America, Inc
From: "Bailey, Dick" <Dick.Bailey@xxxxxxxx>
To: "bpcs-l@xxxxxxxxxxxx" <bpcs-l@xxxxxxxxxxxx>
Date: 02/27/2013 10:13 AM
Subject: [BPCS-L] Analysis of transfers
Sent by: bpcs-l-bounces@xxxxxxxxxxxx
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.
------------------------------
message: 3
date: Wed, 27 Feb 2013 16:01:17 +0000
from: "Molyneux, Tom" <Tom.Molyneux@xxxxxxx>
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
------------------------------
message: 4
date: Wed, 27 Feb 2013 11:36:34 -0600
from: "Al Mac Wow" <macwheel99@xxxxxxxxxx>
subject: Re: [BPCS-L] Analysis of transfers
Because we had a problem with transfers across facilities, where the items
costed differently both places, we had the T of ITH go into TR General
Ledger, with full journal detail. If you look at the various description
info columns of GJD, they show part # and other details.
We 405 CD, and rarely need to transfer the same part multiple times in same
day.
Al Mac (WOW) = Alister William Macintyre
via WOW WAY.com ISP
day job = www.kewire.com Lawrenceville Il (near Vincennes In) via VPN/400
(our division dates back to 1955)
-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of Bailey, Dick
Sent: Wednesday, February 27, 2013 9:14 AM
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.
------------------------------
--
This is the BPCS ERP System (BPCS-L) digest 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.
End of BPCS-L Digest, Vol 11, Issue 8
*************************************
As an Amazon Associate we earn from qualifying purchases.