Topics started by kstinnett

12 Topics

K
kstinnettInspiring
asked in Kinetic & Epicor ERP

Material Burden Calculating Incorrectly on Worksheet

Worksheet Calculating Material Burden IncorrectlyMaterial Unit Cost. 5.04Mtl Burden Rate 15%Mtl Burden Unit Cost = .756This shows correctly on the Manufacturing Tab under materialsGo to the worksheet and it shows this for 500 units$37.80 which should be .756 x 500 which equals 378.Print out of the worksheet with details shows the Mtl Burden Unit cost to be .0756 which moves the decimal to make it $37.80Is there something I am missing. Is this an Epicor Issue?

0
K
1 year ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

CapEx Projects

Looking for best practices and/or suggestions for Tracking Capital Expense Projects.

2
J
1 year ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

BAQ's, Reports, etc.

In many of the threads I see comments that indicate there is(was) some type of repository for users to upload/download BAQ’s, Reports, etc. Is that still the case? If so where is it located. I have not been able to find anything and the links that I have seen are broken.

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

Trackers - Exporting to Excel

Is there a trick to getting all rows to export to Excel (specifically Part Tracker but probably all trackers) in the new Kinetic view. When opening Part Tracker Export to Excel only exports the first 100 or so rows. You have to scroll down until all the rows have been populated on the screen before this works. It isn't a big deal but it does takes more time than is necessary. 

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

SSRS Bar Code Font with Zebra Printer

I created a SSRS Report with Dataworks 39 Font for the bar code. It prints correctly on a normal printer but when printing to Zebra Printer the bar code comes out blurry and is not scannable. Any direction on fixing this issue would be greatly appreciated.  I did search the site but didn’t come up with anything relevant. Could have missed it though,

3
T
1 year ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

Updatable BAQ Ship to Country

Apparently during original data entry no one entered the Country in the Ship To table. I have created a Updatable BAQ but when I update a record to USA for the country I get the following error.Country references Invalid Value.Also, I have 5494 records to update. Is there anyway to update them all at once instead of one at a time. I am on the cloud so I can’t do it on the back end.

7
K
1 year ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

Tablets (Handhelds) Epicor MES

Looking for any recommendations on what people are using for Tablets on the Shop Floor. Pros and Cons and what should I be looking for.

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

Row Numbering SSRS

I have a group in SSRS with a detail line. I want to number each row but every expression I have tried only returns 1 for every row instead of 1,2 ,3, etc on each row. Any one have any suggestions on how to achieve the correct result.

3
K
1 year ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

Calculated Field in Report Data Data Definition (Quote Form)

I am trying to add the Payment Terms to the quote header on the Quote Form. There is a calculated field in tthe RDD but it doesn’t show up in SSRS. I added the field in the query and added the field in the field list. However, it just comes back blank. How do I even know what the Terms Desc field in the RDD is pointing to in the Calculated Field.

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

Production Detail Report

Shouldn’t the difference between the Standard Cost and Actual Cost be the amount of MFG-Variance in the WIP/Reconciliation Report. I have ran several Production Detail Reports and then ran the WIP/Reconciliation Report just for each individual job. I can not figure out the MFG Variance is being calculated on the WIP/Reconciliation report. I read through another post that Monty had commented on that there were some BAQ’s he had written but I have not been able to figure out where those are and if they are still on this site.

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

Business Process for Invoice Not Matching PO

I am fairly new to Epicor  and Job Shops (more familiar with process manufacturing)so I don't know all the ins and outs. This is my situation. Job ShopPO is entered and tied to a specific JobMaterial is ReceivedInvoice comes in and is a different price than the PO. Current Business process is that the Invoice has to match PO. Purchasing Department goes in and changes PO price to match invoice. I think it should be left alone and let it go to PPV. Does the PPV get tied to the job that the PO was tied to?The biggest issue is when the PO is received in one period and they don’t get the invoice until the next period. Looking for the best way to handle this type of scenario in Epicor.

2
P
1 year ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

BAQ Subquery Join

I have created a Toplevel query and a sub query. However, when I go to drag the subquery on the board to join with the Toplevel query no sub query’s show up when I click the sub query button. Anyone have any ideas? Thanks in advance 

4
D
1 year ago
Terms & Conditions