Also...
If the sequence number for an item doesn't start with 1 and run
sequentially, the results in INV300 (History) will be unpredictable, and
probably incomplete.
**CAUTION**
Purging the ITH is not a trivial exercise that can be done with an SQL
delete statement! Use the BPCS supplied program, or find someone who has
worked with this file before!
Phil C
Norman.Boyd@xxxxxxxxxxxxxxxxx
Sent by: bpcs-l-bounces+phil.catlin=formica.com@xxxxxxxxxxxx
02/06/2009 08:28 AM
Please respond to
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
To
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
cc
Subject
Re: [BPCS-L] Sequence Number
The last sequence number is also tracked in the item master file (iim).
I'm not too familiar with the function differences between the versions of
BPCS but, if your ITH file is getting too large, are you not running the
Month End Close in the inventory module, INV903 on the screen, INV900
batch program? This will move records from the ITH to the YTH file,
keeping ITH smaller and all of your inventory transactions intact. If you
have any sort of auditing procedures, internal or external, you probably
don't want to delete inventory transaction records. You'll also want to
check your system setup(SYS800, Transaction History System Parameters -
SYS824) before running the INV900 as it may be running for quite some
time, especially if you haven't run it in the past.
Norman K. Boyd
MIS Administrator
Showa Aluminum Corp. of America
Phone: (740) 869-5007
Cell: (740) 572-7876
Fax: (740) 869-3309
CONFIDENTIALITY NOTICE: This e-mail message is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message. If you are the intended recipient but do not wish to receive
communications via email, please advise the sender immediately.
"Molyneux, Tom" <Tom.Molyneux@xxxxxxx>
Sent by: bpcs-l-bounces+norman.boyd=showaaluminum.com@xxxxxxxxxxxx
02/06/2009 05:24 AM
Please respond to
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
To
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
cc
Subject
Re: [BPCS-L] Sequence Number
It is also used in Cycle Counting. If you select a part for cycle
counting, BPCS will stamp the ILI record for the part/location with the
ITH transaction sequence at the time the record was selected. When you
post the count it uses this transaction number to work out if it needs to
make any adjustments for any transactions since the cycle count selection.
So you need to be very careful if deleting any ITH records.
Tom Molyneux
National Oilwell Varco
Mono Pumps Limited
MIS Department
Tel. 0161 214 2142
Fax. 0161 214 2344
E:mail Tom.Molyneux@xxxxxxx
-----Original Message-----
From: bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx [
mailto:bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx] On Behalf Of
Sandipan Sengupta
Sent: 06 February 2009 10:05
To: BPCS ERP System
Subject: Re: [BPCS-L] Sequence Number
The Sequence Number in ITH is a count of the number of transactions
happening for a particular item.
On 2/6/09, colin clement <colin.clement@xxxxxxxxxxx> wrote:
Can I just there ask is this the only place that it is used and
therefore it does not matter if you delete records from ITH as long as
they are from the front of the sequence numbers.
Thanks
Colin Clement> To: bpcs-l@xxxxxxxxxxxx> From: tay@xxxxxxxxxxxxx> Date:
Fri, 6 Feb 2009 17:42:34 +0800> Subject: Re: [BPCS-L] Sequence Number>
To control display transaction history sequence !> > -- > 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.> >
Delivered-To: colin.clement@xxxxxxxxxxx
_________________________________________________________________
Check out the new and improved services from Windows Live. Learn more!
http://clk.atdmt.com/UKM/go/132630768/direct/01/
--
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.
Delivered-To: sandysg@xxxxxxxxx
--
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.
Delivered-To: Tom.Molyneux@xxxxxxx
Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Martin Street, Audenshaw, Manchester. M34 5JA
midrange.com
