Re: Deleting an Inventory Location -- automate the manual data entry pain

I suppose, as the list moderator, if I approve one vendor's post for 
something which is only slightly tangential to the original poster's 
question, then it would be bad form of me to disallow another vendor 
offering their "me too" solution.


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:   Richard Schoen <[email protected]>
To:     "bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]" <bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
Date:   04/28/2017 09:51 AM
Subject:        Re: [BPCS-L] Deleting an Inventory Location -- automate 
the manual      data entry      pain
Sent by:        "BPCS-L" <bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]>



Rob you've just described what RPA or Robotic Process Automation 
technology can do. 

The term is new to describe the type of edge automation tasks you can 
accomplish without changing existing app code.

Check out our Automate product to learn more
http://www.helpsystems.com/automate

You can script Excel entry, validation, reformatting and logging efforts 
all into an automated task. 

You can upload/download, validate, call CL and RPG programs as well as 
script 5250, Web and Windows interactivity if needed. 

If you want to do a little POC review send me a scenario and I'm happy to 
demo some concepts as well. 

If you google it, RPA is all the buzz for automating mind numbing daily 
tasks and it works well.

Regards,

Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-486-6802
RJS Software Systems | A Division of HelpSystems
[email protected] 
www.rjssoftware.com
Visit me on: Twitter | LinkedIn

------------------------------

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

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