When running the detailed trial balance in the SRS project folder, I believe the results are returning defaults rather than what actually posted for PM transactions.
Specific scenario:
Client has an auditor on-site and he needs/requested backup for what was sitting in the Unbilled AR and Unbilled Revenue accounts at year end. The end-user called and I of course said, "No problem! Use the Detailed TB in Project and..." Users printed the Detailed Trial Balance from Project expecting to be able to summarize by project and get to the correct ending balance. When they didn't tie (by A LOT), they started breaking it down to find discrepancies. They brought me a list of transactions they'd found in the first period that were on the project TB but never hit the GL.
I verified that the distributions on the transaction inquiry zoom matched what actually posted to the GL - which does not match the PA TB. Did some digging and it looks like the stored procedure on the PA TB is pulling from the PA31102 for those distributions - the problem is that the line item accounts can be overridden in the distributions window and when they are, the PA31102 is not updated. If this were set up like the purchasing distribution and had to be overridden at the line item level, the report would be accurate. Since those accounts are not available to override on the line item in the UI, there is a huge discrepancy and this has a major impact across the board on this site (and I'd assume many others).
I haven't found anything on this anywhere - anyone else having issues? If so, is there a solution in place to get to those details? If not, do you have any ideas on a work around without reinventing the wheel? The transaction volume is way to high to allow them to manually compile the data (and they shouldn't have to). I'm trying to build a quick solution in Smart List Builder but linking the distributions to the proper line items is a tough nut to crack!! Tackling it in SRS would mean reinventing the PA TB wheel and I hate to go there if someone else has addressed it already. Has anyone else run into this? Any help would be GREATLY appreciated!
*This post is locked for comments
I have the same question (0)
