Kinetic & Epicor ERP

Forum for questions relating to Epicor ERP lineage (Kinetic 2021, Epicor ERP 10, Epicor 9, Vantage 8)

  • 724 Topics
  • 2,061 Replies

724 Topics

C
cchowNew Participant
asked in Kinetic & Epicor ERP

Error in creating a BAQ in Kinetic

I encountered error when trying to save my new BAQ in Kinetic 2022.1. The error message is : Query validation failed. Does anybody know what is the issue?

2
C
4 months ago
D
dinmanBrainy
asked in Kinetic & Epicor ERP

BPM Condition contains wildcard?

I've written a BPM that send up an exception when certain part numbers are entered on Sales Orders, based on our part number nomenclature. Unfortunately, over the years this nomenclature hasn't been strictly adhered to, so I'm having to get "extra" to exclude the correct parts and cannot get a wildcard to work correctly in a condition.For example, a standard part number may be something like A1454C-3-CI, where the "-3-" refers to the part category. Those are easy to exclude. However, there's also ones like A1454C-3PBA-CI, so I'm trying to get it to trigger on part numbers that contain "-3%-", but that string doesn't work. It doesn't like my percent sign between the 3 and the dash. Works great in a BAQ, but can't get it to work in the BPM, even though it doesn't throw any syntax errors.Is there a different wildcard that I should be using than % (already tried both * and ^ to no different results).

9
D
4 months ago
R
Ryan.IInspiring
asked in Kinetic & Epicor ERP

UD field error after importing via solution

Hi,I imported a solution file that contained a number of UD fields.  When I load any module with these UD fields, I get the following error(s) for each field. The only thing I thought to try was a data regen and IIS recycle, which had no effect.Has anyone ever had success importing UD fields from one DB to another?Thanks. 

2
R
4 months ago
R
Ryan.IInspiring
asked in Kinetic & Epicor ERP

Creating pilot db

Hi, I’m trying to add a pilot db, I currently only have test and live.I have the new db created, but the version isn’t current with the other db’s.   I tried to upgrade, but this error was thrown and I’m stuck here. Can anyone unscrew me?  Thanks!

2
R
4 months ago
T
tcoonsParticipating Frequently
asked in Kinetic & Epicor ERP

Physical Inventory on Serialized Parts

I’m scheduling our annual physical count next month and looking for advice on quick count entry for serialized parts.We have about 6 part numbers with higher than normal stock levels at this time, ranging from a few hundred to 18,000. I really don’t want to enter 20K count tags!Has anyone found a faster way of entering this info? Even using the export to excel and paste insert into count tag entry, it will take me 15 hours to enter one part number.We are on the latest version, but not using many of the kinetic screens yet.TIA 

3
G
4 months ago
M
MTPPKnown Participant
asked in Kinetic & Epicor ERP

Error Not enough nonconformance serial numbers specified

Seeing this error when trying to save 1 qty nonconformance on a 1qty job in Data Collection. NCR was not created. Serial number confirmed toi hav 1 qty assigned. Was able to create the nonconformance from the ERP system. What does this error mean? 

6
M
4 months ago
daniel-white
daniel-whiteInspiring
asked in Kinetic & Epicor ERP

Job Part Table

Can i directly update the Job Part Table via DMT? Every time i run the Job Part Template it says “You are not licensed to maintain this table”, If that is the case and i cannot maintain, how does the information in that table get updated? For example, Qty Completed.

7
J
4 months ago
L
lairdlKnown Participant
asked in Kinetic & Epicor ERP

Progress billing after item as shipped

We have an order where the customer only wants invoice 90% at the time of shipment, then the balance after documentation is sent.We do not want to have seperate lines on the order for this.Does anyone have a similiar situation and did you do anything in Epicor to communicate this? 

3
D
5 months ago
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

We want cost adjustments (adj-cst) created when an mfg-stk transaction to point to a different g/l account than quantity adjustments. Is there a way to specify a reason code for these transactions as opposed to the system using the gl control for Inventory COS in the company configuration record?For cycle count variances & physical inventory variances - is there a way to specify a reason code as opposed to the system using the gl control code in company configuration?

4
mwilson
5 months ago
T
tom.wrightNew Participant
asked in Kinetic & Epicor ERP

Customer Signature and Electronic Form

Hi all.Serval of our forms we require our customer to sign. Such as a quotation form  We use Kinetic / SSRS report builder / PDF report. This is emailed to the customer as an attachment file.  - is there a method to create an electronic form, where the customer can insert an e-signature and submit the form?We are trying to make it easier for our customers to sign and agree to the quotation without having to print, sign, scan and attached on a return email  There is several applications such as Jot form or Docusign for electronic forms. Has anyone found something that works with Epicor / SSRS? Thanks Tom

4
R
5 months ago
L
lairdlKnown Participant
asked in Kinetic & Epicor ERP

Requisition Entry - Purchase order Link

Currently the only way we know to get the link between Requisition and Purchase order is to create the PO through New PO suggestions. There are times when we do not want to wait until after MRP/Generate PO suggestions are run and want/need to get the Purchase order created.Does anyone know if they is possible and how?Thank you 

3
L
5 months 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
5 months ago
W
wmitchellParticipating Frequently
asked in Kinetic & Epicor ERP

PO Approvals

As a result of a change in the organisation I have a director who is now the senior approver, and cannot approve POs sent through to him. The buyer who raised the PO has this person listed as an authorised user but when the approver attempts to click the approver checkbox he gets a message saying he has exceeded his limit and it should be approved by - and his own name.Can someone help because I’m tearing my hair out with this.

8
G
5 months ago
R
rwburkeKnown Participant
posted in Kinetic & Epicor ERP

Job Opening - Controller - NW Suburb Chicago Area

Container International has a job opening for a Controller.  Epicor ERP with a manufacturing background is required.  Container International is a plastic injection molding company with 2 Chicago area locations.  The Controller position would be located in our Crystal Lake, IL location.Attached is a brief job summary.  If anyone has any interest please contact me directly at rwburke@brandtindustries.net  

0
R
5 months ago
F
FelipeKnown Participant
asked in Kinetic & Epicor ERP

Cannot update the shipping line 10.0.700.4

We are experiencing an issue with a specific customer, where we are unable to pack any of their orders. We get the error below. Does anyone have any experience or recommendations for this error. Its not report related as the order has been recreated multiple times.  

4
mwilson
5 months ago
mwilson
mwilsonGenius
asked in Kinetic & Epicor ERP

Starting Order Number More Than 6 digits

10.2.700 being DMT-loaded in a re-implementation from Vantage 5.The starting order number, XaSyst.StartOrderNum has only six digits, although order numbers are allowed with up to nine digits.  I need new orders in the target E10 system to start 1870001 which is a seven digit number.Help says the new order numbers generated will be the greater of StartOrderNum or 1 + the last order’s number on file.  However this doesn’t actually seem to be happening.  When I DMT-load orders such as 1639663, they now exist in the new system, but when I create a new order in Order Entry, the numbers created are in sequence of my earlier test orders which I’ve deleted.  In other words, I earlier entered and deleted five orders and Order Entry creates order 6, even with seven-digit order numbers already loaded into the system.Does anyone know where this sequence is being maintained, and how I can force an order into the system with a specific order number?  Thanks much!

10
mwilson
5 months ago
L
lpbInspiring
asked in Kinetic & Epicor ERP

SSRS date field problem

Seem to be having a weird issue with material tag report and this only seems to happen for one user and with one part type only labels and nothing else. quite a hard one to try to fix because i cant replicate it.the top one should look like the bottom image, im hoping that the date reverting back to the begining would help some figure out the issue. cheers 

3
L
5 months ago
M
MTPPKnown Participant
asked in Kinetic & Epicor ERP

Can I use Dashboard filters to set a dashboard to show only dates greater than 24 months ago? If so, how?

Can I use Dashboard filters to set a dashboard to show only dates greater than 24 months ago? If so, how?For example, I have a dashbaord that shows customer shipments. I want to add a tab that shows only shipment with shipment dates that are older than 24 months.

9
L
5 months ago
D
dfortson
posted in Kinetic & Epicor ERP

HCM Integrated Users - Kinetic Ideas

Good news: Epicor Ideas recently added a HCM category within the Kinetic workspace! Please submit your HCM ideas and vote on others.Epicor Ideas does not have a workspace specifically for HCM. Please help your fellow users who are standalone clients and cannot access the ideas portal-->submit/vote for a HCM workspace. 😉 Thank you! 

1
slepley
6 months ago
T
tokeeffeNew Participant
asked in Kinetic & Epicor ERP

How to set up Report Classes in general ledger account maintenance

When I set up a general ledger account, it has a Report Class drop down list.  But, I cannot add a new report class to the existing list.  How do I set up a new Report Class in general ledger account maintenance

2
G
6 months ago
daniel-white
daniel-whiteInspiring
asked in Kinetic & Epicor ERP

Loading Jobs via DMT (Old system to new system)

Can someone explain the process to migrate Jobs from your old system to your new system using the DMT? We have queries for Job Head - Part - Prod - Assmbl - Oper - Mtl which i have extracted from E9 and i am loading them into Kinetic but i feel i am missing something. What should you ensure about the jobs in the old system before transferring. Its been many years since i have done this and i am sure i am missing something. I guess i am after a Best Practice method of some sorts. Thanks.

7
mwilson
6 months ago
mwilson
mwilsonGenius
asked in Kinetic & Epicor ERP

Upgrade To Which Version?

Next month, Epicor 10.2.700 goes out of premium support.  Which versions of Kinetic have you implemented live, that have given you functional issues?  We’re staying with WinForms for now, so it’s not about the new interface for us, only about retaining functionality and introducing minimal software errors.  Please share your recommendations on the K21 and K22 versions and what you’ve seen. Thanks much,..Monty.

5
G
6 months ago
G
garybKnown Participant
asked in Kinetic & Epicor ERP

Beginning Inventory Balances Day 1 of Prior Month

Does anyone know of a good way to determine the beginning inventory balances at the start of the prior month?  I have not found where this would be stored in the tables, if at all.I have a request for data showing what the inventory balances were on day 1 of the prior month. (i.e. from today, it would be August 1st), to be run on any given day.  We are using Epicor 10.2.500.13.

10
M
6 months ago
daniel-white
daniel-whiteInspiring
asked in Kinetic & Epicor ERP

Heads UP! 2022.1.8 and a recurring MRP Issue

It seems that 2022.1.8 has (re)introduced an issue with MRP running and saying that the App server does not match in Kinetic and what is on the Server. We just upgraded to 2022.1.9 because of a fix with Lot selection on Inventory transactions and have done a provisional MRP test before we release the system for UAT and we are getting the following error - 15:01:23 Beginning of Update of PartPlant.PartRunMRP15:01:25 End of Update of PartPlant.PartRunMRP15:01:25 Starting sub-processes15:01:25 Exception has been thrown by the target of an invocation.15:01:25 -> Verify that the Appserver URL in the System Agent is the same as the URL in the Epicor Administration Console - Connection Properties15:01:25 Exception has been thrown by the target of an invocation.15:01:25 -> Verify that the Appserver URL in the System Agent is the same as the URL in the Epicor Administration Console - Connection Properties15:01:28 Scheduling Jobs...15:01:28 Erp.Internal.MR.MRPCancelledException: Cancelling

10
D
6 months ago
T
ToddHansonNew Participant
asked in Kinetic & Epicor ERP

Part Site Planning Settings for Suggested PO's

Hello,My collogue and I have been using Epicor for 6 months (replacing two others). We continue to struggle with the MRP generated suggestions related to PO’s. Would anyone be willing to share their settings with a brief explanation as to the benefit? Is there a good practical resource available on this topic? -Todd 

2
T
6 months ago
Terms & Conditions