Front End for load of Item Master data / Excel-based solution
"Milt Habeck" <[email protected]> Tue, 30 Jul 2019 10:36:32 -0500
| Newsgroups | gmane.comp.systems.as400.bpcs |
|---|---|
| Message-ID | <[email protected]> |
< 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 [email protected] (+USA) 262-681-3151 www.unbeatenpath.com </vendor> From: BPCS-L [mailto:[email protected]] On Behalf Of Bonnie Bryant Sent: Tuesday, July 30, 2019 7:50 AM To: [email protected] 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 -- This is the BPCS ERP System (BPCS-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/bpcs-l or email: [email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/bpcs-l.