Replies posted by luann.stephenson

5 Replies

L
luann.stephensonInspiring
asked in Kinetic & Epicor ERP

Controlling the Inventory Adjustment account used for cycle count variances, physical inventory variances, cost variances created during the mfg-stk transaction

Thank you for your response. Yes, I see the option for cycle count and physical.But, what about transactions through the Job Adjustment form. It doesn’t prompt for a reason code in this screen. Both the subcontract adjustments and material adjustments appear to use the Inventory Adjustment field in the GL control, and neither appear to give me option for a reason code.Also, when a mfg-stk transaction is created, there can be a corresponding adj-cst transaction. I can’t find a way to specify reason code (to control the inventory adjustment account used).

4
mwilson
1 year ago
A
Anonymous
asked in Kinetic & Epicor ERP

KPI report for Purchase Orders?

You can create a BAQ in Epicor to provide this information. You can then, (1) Run the baq and export to excel, (2) Create a dashboard from this BAQ (which can also be exported to Excel), or (3) Create a BAQ report from the BAQ created. The BAQ would use tables (1) POHeader, (2) PurAgent (this is the buyer table with the buyer name)The formula for po count would be:  count(POHeader.PONum)The fomula for week end date would be : DATEADD( DAY , 6 - DATEPART(WEEKDAY, POHeader.OrderDate), CAST (POHeader.OrderDate AS DATE ))

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

DMT - LaborTypePseudo

We currently use TE Labor Detail template and the Job Labor adjustment for making labor adjustments. We use the Job Labor Adjustment entry for job adjustments, and the TE Labor Detail for indirect labor, but both should work.

1
L
2 years ago
M
Michaela.HKnown Participant
asked in Kinetic & Epicor ERP

MES Current Work by Resource

Another option (I think closer to what you want)BAQ: List of Job / Assy / Current Open OperationI attached instructions on how to set this up.I do it by assemblies because we have multi level jobs on which multiple subassemblies can be simultaneously worked on. 

4
M
3 years ago
M
Michaela.HKnown Participant
asked in Kinetic & Epicor ERP

MES Current Work by Resource

For the BAQ, you can use the JobOper table. One table I’ve used for this type of information (holds schedule detail) is a table titled ResourceTimeUsed.This table holds the current schedule with the resource information. Make sure to filter on WhatIf = 0.

4
M
3 years ago
Terms & Conditions