Inventory rec- not reconciling

Kinetic ERP
1

Hi,

I am in the finance department, it is my first month using Epicor and trying to do the inventory rec by comparing the GL to quick all sites report from Epicor (All sites, WIP, DMR, Stock In transit). My rec did not balance and wanted to ask if anyone else had the same issues and what did you to fix this? Also am I using the right reports, is there any tips or guides you can give me to improve this process?

Thanks
Ilknur

2

Welcome to the group!

Can you give an example of one account maybe? I’m not certain what you are asking about.

If you want a “subledger” of your inventory GL account, I’m afraid to say that it is not possible…

3

Hi Jason,

the accounts I am comparing are: general ledger accounts I am trying to reconcile:

1002- Wip Materials
1004-Wip Labour
1003- STK Raw Materials
1005- STK finished Goods
1007- Stock in transit ( Vertex & other)
1015- Inspection

4

I am comparing these accounts to quick all sites reports:

All sites- stock
Work in progress
Damages report
Stock in transit

5

I don’t have “damages report” - that’s either custom at your place or part of a module we don’t have here.

But regardless, “reconciling” is not impossible, but it’s rough.

So, are you familiar with the Inventory/WIP Reconciliation Report? This is where you will see

  1. Part and labor transactions that posted and what accounts each one hit
  2. Part and labor transactions that have not posted and what accounts they will hit (you still have time to fix these)

And have you run Capture COS/WIP Activity? (If not, don’t run it until you have reviewed the Inventory/WIP Reconciliation Report.)