Replies posted by todd caughey

53 Replies

T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Kinetic 2023.1.5 - BAQ Designer

Thanks, worked like a charm!  I did not realize that setting was available.-Todd 

2
T
10 months ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Add Existing BAQ as a Subquery

Thanks David but it is giving me grief about my EpicCare login email address.  I am logged in to EpicCare the usual way which works fine.  Both in Chrome and Edge.  I will try searching EpicCare.-Todd 

5
T
11 months ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Change Log - UserID Field Rules

I am giving up on this.  I added the DateStampedOn field in the display and sorted Ascending in the results.  All entries before 7/23/2021 have blank UserID.  After that date the ALL have UserID.  Not sure what happened on that date.  I am guessing it may have been when a bug was fixed in a release patch.  We don’t care about the old stuff so I will ignore this.  Thanks Sue for the suggestions. 

4
mwilson
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Change Log - UserID Field Rules

This (Ice.ChgLog) is exactly where I am running a test BAQ for and reveled it had blank UserIDs. It is a very simple dump from ChgLog with one criteria - TableName = JobMtl.  That’s it.  It shows: Key1 being the JobNum.  There does not seem to be a relation to whether it is a New Record (from Log Text) and when UserID is blank so that is the mystery.-Todd 

4
mwilson
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Add Table Field to RDD

I just saw the previous replies.  Thank you both because if I had to found it these would have saved me a lot of time and grief. 

4
T
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Add Table Field to RDD

Never mind.  I found it under the Dataset properties in RB and modified the expression there to add EntryPerson.  The report is working as needed now.-Todd C.

4
T
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

AutoUpdate - Local File Header is Corrupt

Based on feedback from other people who have had this I tried repeatedly opening Epicor and each time it seemed to get a little farther before the error.  Eventually after 15-20 attempts it ran all the way and I was able to get in to Epicor.-Todd 

1
T
1 year ago
J
JoeHNew Participant
posted in Americas - Midwest - IL, KS, ND, NE, SD

6.1 -> Kinetic

First off the differences from 6.1 to E11/Kinetic are massive - regardless of on-prem or cloud.  My 2 cents… re-implement from scratch and use the opportunity to clean out old transactions, re-allign all master tables - including the transition to the “resources” concept.  Dump master tables to Excel, revise as needed and DMT them into the new instance.  Then complete old jobs/orders/etc.. on 6.1 and manually add new, open, transactions to Kinetic version.  You will never have a better chance to clean house.As for on-prem or cloud, I’ve been dealing with Cloud for a bit over a year now and some things I had not thought about are glaringly apparent.  Mainly get used to going to Cloud Support (CS) for everything Admin related.  Like:Adding UD fields and tables requires CS to update the schema(s). No access at all to SQL Server Re-populating Pilot or Test databases requires CS to do (but the are very responsive!) Writing data to external locations (like FTP sites) will be a struggle - if

6
P
1 year ago
L
lairdlKnown Participant
asked in Kinetic & Epicor ERP

Epicor forcing everyone to the cloud?

I find the move to force Kinetic more of an issue than Cloud.  Everyone I work with is 100% adamant that they completely dislike the Kinetic interface.  It is ugly, unreadable, hard to navigate, and a barrier to productive use of Epicor.  I can’t count the number of times people have asked to get rid of the nag message to try the new interface that shows at the top of most screens.  Nobody likes it or will use it. The few screens that are forced to be Kinetic (mostly print dialog screens) are really painful and I get a lot of complaints.  IMHO I say don’t force it unless you fix it. 

7
P
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

BAQ Error Question - Bad SQL statement

We finally resolved this on Friday.  In the TopLevel subquery there was only one display field that was a concatenation of all the fields for the tab delimited output.  What we had not noticed was that in the actual subquery where the linking and criteria were happening some of the output fields from that were numeric fields so when passed to the top level they were not compatible with string functions.  We created calculated fields to convert everyone of them to string (nvarchar), used those to merge and the error went away - the output looked great too.The cloud support involvement for error messages like this still bugs me but they seemed to be pretty responsive and now we know where to go to get details.-Todd 

8
A
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

BAQ Error Question - Bad SQL statement

OK, I found out that in order to get the details of the Error Log  we must open a Cloud Support case.  Just one more thing out of our hands.  The initial response from regular support was:yes unfortunately there isn't a way for cloud customers to see the log file, we'll need to create a cloud task to get the full error in the log.They did the cloud task (pretty quickly too) and we got the response:Conversion failed when converting the varchar value '‚' to data type int.So we are now trying to track this down in the BAQ.  The only conversions we can see are two Date to Text - Convert(nvarchar, PartTran_SysDate, 101) where 101 is mm/dd/yyyy format - the default.  But we are not understanding the ‘,’ to int part.  No divides by zero or other issues like that (thanks ssearle) .  But the main take away is that in the Cloud there is a barrier to getting error log info.  It would be nice if there was an interface option for Cloud sites to enter some selected reference info (BAQ name, time win

8
A
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

BAQ Error Question - Bad SQL statement

 I typoed the Char(7) that should have been Char(9) for Horizontal Tab.  Fixed with no effect.  Where are the server logs.  I have no access to SQL in the Cloud.  Do I have to request a log file from Cloud Support?Thanks,-Todd 

8
A
1 year ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

BAQ Subquery Join

The one I am working on currently shows:The TopLevel query was renamed TopLevel.I have seen strange things in BAQ Designer many times and usually need to exit Epicor and go back in to BAQs from scratch and open the BAQ.  Usually resolves it without rebooting but there is that too.  Or try Options - Clear Client Cache sometimes does it.-Todd 

4
D
1 year ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

BAQ Subquery Join

What type is the SubQuery?  Most of our are InnerSubQuery - implying a join I think.-Todd 

4
D
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

2022.1 Cloud Upgrade - Broke CADLink from Epicor Partner QBuild

I have been informed by the manager at the corporate level who handles the QBuild relationship that he had received the following from QBuild about the latest incident:We do get advanced notice from Epicor to test out CADLink compatibility against the latest version they're releasing.This particular release required more changes to CADLink than expected, and especially with your CADLink installer being customized, it required a longer lead time than usual.We're working with our senior developers as well as Epicor to ensure enough time and resources are allocated for future releases.Thank you for your patience and apologies for the inconvenience.Yes, they are responsive.  Hopefully the incident was a one-off occurrence.-Todd 

6
B
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

2022.1 Cloud Upgrade - Broke CADLink from Epicor Partner QBuild

The main point is that as a SaaS site we have no control over updates.  We are not in the driver’s seat for planning.  I know where to look for updates that are scheduled by Epicor but they only have a date and sometimes an estimate of how long it might not be available.  No details at all about what is being updated, what the new version\release\patch level might be.  We might have had more concern if I had been able to see it was going to 2022.1 since that, in my mind, would indicate a major update.  We can’t even preview in our Pilot instance since it all happens at once.  I know CADLink is difficult to switch back and forth which instance to use.  I believe it does not use a config file where separate connections could be made.  All our databases get converted with new schemas at the same time.I suspect the root of the issue is lack of communication between Epicor and QBuild.  As an Epicor  partner we would expect QBuild to be informed about pending releases - especially in Cloud s

6
B
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

BAQ Selection Based on File to Table Content

Not updatable.  Just for analysis.  If a lot of changes will be needed they will be done via DMT.Owner of the BAQ did not like the dummy PO idea and wants to create a Generic multiple selection UD table that can work in any situation.  So he wants to create a form for the UD table with a list grid there.  So, I am researching making forms for UD tables.  Should be an interesting learning curve.  One way or another we have a path forward.  Thanks to all for the suggestions.-Todd

8
T
2 years ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

BAQ Selection Based on File to Table Content

The intent is to feed a BAQ that reports on Supplier prices, in both PUM and IUM units, for analysis.  I did not write the  BAQ but it is working and currently prompts for one Part Number.  The user has lists of hundreds of similar parts from various suppliers at a time to do the analysis on and validate the supplier pricing.I have offered the developer of the BAQ a possible solution.  Create a dummy PO and paste lines into the List grid that include the part number.  Any other required columns can be dummy data since the PO will never be processed.  Then make PODetail (with the dummy PO# as a criteria) the top table in the BAQ and link Part to it.  Reuse the dummy PO as needed overwriting the lines.  I think this should be doable fairly quickly.-Todd 

8
T
2 years ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

BAQ Selection Based on File to Table Content

Thanks, Joe.  Wow, just how much can you paste into a parameter?  Never thought to push the limit on that.  Could easily be 5-6K characters.  I would expect a limit around 32,768 at most.  We will give it a try.  Worst case back to trying DMT to a UD table.-Todd 

8
T
2 years ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Cloud Menu Security

Logged a new case - waiting for response.  I did a BAQ and see that there are 10 or so menu items “owned” by the company.  No surprise these are the only ten I can make changes to.  Seems to be some sort of deadly embrace where the presence of these 10 prevents the Copy Security to the rest of the menu items.  I think this is leftover garbage from the cloud conversion a year or so ago.  Not sure how to blow away the 10 items and start fresh.

7
L
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Cloud Menu Security

Got a KB article from Epicor to confirm the copy process but when I try it I get a Business Logic Error:Target Security row does already existNot sure what this is telling me but it is not what I expected at all.  Also not sure if it matters that I am trying it in our Pilot database and not Live.  I might need to re-open the previous case or make a new one.-Todd  

7
L
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Cloud Menu Security

I messed with the company copy once before and got it very broken.  But that was while trying to resolve another issue where Material Requirements Planning was missing General Operations.  This was a know issue when moving to SaaS and Epicor was able to fix it.  I will try the copy it in our Pilot (now Test) database.  Thanks for the tips.-Todd

7
L
1 year ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

PO Deposit/Downpayment

Resolved!  They were not aware of how Advance Payments work and they have tested things all the way through the process (with help from the User Guide) and confirmed it is doing what they want.  So no more “Epicor is broken” on this issue. 

1
T
2 years ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Conditional epiShape via Wizard

That’s what I suggested but they did not want to have to remember to turn it off.  I’m deep into the Kinetic tools guide to see what I might be missing in the highlighting rule.

4
G
2 years ago
T
todd caugheyInspiring
asked in Kinetic & Epicor ERP

Conditional epiShape via Wizard

I can’t even do a simple Rule Wizard to highlight the Inspection Required checkbox in yellow.  The hang-up there is in defining the condition for the checkbox field.  I have tried: TRUE, True, true, and 1 but no affect on the the box.  I think I am missing something.  

4
G
2 years ago
Terms & Conditions