Hi Bonnie,
About 6 years ago, we started down the path of implementing Infor's 'Workflow for System i' (WFi) product to gather input for LX master data from the designated staff (I believe this product came with our Infor upgrade-to-LX package). We did not get very far with it; but in all fairness we didn't spent much time on it. I believe WFi works w/ a combination of Webtop, Workspace, and LX exit points (we still use mostly 5250 screens) ... Not sure if WFi is still an option, but may be worth a call or some web searches ... FYI.
DeeDee Virgei
Stanley Black & Decker
-----Original Message-----
From: BPCS-L [mailto:bpcs-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Bonnie Bryant
Sent: Tuesday, July 30, 2019 1:52 PM
To: bpcs-l@xxxxxxxxxxxxxxxxxx
Subject: Re: [BPCS-L] BPCS-L Digest, Vol 17, Issue 43
***CAUTION: EXTERNAL MESSAGE***
Thanks everyone
I've used the spreadsheet loading tools in the past. They are great for mass loading.
We're looking more for a 'one-off' interactive tool to be used if/when a new item is added that will segregate the data owners and allow us to manage progress.
Considered IDF and still may try that route.
Hoping to find a 'ready-made' interactive tool.
Really appreciate all the feedback
b
-----Original Message-----
From: BPCS-L <bpcs-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of bpcs-l-request@xxxxxxxxxxxxxxxxxx
Sent: Tuesday, July 30, 2019 11:26 AM
To: bpcs-l@xxxxxxxxxxxxxxxxxx
Subject: BPCS-L Digest, Vol 17, Issue 43
Send BPCS-L mailing list submissions to
bpcs-l@xxxxxxxxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
bpcs-l-request@xxxxxxxxxxxxxxxxxx
You can reach the person managing the list at
bpcs-l-owner@xxxxxxxxxxxxxxxxxx
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. Front End for load of Item Master data (Bonnie Bryant)
2. Re: Front End for load of Item Master data (Rob Berendt)
3. Re: Front End for load of Item Master data (Schemmel, Jason)
4. Re: Front End for load of Item Master data (Larenzo Alexander)
5. Re: Front End for load of Item Master data (Debra Ivey)
6. Front End for load of Item Master data / Excel-based solution
(Milt Habeck)
----------------------------------------------------------------------
message: 1
date: Tue, 30 Jul 2019 07:49:54 -0500
from: "Bonnie Bryant" <BonnieBryant@xxxxxxxxxxxxxxxxx>
subject: [BPCS-L] Front End for load of Item Master data
Looking for a front end package that will interface into ERPLX to build item master, facility master, etc.
Preferably something configurable with screen and/or field level security.
Bonnie D. Bryant
GCD Consulting LLC
BPCS/ERPLX Project Management
CEF/SCM/MMM Consulting
<mailto:bonniebryant@xxxxxxxxxxxxxxxxx> bonniebryant@xxxxxxxxxxxxxxxxx
Office: 601-825-3887
Cell: 601-259-0964
------------------------------
message: 2
date: Tue, 30 Jul 2019 12:59:17 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: Re: [BPCS-L] Front End for load of Item Master data
I wasn't involved in the project but we did use this product to help minimize regular LX screens to fit just the fields we needed on the small
5250 screens on hand held scanners.
http://www.nutechsystems.com/erp-solutions/
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
-----Original Message-----
From: BPCS-L <bpcs-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bonnie Bryant
Sent: Tuesday, July 30, 2019 8:50 AM
To: bpcs-l@xxxxxxxxxxxxxxxxxx
Subject: [BPCS-L] Front End for load of Item Master data
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Looking for a front end package that will interface into ERPLX to build item master, facility master, etc.
Preferably something configurable with screen and/or field level security.
Bonnie D. Bryant
GCD Consulting LLC
BPCS/ERPLX Project Management
CEF/SCM/MMM Consulting
<mailto:bonniebryant@xxxxxxxxxxxxxxxxx> bonniebryant@xxxxxxxxxxxxxxxxx
Office: 601-825-3887
Cell: 601-259-0964
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email:
BPCS-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/bpcs-l.
------------------------------
message: 3
date: Tue, 30 Jul 2019 13:37:46 +0000
from: "Schemmel, Jason" <jason.schemmel@xxxxxxxxxx>
subject: Re: [BPCS-L] Front End for load of Item Master data
I know of a tool that uses data from Excel to run thru BPCS screens. It actually uses the BPCS screens so any existing BPCS security is applied.
-----Original Message-----
From: BPCS-L <bpcs-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bonnie Bryant
Sent: Tuesday, July 30, 2019 8:50 AM
To: bpcs-l@xxxxxxxxxxxxxxxxxx
Subject: [BPCS-L] Front End for load of Item Master data
Looking for a front end package that will interface into ERPLX to build item master, facility master, etc.
Preferably something configurable with screen and/or field level security.
Bonnie D. Bryant
GCD Consulting LLC
BPCS/ERPLX Project Management
CEF/SCM/MMM Consulting
<mailto:bonniebryant@xxxxxxxxxxxxxxxxx> bonniebryant@xxxxxxxxxxxxxxxxx
Office: 601-825-3887
Cell: 601-259-0964
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email:
BPCS-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midr
ange.com%2Fmailman%2Flistinfo%2Fbpcs-l&data=01%7C01%7Cjason.schemmel%40e
cintl.com%7C1980f72ab33742d18ffb08d714ec6edb%7C1f36cca2117d4fb5b33ee11af89a7
343%7C1&sdata=tAxUZUbmIOnkTFwpm1L%2Bkd8P8Wx7NJkPK7b8I9Xr8O4%3D&reser
ved=0
or email: BPCS-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.mi
drange.com%2Fbpcs-l&data=01%7C01%7Cjason.schemmel%40ecintl.com%7C1980f72
ab33742d18ffb08d714ec6edb%7C1f36cca2117d4fb5b33ee11af89a7343%7C1&sdata=N
CUnG6xewCuwEH5r1r29gQLUdK%2FmB7OxO98qf2%2FFRIg%3D&reserved=0.
--Scanned by Microsoft Exchange Online Protection
------------------------------
message: 4
date: Tue, 30 Jul 2019 13:21:25 +0000
from: Larenzo Alexander <Larenzo.Alexander@xxxxxxx>
subject: Re: [BPCS-L] Front End for load of Item Master data
https://www.profoundlogic.com/
-----Original Message-----
From: BPCS-L [mailto:bpcs-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Bonnie Bryant
Sent: Tuesday, July 30, 2019 8:50 AM
To: bpcs-l@xxxxxxxxxxxxxxxxxx
Subject: [BPCS-L] Front End for load of Item Master data
CAUTION! This email originated from outside of the organization. Please do not open attachments or click on links from an unknown or suspicious origin.
Looking for a front end package that will interface into ERPLX to build item master, facility master, etc.
Preferably something configurable with screen and/or field level security.
Bonnie D. Bryant
GCD Consulting LLC
BPCS/ERPLX Project Management
CEF/SCM/MMM Consulting
<mailto:bonniebryant@xxxxxxxxxxxxxxxxx> bonniebryant@xxxxxxxxxxxxxxxxx
Office: 601-825-3887
Cell: 601-259-0964
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email:
BPCS-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/bpcs-l.
------------------------------
message: 5
date: Tue, 30 Jul 2019 14:01:21 +0000
from: Debra Ivey <divey@xxxxxxxxxxx>
subject: Re: [BPCS-L] Front End for load of Item Master data
For any who don't already know, LX 8.4 has an IDF front end for loading some of the master files (item, customer, vendor & cost masters) and they will be expanding the included master files in future releases. IDF provides lots of configurability and security options.
Admittedly, this doesn't provide any help for an older release but is something to keep in mind before investing a lot of time and money in another solution if an upgrade could be on the horizon.
____________________________________________________________________
Debra Ivey | ERP Solutions Delivery Manager | Red Gold
1500 Tomato Country Way | P.O. Box 83 | Elwood, IN 46036 Tel 1480 divey@xxxxxxxxxxx | www.RedGoldFoods.com
-----Original Message-----
From: BPCS-L <bpcs-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bonnie Bryant
Sent: Tuesday, July 30, 2019 8:50 AM
To: bpcs-l@xxxxxxxxxxxxxxxxxx
Subject: [BPCS-L] Front End for load of Item Master data
Looking for a front end package that will interface into ERPLX to build item master, facility master, etc.
Preferably something configurable with screen and/or field level security.
Bonnie D. Bryant
GCD Consulting LLC
BPCS/ERPLX Project Management
CEF/SCM/MMM Consulting
<mailto:bonniebryant@xxxxxxxxxxxxxxxxx> bonniebryant@xxxxxxxxxxxxxxxxx
Office: 601-825-3887
Cell: 601-259-0964
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email:
BPCS-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/bpcs-l.
Red Gold Employees, please click
https://www.mailcontrol.com/sr/kOKH_qoSzW7GX2PQPOmvUgaWRRZ0Q5_IHDnGxMW0Zanwg
ylflXKopdqO_sdPnOYCBRNCbwJh6pH46EHnGWFGZQ== to report this email as spam.
------------------------------
message: 6
date: Tue, 30 Jul 2019 10:36:32 -0500
from: "Milt Habeck" <mhabeck@xxxxxxxxxx>
subject: [BPCS-L] Front End for load of Item Master data / Excel-based
solution
< vendor >
Lickety-Split software transports Excel spreadsheet data into BPCS/ERP LX screens:
http://www.unbeatenpath.com/software/dataentry/Lickety-Split.pdf
The data load process is performed by interactively executing the green screen program that would otherwise be employed to manually keypunch that same data. Therefore, the same security enforced by the BPCS program is automatically observed by Lickety-Split.
Edit checking in the BPCS program is also performed. If an edit check error is found on any record in the Excel spreadsheet, Lickety-Split captures the error message displayed on the green screen and writes it into the spreadsheet on that row. It then skips the problem row and continues to subsequent rows of the spreadsheet.
After the upload is done, you can search the Excel spreadsheet for error messages, fix the problems, and then re-transport those fixed rows back up into BPCS/ERP LX.
You can apply it to upload an entire database or you can use it to maintain a database or do things like upload cycle counts or standard cost updates.
It even allows header/detail type uploads.
It's lightning fast. People who see the demo say "it's slick."
This is the tool Jason Schemmel referred to in his note earlier this morning.
Peace to you,
Milt Habeck
Managing Partner
Unbeaten Path International
mhabeck@xxxxxxxxxx
(+USA) 262-681-3151
www.unbeatenpath.com
</vendor>
From: BPCS-L [mailto:bpcs-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Bonnie Bryant
Sent: Tuesday, July 30, 2019 7:50 AM
To: bpcs-l@xxxxxxxxxxxxxxxxxx
Subject: [BPCS-L] Front End for load of Item Master data
Looking for a front end package that will interface into ERPLX to build item
master, facility master, etc.
Preferably something configurable with screen and/or field level security.
Bonnie D. Bryant
GCD Consulting LLC
BPCS/ERPLX Project Management
CEF/SCM/MMM Consulting
Office: 601-825-3887
Cell: 601-259-0964
------------------------------
Subject: Digest Footer
--
This is the BPCS ERP System (BPCS-L) digest list To post a message email: BPCS-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/bpcs-l.
------------------------------
End of BPCS-L Digest, Vol 17, Issue 43
**************************************
midrange.com
