Does anyone have a list of subledgers for E10?
There are a few reports we use that tie to the GL, but when they don’t and we go to support they claim that “These are not subledger reports and will never tie #CloseCall”.
So funny you ask that question! I just had a conversation with someone yesterday on this very subject. Officially I guess the answer is yes they do not have “sub ledgers”, but there is several reports that should tie and do tie in our environment. The first two which are easy is AP and AR Aging reports. They are easy to get to tie out. The others we use, but have to make sure we run them on the last day of the period to tie penny for penny easily are “Advanced Payment Balance Report” > Supplier deposits or PO advance payment account, “Received No Invoice Report” > Accrued Payables balance, “Stock Balance Report” > Raw Materials Inventory/Finished Goods accounts depending on variables used and part costing type this report can get a little interesting, “COS/WIP Reconciliation Report” > Posting for WIP/COS accounts depending on how you have the GL controls set to post to what accounts depends on the variables used to run this report. I am sure there is some others, but these are the ones that I have worked with the most, and assisted our finance group with.
2 Likes
Thanks.
One of the issues we’re having is our Stock Status Report, which our controller would like to use as a subledger, is off by 53k. We asked Epicor about it and they said it wasn’t a subledger, so they couldn’t help us out.
We run this at the end of the month when no one is in the system and everything is static and still get this variance.
Any ideas what may be causing that?
Could be transactional, case sensitive transactions causing issues.
Or, we have seen issues when the part class was changed for a part which has inventory. The GL accounts are not updated.
What options is the Controller using when running the report? Including non-nettable? Non-Stockable?
Is there a block on the inventory account so that it can only be posted by the system and not Journal Entries?
Check all GL Controls for the inventory account where it doesn’t belong?
Mark W.
This is how he runs it:
As for the block, no–I believe you can make journal entries.
He says he went back through and did not see any entries made in P7. (The report was 12k off last month-end and now it’s 53k).
I’ll check through the controls. Are you thinking that maybe something is posting to it that shouldn’t be?
If there are non-nettable quantities, they won’t show up in the stock status run that way but may very well be on the GL. Also, non-Stock parts are not usually a part of inventory, so he may want to clear that one. Start there and then move on to the trickier items.
over the past 10 years I have developed a word-doc that provides insight (no pun intended) to reasons for STK-STAT report and GL not matching…
Want a copy?
1 Like
I got one from Epicor.
It wasn’t well received. 
What costing model do you all use for your parts (FIFO, STD, AVG, etc.)? I have had to assist our controllers in tying out the stock status to the GL account. You will also want to make sure any variance accounts are different than the inventory accounts to better track adjustments to cost, invoice adjustments, and etc.
Josh, we use average costing.
Would it be possible for me to get a copy of this? My office is going through the same issue.
I would also be interested in that document. Could you please send?
Thank you,
Andrea Holdmann
Controller
[M2M Machining Inc 4_Vector.jpg]
M2M Machining, Inc.
Direct (262) 378-3220
Phone (262) 679-4600
Fax (262) 679-0921
aholdmann@m2m-machining.commailto:aholdmann@m2m-machining.com
