How do I see the whole entire Periodic Posting Process. I’d like to trace the amounts from one GL account to the next. How do the financial statements generate the amounts?
The Periodic Posting Process affects over 20 general ledger accounts and I can not drill down or open with any source document for tracing.
Does anyone know how to see the sequence of transactions for an entire month from start to finish?
I appreciate any help. Thank you
Welcome to the forum.
What version of Epicor are you using? Is it 11.2?
I’m literally working on the same thing right now for the Purchase Variance account we have. Trying to break it down by part, supplier, and buyer by drilling into the Periodic Posting Process and the transactions that make it up.
I’m using queries though and that requires you to be familiar with the table structure… You mentioned you are new to Epicor in your bio so I don’t think you’ll be able to use this same approach.
I ask about the version you are on because I saw that in 2022.2 they added an enhancement to the way periodic posting works and how it is easier to see the details.
I feel like @timshuwy might know about it or @hkeric.wci
Welcome Laurie, the Inventory/WIP Reconciliation Report should show all of the Inventory Transactions. It can be broken down to specific GL Accounts or transactions to aid in reconciliation. Take a look at it and see if that helps.
The inventory/WIP reconciliation report does help with periodic posting. Great point Todd.
this will give you all the inventory transactions that went into periodic posting.
@Laurie To follow up on what @todd.mcgregor mentioned there are hundreds of ways to use the wip recon report to get details on the periodic posting entries.
If you have a particular entry from the GL Report with a journal and seq on the right hand side is the Specific Journal section. Captures are code IJ so you want Inventory Journal and the Seq is the Journal Num. make sure to mark only posted or both or you will get nothing. Also in your system monitor turn on notification balloons, so you will get a notification when a report is empty. Nothing more frustrating than having a report not show up because your parameters produced no results.
Each transaction type is controlled by GL control codes that are detailed in the GL Transaction Hierarchies for your version. You will need to logon to EpicWeb and search for Transaction Hierarchy.
You can also use Chart Tracker to follow transactions if you want to drill down.
Yes I am using the 11.2 version.
Thank you
@gpayne Thank you so much for all your help.
I was able to get the report I needed and I can trace it all back to the finance statements.
Great post Greg.
@Laurie please mark his post as a solution if it is a solution to your problem at the moment.
Thanks @utaylor I few years ago our controller was suddenly gone on a Monday, so the owner decided he and I would take over that role. I got 18 months of trial by fire and learned the finance side of Epicor on the fly. WIP recon has a ton of uses to show the transactions that are happening.
Very true, the hard part is summarizing it and slicing and dicing it for analytical reasoning.
@Laurie this is the new functionality I am speaking of , not sure if it comes with the newest product out of the box or what:
