Financial Processing Tools and Techniques for Clarity Educational Community
Explore the tools and techniques for financial processing within the Clarity Educational Community, presented by Dave Wachsmann and Dave Matzdorf. Learn about timesheets, post-transactions, WIP management, time reporting, enabling financials, and more. Dive into the world of financial processing with this comprehensive overview.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
www.regouniversity.com www.regouniversity.com Clarity Educational Community Clarity Educational Community Tools and Techniques for Financial Processing Presented by: Dave Wachsmann & Dave Matzdorf | Date Prepared: April 10, 2015
Financial Processing Overview Timesheets Submitted Job: Post Timesheets Job: Post Transactions Correct Errors Yes Invalid Transactions No Transaction Entry Post to WIP WIP Job: Import Financial Actuals Approve WIP Adjustments Adjustments 2 2 Clarity Educational Community Clarity Educational Community
Enabling Time Reporting Resource Open for time Track Mode of Clarity Time period between Date of Hire and Date of Term Team member Open for Time Assigned to a task Project Open for time Track Mode of Clarity Task Open for Time Parent Task Open for Time 3 3 Clarity Educational Community Clarity Educational Community
Enabling Financials Resource (PAC_MNT_RESOURCES) Department Location Transaction Class Resource Class Financially Active Project (PAC_MNT_PROJECTS) Department Location Financial Status Financial Type Rate Matrix 4 4 Clarity Educational Community Clarity Educational Community
Post Timesheets 5 minute delay after approval Timesheet Status (PRTIMESHEET.PRSTATUS) Timesheet hours to Assignment time slice Export transactions (PRTIMEENTRY.PRRMEXPORTED) Transaction Table (IMP_TRANSACTIONIMPORT) Import Status (IMPORTSTATUS) Invalid Transactions (IMP_TRANSACTIONIMPORTERRORS) SELECT E.ERRORCODE, E.DESCRIPTION, COUNT(*) FROM IMP_TRANSACTIONIMPORT TI JOIN IMP_TRANSACTIONIMPORTERRORS E ON TI.ERROCODE = E.ERRORCODE GROUP BY E.ERRORCODE, E.DESCRIPTION 5 5 Clarity Educational Community Clarity Educational Community
Transactions Entry Commonly used for non-labor Loaded directly to staging table (PPA_TRANSCONROL) Source module 50 XOG 51 Timesheet 52 Voucher Expense 53 Voucher Other SELECT * FROM PPA_TRANSCONTROL TC JOIN PPA_TRANSCONTROL_VALUES TCV ON TC.TRANSNO = TCV.TRANSNO WHERE TC.SOURCEMODULE IN (52, 53) 6 6 Clarity Educational Community Clarity Educational Community
Post To WIP Move priced transactions into WIP Table (PPA_WIP) Values table and currency types (PPA_WIP_VALUES) Status SELECT * FROM PPA_WIP WIP JOIN PPA_WIP_VALUES WV ON WIP.TRANSNO = WV.TRANSNO WHERE WV.CURRENCY_TYPE = 'HOME' AND WIP.STATUS = 0 7 7 Clarity Educational Community Clarity Educational Community
Adjustments Timesheet Adjustments WIP Adjustments SELECT * FROM PPA_BILLINGS B JOIN PPA_BILLING_VALUES BV ON B.TRANSNO = BV.TRANSNO WHERE BV.CURRENCY_TYPE = 'HOME' AND B.STATUS = 0 8 8 Clarity Educational Community Clarity Educational Community
Import Financial Actuals Populate dollars in OWB / MSP Uses values from wip on assignment PRASSIGNMENT.ACTCOST_SUM PRASSIGNMENT.ACTCOST_CURVE 9 9 Clarity Educational Community Clarity Educational Community
Sample Job Schedule Post Timesheets Daily 6:00 pm Post Transactions Daily 6:30 pm Post to WIP Daily 6:45 pm Import Financial Actuals Daily 7:00 pm 10 10 Clarity Educational Community Clarity Educational Community
Questions We hope that you found this session informative and worthwhile. Our primary goal was to increase your understanding of the topic and CA PPM in general. Phone 888.813.0444 Email info@regouniversity.com There were many concepts covered during the session, if you would like to contact any presenter with questions, please reach out to us. Website www.regouniversity.com Thank you for attending regoUniversity 2015! 11 11 Clarity Educational Community Clarity Educational Community
