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