Topics started by david.hite

19 Topics

D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Add a Column to the Where Used action.

Has anyone added a column to the “Where Used” action from Part Maintenance.  I am looking at adding if the part in the list is active to the result set.   Curious if anyone has done that and if so where do we update the “Where Used” data grid or dataview to include an additional column.  Thanks for your thoughts!

0
D
1 month ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Add gross weight to materials on Job Traveler

I am looking to add the weight to the materials on the Job Traveler.   I am trying to create a relationship from the Part Material List to the Part Master table and use the gross weight.   How ever since the material is a sub report on the Job Traveler report I am not getting the correct relationships to show up.   Has anyone added the weights on the materials sub report?  Can anyone assist with getting that relationship setup? Thanks for your thoughts!

3
fred
1 year ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Alt Methods on Job Traveler

Looking for the correct RDD to reference the Alt Method on a job traveler.  Basically we want to print both Operations on the traveler if there is a difference in the OP.   I have been playing around with the linkage, but unable to find the correct relationships so I can add this to SSRS report.  Looking for some ideas or examples.  Thanks  

3
E
1 year ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Kinetic UX Tip Sheets

Does any have any simple documentation or tips sheets that they may have created for their users when adopting the Kinetic UX.    Just curious if anyone has anything they are willing to share, trying to avoid re-inventing the wheel if possible.  :)  

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

Shipping Report with Order Number and Job Number

I am trying to find a link and create a report that lists the shipping pack list, order number, and the job number.   The order number and pack list are pretty straight forward; however I am struggling on finding a link to the job that was used to produce the ship list.  Does anyone have a BAQ that does this? or can provide me the correct linkage path.

4
J
1 year ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

BAQ to query total sales by customer to Match Income Statement

I am trying to generate a Query to get the total sales revenue by customer and then have that tie out and match the income statement line of Total Sales.  I am having difficulty tying the numbers out.  Does anyone have any advice or a sample BAQ to generate this.     Thanks for your time and thoughts!

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

Set QOH to 1

I am looking for either a DMT or other solution to set a list of Parts to QOH to 1.   The problem is I just want to sent them to 1 the previous Inventory is not valid.    Looking for a strategy to get this done for a list of parts.   Just curious if anyone has any ideas or suggestions.  Thanks

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

Income Statement BAQ Question

I am looking for a Query or BAQ to display the items sold, price, and quantity that comprise up the income statement on two accounts.   I am struggling to determine a way to compare the values that comprise the two accounts that I am trying to match up to Shipped Products.  Any thoughts??

3
A
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?

I am looking for either a DMT process or other way to mass claim the same operation on multiple jobs.  Does anyone have any experience or thoughts on the best approach to accomplish this?? Thanks

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

Aged Parts Removal

I am looking for a good way to determine if we can inactivate parts that we have not shipped or used in over 18 months for example.   I have thought about looking at the Shipping Data, Part Transactions etc.  However I have not been able to come up with a good query or BAQ to get the results.  Curious if anyone has any samples or ideas on this subject.  Thanks for everyone’s thoughts.

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

Set Default DocType on Click and Drag of an Attachment

Does anyone have any suggestions on where to add a BPM or an example of when a user clicks and drags an attachment to a job, part, etc, I want to have a default Doc Type set without the user have to click in and edit the attachment.  Would appreciate any thoughts.

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

Error on Getting Part Details

So I am getting a weird error when I go to pull Part Details in a Job.  I currently  have a ticket open with Epicor but wondered if anyone in the group had seen this before and what they did to correct it….   Business Layer ExceptionBusiness Logic ErrorBusiness Layer ExceptionBLException    Correlation ID: 00000000-0000-0000-0000-000000000000    Description: This property cannot be set to a null value.    Program: Erp.Internal.MR.CPMethod.dll    Method: _CPMethod    Line Number: 1416    Column Number: 29    Server Trace Stack:    at Erp.Internal.MR.CPMethod._CPMethod(Guid TargetAsm_Rowid, String Source_Part, String Source_Rev, String Source_AltMethod, Object hProcessInfo, Boolean msg_prompt, Boolean Use_Source_AltMethod, Boolean fromCpMethod, Boolean doRoughCutSched, Boolean& crossPlant, Nullable`1& useDate, String& useJob, String& useRev, Int32& cfgPhantomCount, List`1& opTgtJobRows, Int32 structID) in C:\_Releases\ERP\RL10.2.500.0\Source\Server\Internal\MR\CPM

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

Mass Update a Resource Group

Does any one have a DMT or other solution to do a Mass Update of specific resource groups.   Looking for some suggestions or direction to look at possibly doing that with a resource group I need to change.  Thanks

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

Move Request Checkbox in MES

Does anyone have any customization code that can control the Request Move check box on end activity in the MES screen.   I want the ability to always have that unchecked to start with.  Struggling on find the correct customization to force it to be unchecked.  Thanks as always for your thoughts and time!

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

DB Server Configuration

We are in the process of upgrading our DB Server and I was wondering if any one could give me your thoughts on how your configure your SQL DB’s to optimize performance.  We currently will have SSD’s and NVMe drive for the DB and wondering how everyone configures and places their logs and SQL files as well as what RAID version you are using.  Thanks for everyone’s thoughts!

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

Print JobTraveler via REST

I am trying to submit a job to Print the Job Traveler via the REST call.  I am having trouble getting all the parameters correct.   Does anyone have a snippet that shows how to call the REST call with example parameters, example with Job Number and Printer etc to print to.

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

Looking to add the Primary BIN to the Job Traveler

I have pondered this question before, however every time I work on this problem and modify the RDD I am wondering if I am finding the most efficient links to the table.  The problem is we use mass job traveler printing and whenever I attempt to use that style with the BIN I added it either timeouts or take an insane amount of time.  Wondering if anyone has done this and if they have any tricks to keep the Traveler’s generating quickly with the BIN added of if there is a better link, maybe to an Index field….

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

How give a field focus on MES

I am trying to figure out how to add a customization to force the Job Number to get focus when the Start Prod launches etc.   Not sure I am getting the right fields to set focus to.   Would appreciate any advice and sample code on how to give focus to the field in MES.

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

Barcoding and Devices

Question, We are looking at implementing Barcoding on the Job Routers etc.   I am looking for some suggestions and experiences with what model and type of equipment you are using.  For example we are looking at putting some stationary readers at work cells for scanning in job / assembly / op;  The device needs to be able to set the min code length to 1 so we can scan a “0” or “1” for example for corresponding assembly.  I would welcome any thoughts or ideas.

3
S
3 years ago
Terms & Conditions