Replies posted by david.hite

10 Replies

D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Add gross weight to materials on Job Traveler

I have done that and I cannot seem to get the subreport to run correctly when I join the following.   Below is the SQL from the dynamic dataset… ="SELECT T1.JobNum,T1.Calc_MultiJobParts, T2.AssemblySeq,T2.BackFlush,T2.Company,T2.[Description],T2.IssuedComplete,T2.IssuedQty,T2.IUM,T2.JobNum as JobMtl_JobNum,T2.MfgComment,T2.MtlSeq,T2.Ordered,T2.PartNum,T2.RelatedOperation,T2.RequiredQty,T2.WarehouseCode,T2.Calc_BCMtlSeq,T2.Calc_BCPartNum,T2.JobNum_PartDescription, T3.PartNum as TTJobPartMtl_PartNum, T2.Calc_InventoryQty, T2.Calc_InventoryUOM, T2.Calc_AttributeSetShortDescription, T2.RevisionNum, T4.GrossWeight FROM JobHead_" + Parameters!TableGuid.Value + " T1 LEFT OUTER JOIN JobMtl_" + Parameters!TableGuid.Value + " T2  ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum LEFT OUTER JOIN TTJobPartMtl_" + Parameters!TableGuid.Value + " T3  ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.MtlSeq = T3.MtlSeq LEFT OUTER JOIN Part_ " + Parameters!TableGuid.Value + " T4  ON T4.Com

3
fred
1 year ago
J
JoeHNew Participant
asked in Kinetic & Epicor ERP

Positive Pay in Kinetic

I have my own utility that I wrote for accounting to export to our bank for positive pay.

6
P
1 year ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Set QOH to 1

They are not Serial or lot tracked and are all in the same locations.   Not a bad suggestion, just wish I could do it in a simple step.   I will see if I can attempt that.   Thanks for the feedback and I welcome any other suggestions you have!  

9
G
2 years ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

The best way to claim the same operations on a list of jobs?

Okay, I will take a look at that this process.  Do you have any instructions or examples on how to use that.  I have not used that module before.  Thanks for the advice.

2
D
2 years ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Aged Parts Removal

There is a Slow Moving Stock Report in Inventory Management/Reports. I can’t get it to actually report anything in my system, but it seems appropriate if you can figure out how it works. That seems intriguing, does anyone have any experience or can provide a tutorial on this report.  Looks like you have to setup the Stock Provision Report Format to use in conjunction with the Slow Moving Stock Report.   Not seeing a clear description of the process anywhere.

6
A
2 years ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Set Default DocType on Click and Drag of an Attachment

Thank you that worked perfectly, never thought about doing it that way!

2
D
2 years ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Move Request Checkbox in MES

Yes, and oddly enough it does work on some resource groups, however I have a few that it does not work on, plus I want to ensure that the operator’s don’t click it by mistake.  I would love an example BPM or customization on that screen to ensure it stays unchecked.  I cannot quite get it.

3
M
3 years ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

DB Server Configuration

This doesn’t answer the question as you are asking it, but I think it is helpful to know that the Performance and Diagnostics tool (which is run AFTER DB and App server setup) can identify anything you’d need to do to improve performance. I am aware of the tool, I was just curious on how other people had setup their partitions and Raid levels and how you separated your SQL Logs file and ReportServer LogFile.  Thanks for your thoughts!

4
G
3 years ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Looking to add the Primary BIN to the Job Traveler

Thanks for your thoughts! I will give it a try!

4
D
3 years ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Looking to add the Primary BIN to the Job Traveler

I will give it a try, any thoughts on if I want to add the PrimBin to the root Part Number not the Materials?

4
D
3 years ago
Terms & Conditions