Re: BPCS-L Digest, Vol 15, Issue 25
"Umed Sethia" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.bpcs |
|---|---|
| Message-ID | <00d501d2bf7a$033cb070$09b61150$@com> |
Dear Bob
This can be easily done using a customised script and ecm
inventory process. This will be fully automated process with no manual
keying the data either in INV500 or excel file and more accurate as it uses
BPCS/Lx in-build solution. Pls let me know if any query.
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/IBM i (Administration, DR Solutions(MIMIX),
Application Development & Maintenance) ¦ System Audit ¦ Project Management ¦
-----Original Message-----
From: BPCS-L [mailto:bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of
bpcs-l-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Sent: Thursday, April 27, 2017 10:30 PM
To: bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: BPCS-L Digest, Vol 15, Issue 25
Send BPCS-L mailing list submissions to
bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
You can reach the person managing the list at
bpcs-l-owner-Zwy7GipZuJhWk0Htik3J/[email protected]
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. Deleting an Inventory Location -- automate the manual data
entry pain (Milt Habeck)
2. Re: Deleting an Inventory Location -- automate the manual
data entry pain (Rob Berendt)
3. Re: Deleting an Inventory Location -- automate the manual
data entry pain (Norman Boyd)
----------------------------------------------------------------------
message: 1
date: Wed, 26 Apr 2017 14:53:43 -0500
from: "Milt Habeck" <[email protected]>
subject: [BPCS-L] Deleting an Inventory Location -- automate the
manual data entry pain
<vendor>
Dear Robert,
Replies from Mr. Bilgen and Al Mac confirm our conclusion that a
considerable amount of manually-entered inventory transaction activity will
be needed to solve this.
There is no way within BPCS to prohibit the use of an active location by
specific items. So, it's necessary to deactivate your bad locations and to
do that, all inventory quantities will first have to be removed or moved.
The simplest method would be to remove or zero out invalid locations with a
cycle count type of transaction, but that does not handle actual inventory
that may exist. So a better alternative would be to transfer any existing
inventory found in the bad/fictitious locations into valid locations.
Here's an idea to greatly reduce the pain of manually entering a high volume
of transactions. Our Lickety-Split software transports rows of Excel data
into iSeries green screen apps (in this case INV500) as if it were being
keypunched. It's lightning fast with zero fat thumb errors .... and .... all
the edit checking in the green screen application is still performed. It's
slick.
More information --->
<http://www.unbeatenpath.com/software/dataentry/Lickety-Split.pdf>
http://www.unbeatenpath.com/software/dataentry/Lickety-Split.pdf
Reference letter ---->
<http://www.unbeatenpath.com/references/away02stewart.pdf>
http://www.unbeatenpath.com/references/away02stewart.pdf
Automating the INV500 entry effort with Lickety-Split makes the inventory
clean-up extremely quick .... before more inventory arrives in the bad
location by accident.
Additional research may be needed to see what is causing your inventory to
get into the bad locations in the first place. If it is arriving from open
shop orders or allocations, those may also need to be taken care of before
locations can be deactivated.
Warmest regards,
Milt Habeck
Unbeaten Path International
[email protected]
(888) 874-8008
(+USA) 262-681-3151
www.unbeatenpath.com
</vendor>
From: B Bilgen
Sent: Sunday, April 23, 2017 8:06 AM
To: bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]
Robert, You can always run INV970 which will delete all records from the
lot, location, and container files (ILN, ILI, and YCI) that do not have any
inventory and do not have any activity. However it doesn't sound like that
is the activity you want to do. There is no system program available to
remove a single item from the location inventory - you will need to do this
manually. Here are the steps that BPCS takes before removing records (in
INV970). It would be a good idea to follow the same edit checks for the
records you want to remove manually.
<snip>
From: Robert G. Hermann
Sent: Friday, April 21, 2017 12:44 PM
To: <mailto:BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]> BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: [BPCS-L] Deleting an Inventory Location
A manager at one of our plants sent me the question below. As far as I know
the answer to his question is No, but I thought I'd ask the experts here on
BPCS-L.
We are on BPCS 5.1.
(Unfortunately, we moved our headquarters to a new building a year ago and
were forced to ditch all hard-copy BPCS documentation prior to the move.)
Thanks in advance.
Best regards,
Bob Hermann
CertainTeed Corporation
=======
Is it possible to delete an inventory location in BPCS for an individual
part number? If so, please advise.
Background Info: We have numerous parts with multiple locations that are no
longer used. We also have a couple of a couple of fictitious locations
(e.g., BAN and PAN) we want to get rid of. We think we know how to mass
delete location from the system, but all items have to be at zero qty. We
would like to remove the locations as we come across them for individual
items. An example is part number U35A02001. You can see from the
transactions below that we reported a shop order on 3/21 and then
transferred the inventory from BAN to FM0105 on 3/27. It would have been
great at that time to the delete BAN as a location for this line item.
Trans Ref No Whse/Loc Quantity Date
Balance Lot
T 30 FM0105 1.000
3/27/17 1.000
T 30 BAN
1.000- 3/27/17
PR 52698 30 BAN 1.000
3/21/17 1.000
FYI - we have recently started an aggressive cycle counting program and are
constantly running into these BAN and PAN locations, which have no physical
location in the warehouse. Inaccurate or poorly labeled warehouse
locations, part identification, and shop order reporting issues so far have
been the primary reasons for our count discrepanices. We want to clean up
the locations both in BPCS and in the plant.
Thanks in advance for the assistance.
------------------------------
message: 2
date: Wed, 26 Apr 2017 17:46:59 -0400
from: Rob Berendt <[email protected]>
subject: Re: [BPCS-L] Deleting an Inventory Location -- automate the
manual data entry pain
Nice plug, but wouldn't you have to key the data into Excel?
So, I can key the data into INV500 manually, with it's interactive edit
checks, or, I can key the data into Excel without any edit checks and then
pump it up with your software and then let the edit checks happen.
I can only see this being an advantage if I had some method of an
intelligent automated process which would dump out the necessary
corrections, convert that into Excel, and then pump it up with your
software.
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
From: "Milt Habeck" <[email protected]>
To: "BPCS user group" <bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
Date: 04/26/2017 05:43 PM
Subject: [BPCS-L] Deleting an Inventory Location -- automate the
manual data entry pain
Sent by: "BPCS-L" <bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]>
<vendor>
Dear Robert,
Replies from Mr. Bilgen and Al Mac confirm our conclusion that a
considerable amount of manually-entered inventory transaction activity
will
be needed to solve this.
There is no way within BPCS to prohibit the use of an active location by
specific items. So, it's necessary to deactivate your bad locations and to
do that, all inventory quantities will first have to be removed or moved.
The simplest method would be to remove or zero out invalid locations with
a
cycle count type of transaction, but that does not handle actual inventory
that may exist. So a better alternative would be to transfer any existing
inventory found in the bad/fictitious locations into valid locations.
Here's an idea to greatly reduce the pain of manually entering a high
volume
of transactions. Our Lickety-Split software transports rows of Excel data
into iSeries green screen apps (in this case INV500) as if it were being
keypunched. It's lightning fast with zero fat thumb errors .... and ....
all
the edit checking in the green screen application is still performed. It's
slick.
More information --->
<http://www.unbeatenpath.com/software/dataentry/Lickety-Split.pdf>
http://www.unbeatenpath.com/software/dataentry/Lickety-Split.pdf
Reference letter ---->
<http://www.unbeatenpath.com/references/away02stewart.pdf>
http://www.unbeatenpath.com/references/away02stewart.pdf
Automating the INV500 entry effort with Lickety-Split makes the inventory
clean-up extremely quick .... before more inventory arrives in the bad
location by accident.
Additional research may be needed to see what is causing your inventory to
get into the bad locations in the first place. If it is arriving from open
shop orders or allocations, those may also need to be taken care of before
locations can be deactivated.
Warmest regards,
Milt Habeck
Unbeaten Path International
[email protected]
(888) 874-8008
(+USA) 262-681-3151
www.unbeatenpath.com
</vendor>
From: B Bilgen
Sent: Sunday, April 23, 2017 8:06 AM
To: bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]
Robert, You can always run INV970 which will delete all records from the
lot, location, and container files (ILN, ILI, and YCI) that do not have
any
inventory and do not have any activity. However it doesn't sound like
that
is the activity you want to do. There is no system program available to
remove a single item from the location inventory - you will need to do
this
manually. Here are the steps that BPCS takes before removing records (in
INV970). It would be a good idea to follow the same edit checks for the
records you want to remove manually.
<snip>
From: Robert G. Hermann
Sent: Friday, April 21, 2017 12:44 PM
To: <mailto:BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]> BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: [BPCS-L] Deleting an Inventory Location
A manager at one of our plants sent me the question below. As far as I
know
the answer to his question is No, but I thought I'd ask the experts here
on
BPCS-L.
We are on BPCS 5.1.
(Unfortunately, we moved our headquarters to a new building a year ago and
were forced to ditch all hard-copy BPCS documentation prior to the move.)
Thanks in advance.
Best regards,
Bob Hermann
CertainTeed Corporation
=======
Is it possible to delete an inventory location in BPCS for an individual
part number? If so, please advise.
Background Info: We have numerous parts with multiple locations that are
no
longer used. We also have a couple of a couple of fictitious locations
(e.g., BAN and PAN) we want to get rid of. We think we know how to mass
delete location from the system, but all items have to be at zero qty. We
would like to remove the locations as we come across them for individual
items. An example is part number U35A02001. You can see from the
transactions below that we reported a shop order on 3/21 and then
transferred the inventory from BAN to FM0105 on 3/27. It would have
been
great at that time to the delete BAN as a location for this line item.
Trans Ref No Whse/Loc Quantity Date
Balance Lot
T 30 FM0105 1.000
3/27/17 1.000
T 30 BAN
1.000- 3/27/17
PR 52698 30 BAN 1.000
3/21/17 1.000
FYI - we have recently started an aggressive cycle counting program and
are
constantly running into these BAN and PAN locations, which have no
physical
location in the warehouse. Inaccurate or poorly labeled warehouse
locations, part identification, and shop order reporting issues so far
have
been the primary reasons for our count discrepanices. We want to clean
up
the locations both in BPCS and in the plant.
Thanks in advance for the assistance.
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.
------------------------------
message: 3
date: Thu, 27 Apr 2017 07:52:57 -0400 (EDT)
from: Norman Boyd <[email protected]>
subject: Re: [BPCS-L] Deleting an Inventory Location -- automate the
manual data entry pain
I have used Lickety-Split and as many of you know filling out a
spreadsheet with intended transactions is a little easier than manually
keying every one of those into the inventory transaction screen. Fewer
keystrokes if nothing else AND the ability to review the transactions as a
set.
Lickety-Split uses the native BPCS screens and records back into the
spreadsheet whether or not a transaction was successfully posted. If I
recall correctly, Milt please correct me if I'm wrong, it can record the
reason a transaction did not post. Even if it doesn't record the reason,
you can manually key a handful of FAILED transactions and see why they
failed. If you would hit the F13 key to override the error, you can go
back and program that into Lickety-Split and re-run the missed
transactions. Or, if you keyed something wrong and that's what's causing
the errors, fix the data in the spreadsheet, removing the successfully
processed records, then re-run the process.
My conclusion, if you have a LOT of transactions to manually key on a
regular basis, key them in a spreadsheet where you can review them for
accuracy then run Lickety-Split.
As a note - we've used Unbeaten Path for BPCS training and have several of
their software packages making the maintenance and some analysis of BPCS
MRP data easier.
Norman K. Boyd
MIS Administrator
Keihin Thermal Technology of America, Inc
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.
-----Original Message-----
From: BPCS-L [mailto:bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Rob Berendt
Sent: Wednesday, April 26, 2017 5:47 PM
To: BPCS ERP System
Subject: Re: [BPCS-L] Deleting an Inventory Location -- automate the
manual data entry pain
Nice plug, but wouldn't you have to key the data into Excel?
So, I can key the data into INV500 manually, with it's interactive edit
checks, or, I can key the data into Excel without any edit checks and then
pump it up with your software and then let the edit checks happen.
I can only see this being an advantage if I had some method of an
intelligent automated process which would dump out the necessary
corrections, convert that into Excel, and then pump it up with your
software.
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
From: "Milt Habeck" <[email protected]>
To: "BPCS user group" <bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
Date: 04/26/2017 05:43 PM
Subject: [BPCS-L] Deleting an Inventory Location -- automate the
manual data entry pain
Sent by: "BPCS-L" <bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]>
<vendor>
Dear Robert,
Replies from Mr. Bilgen and Al Mac confirm our conclusion that a
considerable amount of manually-entered inventory transaction activity
will
be needed to solve this.
There is no way within BPCS to prohibit the use of an active location by
specific items. So, it's necessary to deactivate your bad locations and to
do that, all inventory quantities will first have to be removed or moved.
The simplest method would be to remove or zero out invalid locations with
a
cycle count type of transaction, but that does not handle actual inventory
that may exist. So a better alternative would be to transfer any existing
inventory found in the bad/fictitious locations into valid locations.
Here's an idea to greatly reduce the pain of manually entering a high
volume
of transactions. Our Lickety-Split software transports rows of Excel data
into iSeries green screen apps (in this case INV500) as if it were being
keypunched. It's lightning fast with zero fat thumb errors .... and ....
all
the edit checking in the green screen application is still performed. It's
slick.
More information --->
<http://www.unbeatenpath.com/software/dataentry/Lickety-Split.pdf>
http://www.unbeatenpath.com/software/dataentry/Lickety-Split.pdf
Reference letter ---->
<http://www.unbeatenpath.com/references/away02stewart.pdf>
http://www.unbeatenpath.com/references/away02stewart.pdf
Automating the INV500 entry effort with Lickety-Split makes the inventory
clean-up extremely quick .... before more inventory arrives in the bad
location by accident.
Additional research may be needed to see what is causing your inventory to
get into the bad locations in the first place. If it is arriving from open
shop orders or allocations, those may also need to be taken care of before
locations can be deactivated.
Warmest regards,
Milt Habeck
Unbeaten Path International
[email protected]
(888) 874-8008
(+USA) 262-681-3151
www.unbeatenpath.com
</vendor>
From: B Bilgen
Sent: Sunday, April 23, 2017 8:06 AM
To: bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]
Robert, You can always run INV970 which will delete all records from the
lot, location, and container files (ILN, ILI, and YCI) that do not have
any
inventory and do not have any activity. However it doesn't sound like
that
is the activity you want to do. There is no system program available to
remove a single item from the location inventory - you will need to do
this
manually. Here are the steps that BPCS takes before removing records (in
INV970). It would be a good idea to follow the same edit checks for the
records you want to remove manually.
<snip>
From: Robert G. Hermann
Sent: Friday, April 21, 2017 12:44 PM
To: <mailto:BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]> BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: [BPCS-L] Deleting an Inventory Location
A manager at one of our plants sent me the question below. As far as I
know
the answer to his question is No, but I thought I'd ask the experts here
on
BPCS-L.
We are on BPCS 5.1.
(Unfortunately, we moved our headquarters to a new building a year ago and
were forced to ditch all hard-copy BPCS documentation prior to the move.)
Thanks in advance.
Best regards,
Bob Hermann
CertainTeed Corporation
=======
Is it possible to delete an inventory location in BPCS for an individual
part number? If so, please advise.
Background Info: We have numerous parts with multiple locations that are
no
longer used. We also have a couple of a couple of fictitious locations
(e.g., BAN and PAN) we want to get rid of. We think we know how to mass
delete location from the system, but all items have to be at zero qty. We
would like to remove the locations as we come across them for individual
items. An example is part number U35A02001. You can see from the
transactions below that we reported a shop order on 3/21 and then
transferred the inventory from BAN to FM0105 on 3/27. It would have
been
great at that time to the delete BAN as a location for this line item.
Trans Ref No Whse/Loc Quantity Date
Balance Lot
T 30 FM0105 1.000
3/27/17 1.000
T 30 BAN
1.000- 3/27/17
PR 52698 30 BAN 1.000
3/21/17 1.000
FYI - we have recently started an aggressive cycle counting program and
are
constantly running into these BAN and PAN locations, which have no
physical
location in the warehouse. Inaccurate or poorly labeled warehouse
locations, part identification, and shop order reporting issues so far
have
been the primary reasons for our count discrepanices. We want to clean
up
the locations both in BPCS and in the plant.
Thanks in advance for the assistance.
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.
------------------------------
Subject: Digest Footer
--
This is the BPCS ERP System (BPCS-L) digest list
To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.
------------------------------
End of BPCS-L Digest, Vol 15, Issue 25
**************************************
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.