Hi Bonnie,
I haven't used the LX connectors in a while and I am not sure if they are
still available but I remember being able to create, edit and delete single
or multiple master file records using a spreadsheet.
Regards,
____________________________________________________________________________
_____
Franck Guillet | Sr. Principal ERP/EDI Consultant | Office: 773-634-9400 |
Cell: 773-610-7375
Skype ID: franckg33 | franckguillet@xxxxxxxxxxxxxxxxxxxxxxx |
www.erpsoftwareservices.com | www.linkedin.com/in/franckguillet
-----Original Message-----
From: BPCS-L <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
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
