Hi Bonnie ....

Sometimes the practical approach is to use multiple tools together ... you
know, simultaneously use the oven, stove top and microwave to cook
Thanksgiving dinner.

The Lickety-Split spreadsheet transport tool is definitely not a work-flow
product. But, you can design a specific script for each department for only
those fields in the item master which should be maintained by that
department. So, Engineering has a spreadsheet for only those fields that
they should manage and the Lickety-Split script that runs that particular
engineering-pertinent spreadsheet is password controlled to only work for
Mr./Ms. Engineer Jones. Ditto for Cost Accounting, etc.

You can even script Lickety-Split to perform an automatic edit check of
every existing record in a master file. That's an A+ internal control

Now, if you want to observe/verify completion of the work on a new item for
all contributing departments, you could employ Stitch-in-Time software.
http://www.unbeatenpath.com/software/sit/Stitch-in-Time.pdf A report from
Stitch could be designed to report changes for fields that fall within the
corners each department's authority for a specific item(s).

Stitch reports could also be designed to report if a field change is somehow
squeezed into the master file by a user who is not defined within Stitch to
have authority to change that field. It's an after-the-fact control but
auditors vote for that as much better than never finding out that a
production planner accidently changed a cost field. That's a more economical
approach than re-writing the item master file maintenance program to address
only a sub-set of panel(s) for each involved department. Stitch sees every
change, including DBUs and Queries, etc.

God bless,
(+USA) 262-681-3151

< /vendor >

From: Bonnie Bryant
Sent: Tuesday, July 30, 2019 12: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
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

From: Milt Habeck [mailto:mhabeck@xxxxxxxxxx]
Sent: Tuesday, July 30, 2019 10:37 AM
To: 'BPCS ERP System'
Subject: Front End for load of Item Master data / Excel-based solution

< vendor >

Lickety-Split software transports Excel spreadsheet data into BPCS/ERP LX

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

Peace to you,
Milt Habeck
Managing Partner
Unbeaten Path International
(+USA) 262-681-3151


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

master, facility master, etc.

Preferably something configurable with screen and/or field level

Bonnie D. Bryant

GCD Consulting LLC

BPCS/ERPLX Project Management

CEF/SCM/MMM Consulting

Office: 601-825-3887

Cell: 601-259-0964

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-2022 by midrange.com 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.