Replies posted by mwood

12 Replies

R
richard.gardnerInspiring
asked in Kinetic & Epicor ERP

Material Burden Percentage

We are on FIFO Costing.  The one thing I have run across from time to time is if the costing method on the site tab is different….maybe set to standard vs average.  Something to double check.   On part tracker -  General - Sites - Detail

2
R
1 year ago
G
garybKnown Participant
asked in Kinetic & Epicor ERP

Beginning Inventory Balances Day 1 of Prior Month

I bullied my IT guy and got the report details for you.  It’s not pretty but it works

10
M
1 year ago
G
garybKnown Participant
asked in Kinetic & Epicor ERP

Beginning Inventory Balances Day 1 of Prior Month

I double checked with IT (I am just accounting).  We use PartTran table.PartTran.ExtCost - This is what we use for costing per transaction typePartTran.TranQty - This is what we use for quantity on the transaction typeYou just need to watch the ins and outs We have a parameter of PartTran.PostedToGL = 1….that is going to depend on how much you post.  We post our transactions Daily

10
M
1 year ago
G
garybKnown Participant
asked in Kinetic & Epicor ERP

Beginning Inventory Balances Day 1 of Prior Month

The stock status would give you the right quantity if you back date it but not the correct cost.  If quering and you need quantity only, use the part transaction history tracker running total column.  We also have a  report services report that pulls the ins and outs of inventory using part transaction history tracker and transaction type to see what the quantity and cost is each day.  I don’t know if this helps.

10
M
1 year ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

Production Detail Report

I am on FIFO Costing and assume you are on standard costing.  I run into timing issues:  labor is not completed before the receipt into inventory is done, not all the materials are issued prior to receipt, etc.  Another thing that probably would affect standard costing as well as other methods, is if the quantity completed is overstated on the operation vs the production quantity.  The system does not know it is overstated and could be holding some cost back in the job.  Have you run the WIP Report for the job to see if any cost remains in the job?  I am not sure if what you are looking at are all closed jobs or not.  At the end, I would think that your variance would match unless maybe the standard cost was updated after the job was created but before the receipt into inventory was completed. 

8
A
1 year ago
A
Anonymous
asked in Kinetic & Epicor ERP

Database Purge and Summarize in Epicor 10. Thoughts?

I believe we did TranGLC which also took care of GlJrnDtl & Tran GLC.  We went with the summarize option.  We saved the info on the tables first in a DB so we could pull information if we needed to through SharePoint. The issue we ran into was that if there were old invoices open greater than the purge date we could not adjust them, apply cash, etc.  We have monthly payment options and this caused us issues because of how the posting rules work:  They go back to that original transaction and look to see what AR account the original invoice posted to and use that.  We had to get a datafix (?).  I will see if our IT guy can reach out to you directly.

5
A
2 years ago
D
dinmanBrainy
asked in Kinetic & Epicor ERP

Ship from stock still in inventory after packed

We have the shipments go into a dock location and when we cycle count we count that location as there.  When cycle counting we match up the outstanding orders to make sure the quantity is correct and nothing is hanging out in that location falsely. 

5
D
2 years ago
A
Anonymous
asked in Epicor Life Cycle & Support Panel

Epicor Cycle count by Bin

Hi!  There was a Webinar from GHA Solutions - Simple Stock Take Solution - an alternative way to manage your inventory.  This was done through the Epicor User’s group site in May.  I would be interested to see if there are other avenues as well.

1
M
2 years ago
C
colin.williamsKnown Participant
asked in Kinetic & Epicor ERP

Physical cycle count won't post

By “it’s not creating a log file”  Do you mean when you look in system monitor or when you click details on the above errors?

3
C
3 years ago
daniel-white
daniel-whiteInspiring
asked in Kinetic & Epicor ERP

Invoiced not Received Report/Tracker

How are you processing the invoices that you are paying prior to receipt?  unreceived line, advanced billing

5
V
3 years ago
A
Anonymous
asked in Kinetic & Epicor ERP

Job Costing - Audits

Hi!  We are on FIFO too.  Part FIFO Cost Tracker is what I usually show them.  You willl need to click on inactive.  Use FIFO DATE >= a date older than the end of year. & then use production detail from there.

5
M
3 years ago
C
colleenbNew Participant
posted in Kinetic & Epicor ERP

Suspense on Inventory WIP can the GL account be change before capturing

I do not believe that you can change it after the invoice is posted. We usually just fix via a journal entry or if we see it at invoicing we do a negative miscellaneous line out of the suspense account and a positive miscellaneous line to the correct account.  $0 AP Affect as the 2 miscellaneous lines wash.

9
jana.batten
3 years ago
Terms & Conditions