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

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.


Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-486-6802
RJS Software Systems | A Division of HelpSystems
Visit me on: Twitter | LinkedIn


message: 2
date: Wed, 26 Apr 2017 17:46:59 -0400
from: Rob Berendt <rob@xxxxxxxxx>
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

From: "Milt Habeck" <mhabeck@xxxxxxxxxx>
To: "BPCS user group" <bpcs-l@xxxxxxxxxxxx>
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@xxxxxxxxxxxx>


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 ....
the edit checking in the green screen application is still performed. It's slick.

More information --->

Reference letter ---->

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

(888) 874-8008
(+USA) 262-681-3151

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.