I know what those three accounts are. However, my problem is that when I calculate the monthly amount from the raw data I found through POs and transaction history, it does not match this Income statement.
Where can I see the raw data for these three accounts in this Income statement?
I would like to know which POs or Receipts generated the PPV on this report and which adjustments generated the Inventoty/Cost Adjustment amounts on this report. Specifically, it must match this monthly amount.
Please help.
Try running the Inventory/WIP Reconciliation report for the period in question. Go to the filter tab and and filter on those transaction types.
Select the “Only Posted to GL” option
If you cannot reconcile to the accounts exactly, I would suggest using the Specific G/L Account filter and leaving the transaction type filters open in case a transaction type you aren’t expecting is hitting your account.
You can also check Chart Tracker for these accounts to double check that the only transactions hitting there are from Capture WIP and not from a journal entry or invoice entry.
If you want to use a BAQ to look up the data, I believe the table that will have all the transactions is Erp.GLJrnDtl and it should reference related POs, Invoice numbers, etc.
Everyone always asks the same exact things about their financial data. The fact that we have to resort to re-creating BAQs, dashboards, etc. to figure it out every time seems odd to me since this happens all the time.
Not knocking your solution @tsmith ! I do the same thing and that is the solution!
We built a Trial Balance Dashboard that brings all the beauty of Chart Tracker on a Mass Scale to a Dashboard, mainly PartTran/TranGLC/GLJrnDtl. Even Epicor’s Chart Tracker doesn’t have all the links. Using the Chart Tracker, has to be done one GL Account at a time.
Utah is right, the answer is always BAQ when it comes to “ease”.
As @tsmith points out you can get there using Chart Tracker, but that is a finance only tool and since finance is asking they do not know about it or how to use it. Also there are a thousand uses for the wip recon report to get to the data.
Run the General Ledger Report for the account. I am using our ppv account.
Get the Journal code and Seq from the transaction.
If it PJ you have the data, If it is IJ then you use the wip recon
use the right side for the journal code and Num
Gives you the details of the JE
Chart Tracker also gets you to the wip recon details. It takes some practice learning to move from left to right to get more details, but it goes from the journal to Part Tran in one screen.
And yes @utaylor I also have some dashboards that will do chart tracker for an entire period when you are looking the the needle in the haystack.
Thanks, I found data in Chart Tracker that matches the amounts from the accounting team.
One thing that is unfortunate is that Chart Tracker does not have PO numbers or Pack numbers that generate PPV.
Your dashboard seems like the great report I’m looking for.
This may be a rude request, but could you share the source for this BQA or dashboard?
I’m sorry if I bothered you.
@gpayne@Hally , this is what I’m talking about, give us the breadcrumbs, give us the variables in our equation that made the PPV amount what it was including the source document/table (i.e. rcvdtl, podtl, etc.)
Of course I know that. Drilling down through a large number of transactions one by one is a very difficult task. So I need a report like the one hkeric showed me.
We all do, that’s why I’m always baffled that Epicor makes each and every one of us re-make reports to make sense of the detail behind a GL transaction.
I get it, post a summarized version to the GL, that’s great, but everyone wants to know the detail behind it.
yes, which will make my finance people and I am sure others livid that they are seeing a million 1 penny transactions for ppv and rounding in the general ledger report from what used to be one entry. Yes they did leave a way to reverse it, but there was already an option in the posting rule to not summarize if you wanted all of that. Our accountant had done that, but when I temporarily took over his role in 2020 I made it back to summary.
My question seems to have been directed in a slightly different direction, so I’d like to ask it again.
The accounting team is always asking or demanding from the operations team the amounts in their accounting books. But, there are many cases where the amount managed by the operations team does not match the amount in the accounting books. This is because the accounting books contain not only the amounts directly generated by the operating team, but also many other factors such as General Journals, indirect operating results and others.
So I want to tell the operations team which items create amounts in this account in the ledger.
Their answer is a great help to me. But, the information from those menus shows only the transactions that occurred. Of course, I will know most types by looking up from a long time ago. It is too hard, and there may be a type that will not happen yet. So I want to see the accounting book setting.
Yes they did leave a way to reverse it, but there was already an option in the posting rule to not summarize if you wanted all of that. Our accountant had done that, but when I temporarily took over his role in 2020 I made it back to summary.