When you close the year and roll the P&L into retained earnings, does epicor create a transaction in GLTrans for that move, or does it magically update only the balances the GLPerBal.
I’m trying to figure out if I can roll up the GLTran transactions to do real time OLAP balance sheet calculations, or will it always be off by retained earnings
I just queried Erp.TranGLC for any transactions hitting Retained Earnings and it came up with no transactions. That leads me to believe it just updates the balances – which seems odd to me.
Ouch. Thanks
As I indicated to you privately, The rollup occurs into the SOY period balances table (Period 0). In this manner if you do the roll up and you subsequently add transactions to the previous FY, when you roll the FY again, it does not have
to worry about any transactions from the income accounts to the retained earnings, it just updates the period balance table on the balance sheet accounts.
Charlie Smith
CRS Consulting Svcs
(860) 919-1708
Right. The problem is every other balance in the system is tied to the underlying transactions which is where my reporting cubes feed from. This is an inconsistent exception.
I would also imagine the Verify Balances routine that scans through the transactions and recalculates the balances does not properly work for this account, or it has a special routine that sums up all the P&L accounts each year and puts them into the retained earnings account since there isn’t any actual year end closing entry that Epicor makes.