Replies posted by hburke

14 Replies

M
MontyWilsonBrainy
asked in Kinetic & Epicor ERP

User Runs BAQ Via Dashboard And Exits Before It Finishes

Hey Good Morning Monty, the ultimate timeout can be dealt with at both the Epicor appserver level found in the Epicor Admin Console (EAC) and on the SQL server settlings. You’ll want to check both of those to pin down your expectations. there’s some good discussion on settings and other constraints for the query on EpicUsers.help about this issue as well.One key take away is that all BAQs should be tested as much as is possible, on a test and development server that is approximately equal to in load and processing power to the production server (easier said than done of course) but the testing protocol you develop will then catch more of these kinds of thing earlier, while in the dev cycle. Partial DBs are not enough, and you should always clone your system AND ensure the two environments are fully separated at a system config and server level… bad things happen on copied systems that are not “safed”. Fortunately, there is lots of guidance on that too. I Hopes this helps get you and th

1
H
11 months ago
tshoemaker
tshoemakerInspiring
posted in Kinetic & Epicor ERP

More than 50 votes on Epicor Ideas

Thanks Tim for posing these questions.  Absolutely a great approach.The crowd analytics approach is sound and I liked it a lot. I think that perhaps the limit of tokens or votes on a single topic could be adjusted.  To facilitate the users who absolutely NEED a feature more than any other is important to surface.  To recover those tokens only once the feature is completed might be useful.  They might be inclined to spend their whole ‘wallet of tokens’ on that feature’s promotion.  If 5 or 10 such users, from different companies, where to do so, it clearly represents a very strong need.The other end of the spectrum is more of the cafeteria version of selection, a little vote here and another there over many feature requests.  The volume there many come from a larger audience but with much less of a critical need.  It should be valued as well, but I would like to see the development approach follow a triage approach, setting priority by a couple of separate metrics - urgency as represent

3
tshoemaker
1 year ago
D
diannadamsNew Participant
asked in Americas - Northeast - CT, MA, ME, NH, RI, VT

Reprint labels and price tickets

Hi Diann,The fundamental issue is preserving all the data of a reprint without re-querying the database, which in many instances if always marching on.  I’m not aware of a specific built in feature that facilitates this.Alternatives, as you’ve pointed out are Bartender and its Reprint Console.  That’s possible because of its separate label focused database.  I do know that Epicor ECM (Docstar) does have the ability to catalog documents and freeze them in time and other data aspects so if you have that, perhaps it could be integrated with MES. Perhaps a bootleg approach would be to create a BPM that either captures the data that goes into each label and write that to a UD table with appropriate keys to uniquely find the record you want to reprint and re-render the reprint labels from that, or a BPM solution that perhaps saves out PDFs of the labels at print time and saving those out to a directory system that can be sought by the staff.  The issue with MES is that it is limited by desig

3
C
1 year ago
T
todd caugheyInspiring
asked in Medical Device and Pharamaceutical

Subcontract Alternate Part Questions

Not a scheduling expert, but the big question that comes to mind for me is how does MRP ‘know’ whether to build in-house or flip to the alternative supply option?  Where does its signal to determine this come from?  It seems like there needs to be an upstream ‘What-If’ step exploration by the Supply side staff first, based on new demand, available capacity and some logic considering lead times of internal vs external sourcing - resource utilization/capacity, subparts in inventory, delta on costs etc.Just the question and thoughts that came to mind,

1
H
1 year ago
I
iankInspiring
asked in Kinetic & Epicor ERP

EUG Website Webinar page

Here is a good synopsis on how to subdue Autoplay controls, on a browser by browser basis. https://www.wired.com/story/how-to-turn-off-autoplay-in-browser/Just friendly advice - I would STRONGLY suggest NOT adding any extension, if offered to you to simplify any browser config settings, rather just master your settings of your browsers.  Each has the controls you need with a just a bit of digging.  Extensions can be misleading at best and dangerous at worst.  Always read up on any extensions & explore what safety sites have to say first:(https://www.virustotal.com/gui/home/upload , https://www.bleepingcomputer.com/ , https://www.computerhope.com/),Read neutral reviews and user ratings at least before saying yes to anything that alters your browsers.  Safe browsing all!

10
mwilson
1 year ago
J
jfekkesKnown Participant
asked in Americas - Northeast - CT, MA, ME, NH, RI, VT

Security: Adding limitations to Users for use of Paste Insert Paste Update

I have not done this mind you, but if you haven’t done so yet, do a trace for the process in the app you want to limit that capability. I would do it for both more than one row and for a single row for both paste insert and paste update. include as much detail in the trace as you think you need.  But a pre-processing method directive should be able to prevent a users who are not in a particular security group(s) from doing that and if not allowed, pop a dialog letting them know it is restricted and how to petition if that would be appropriate, for being included in an allowed security group. The only issue is that I believe the single row updates would look no different than a normal user entry update or insert so what you seem to really want to do is prevent multiple row updating etc.  Another, probably less secure approach would be to hide or limit access to the list sheet entirely.  Hopefully users do not also have access to the DMT which would perform a similar function and might a

1
H
2 years ago
K
kcoteInspiring
posted in Americas - Northeast - CT, MA, ME, NH, RI, VT

NorthEast Regional Group Meeting - In-Person? 14 October

Hi Rick!I am looking forward to having a meeting and all the good ideas that are shared.  I hope this date of 10/14 works out.Henry

2
H
2 years ago
K
kcoteInspiring
asked in Americas - Northeast - CT, MA, ME, NH, RI, VT

Ready to Start Northeast EUG Meetings Again? Virtual or In-Person

Hi Keith,I have really missed the input, ideas, status updates and demos presented at our meetings. I am very happy and willing to attend meetings again.Thank you for considering our group gatherings anew.Henry BurkeRochester Electronics 

3
K
2 years ago
A
Anonymous
posted in Americas - Northeast - CT, MA, ME, NH, RI, VT

Warehouse Bin Label Printing

Also, Do you have bartender or not? You can set up a per OP line/ release receipt for each line.  I could show a number of ways to do these tasks.  Can you give me a sense of the volume and rate of each workflow?  Receipts vs populating the initial inventory? Feel free to give a call too if the email and posting approach is tedious.  1-603-781-6551 is my cell.  Best, Henry Burke  Sent via phone, please excuse brevity and grammar   ------

4
C
4 years ago
A
Anonymous
posted in Americas - Northeast - CT, MA, ME, NH, RI, VT

Warehouse Bin Label Printing

Hi Bill,When would you want to print them (at which transaction)?   Or is this an initial setup labeling effort for the warehouse?The approach could be different. But I'd be happy to help. ------------------------------Henry BurkeSenior Business AnalystRochester Electronics, Inc.Newburyport MA------------------------------

4
C
4 years ago
A
Anonymous
posted in Americas - Northeast - CT, MA, ME, NH, RI, VT

Anyone have a single database, multi-company & site setup for Epicor 10.2.400?

Hi Amy,Think of the DMT as a household Moving Company - DMT Movers, LLC.  They move the historical data you want to keep and the static data for GL, Parts, Customers, Suppliers and the like, based on the ever growing list of templates that the DMT can make and digest.  3 or 4 years ago, the DMT could probably handle half of the tables it now supports. Each version since has added features and table capabilities.  But there are things in your old system that you cannot directly export and import into a differently shaped system (house).  So editing the records would be done in something like Excel etc where you would find and replace various references that needed to be changed.  There are also things you'd like to move yourself by hand - precious things antiques and core system settings like the chart of accounts or printer and email or MRP settings.  That is what you are working on first in PILOT, then copy over into TEST, prior to loading history or all current base info.  Short answ

7
H
4 years ago
A
Anonymous
posted in Americas - Northeast - CT, MA, ME, NH, RI, VT

Anyone have a single database, multi-company & site setup for Epicor 10.2.400?

Best approach is start with your PILOT DB, get an inter-disciplinary ( from your departments and divisions) with an approapriate charter, goals, empowerments, and resources (TIME and perhaps temps to provide the relief) and start meeting to walk through the Implementation Checklist which you can find inside Epicor itself in the Help system.  Just search for "Implementation Checklist".   Another key area is the Company, Site and departments configuration.  Key point - The Pilot DB never gets transacted in!  You instead copy into a TEST DB and load a small but appropriately diverse and matching dataset from your current environments lets say through BAQ extracts and DMT loads.  In the BAQ, If you use the columns of tables in their natural order, they generally match the order of the DMT templates, and if you use the DMT field names as the BAQ column labels, you will have that part dialed in.  The pilot system gets set up slowly, through discussions on features that need to be leveraged. 

7
H
4 years ago
A
Anonymous
posted in Americas - Northeast - CT, MA, ME, NH, RI, VT

Anyone have a single database, multi-company & site setup for Epicor 10.2.400?

I agree with Andris,DMT is the way to go - very deliberate, a very methodical method of building out a system, thru single table spread sheets.  By saving the various files (tables) out into Excel sheets, thru SQL or BAQ queries, and saving in a well versioned folder system, you can mature each kind of data, from Customer and Supplier info, Quotes/Sales orders,thru the whole manufacturing cycle, quality records, lot info etc.  Understanding the parent and child keys and the overall organizational structure is critically important because you will be altering some columns and relationships if really merging divisions back into the main company while preserving plant associations to those divisions (perhaps sites), preserving differing part masters, lot data, warehouses and inventory, user access rights by sites and plants etc.Fun stuff though, no doubt about it. Best wishes in this effort!------------------------------Henry BurkeSenior Business AnalystRochester Electronics, Inc.Newburyp

7
H
4 years ago
A
Anonymous
posted in Americas - Northeast - CT, MA, ME, NH, RI, VT

Barcode Software Inquiry/Suggestions

Hi Cristina!  Couple of questions that come to mind on this topic, that you may want to share to the group as well.  What are your project goals at a high level?  What are the environmental considerations - surfaces - paper, products, packaging, metal surfaces,What's the lifecycle-how long do BCs (barcodes) need to last, durability, timing(s) for applying labels and workflows of users. What is the data being encoded - lots of data or just a reference/key field to a database record etc? How large or what volume of BC generation do you need?  And at least a question for yourself rather than this group, what's your level of funding for the project so that you can make cost effective decisions.on the ideas and leads given.  Just some thoughts to stimulate discussion.Best,Henry------------------------------Henry BurkeSenior Business AnalystRochester Electronics, Inc.Newburyport MA------------------------------

3
A
5 years ago
Terms & Conditions