Replies posted by ktaylor_marotta

7 Replies

B
BManninNew Participant
asked in Kinetic & Epicor ERP

ACH payments - NACHA file

I’d need to see the SQL.  It looks like you’re pulling from the CashDtl table when you should be pulling from the CashHead table.  There is no reason to have an invoice number in an ACH file unless you’re doing CTX format.  It looks like, instead of pulling the payment total from CashHead you’re pulling the first payment only from CashDtl.  But I can’t comment on that without seeing the SQL. I just went back and looked at my ACH files.  The one’s I’ve written to the NACHA spec do not contain invoice numbers.  Only the CTX file does and that’s a totally different layout.  So I’m not sure why yours is pulling in an invoice number.

8
B
1 year ago
B
BManninNew Participant
asked in Kinetic & Epicor ERP

ACH payments - NACHA file

Without seeing detail, it sounds like you’re pulling the wrong amount field into the ACH file.  There is no configuration checkbox that will lead to a difference between the ACH file and the amount in Supplier tracker.  What field are you using to populate payment amount in the ACH file?

8
B
1 year ago
B
BManninNew Participant
asked in Kinetic & Epicor ERP

ACH payments - NACHA file

What version of Epicor are you running?  There are ACH files right out of the box.  The most I’ve had to do is tweak one line of their code.  I’ve noticed in the past 6 years, they’ve added files for most major banks and almost all banks use one of two standard layouts.  BofA is the exception and that’s the one I had to tweak but it was very minor.

8
B
1 year ago
W
wzalewskiInspiring
asked in Americas - New York City & New Jersey

Date format when printing to CSV

Your formula is wrong.  You’re pulling the month into the Day parameter and the day into the month parameter.  I just replicated this in Excel and I can see it in your formula.  Make the Day column D and the month column C and it should calc the date properly.  Let me know if this resolves it or if I’m missing something.Thanks,Kevin

6
W
1 year ago
K
KelleyVFNew Participant
asked in Americas - Northeast - CT, MA, ME, NH, RI, VT

Indented BOM Pulling Prior Revision

Disregard.  I found it.  We were told by our consultants that it doesn’t exist and we would need to write it ourselves which is what I was assigned to do.

4
K
1 year ago
K
KelleyVFNew Participant
asked in Americas - Northeast - CT, MA, ME, NH, RI, VT

Indented BOM Pulling Prior Revision

Kelley,What version of Kinetic are you on?  I’m trying to write an Indented BOM report as we speak.  Are you saying one exists in the software?  It must be a future version.  Kindly let me know the version you are working with.Thanks,Kevin

4
K
1 year ago
T
tokeeffeNew Participant
asked in Kinetic & Epicor ERP

How to set up Report Classes in general ledger account maintenance

Can you post a screen shot of what you’re trying to add.  I don’t see a report class on the GL Account.  On the Natural Account segment I see category and Report Category.  How you add to each of these is a little different.  Categories are maintained on the GL Setup menu.  Report Categories can either be manually entered or they can be setup as a list as User defined codes.  System Setup, System Maintenance, user Codes.  You add a type GLRepCat and list your codes on the third tab:  These codes will appear in the circled area below.  Note:  Report Category changed from a text field to a drop down field. 

2
G
1 year ago
Terms & Conditions