New Search
<br />SMITH Tammy D <br />From:AMASHA Sharon R <br />Sent:Friday, May 29, 2009 3:26 PM <br />To:SMITH Tammy D <br />Cc:PARAPPILLY Linu; AMASHA Sharon R; PERKINS MaryBeth; WEIXELMAN Susan E <br />Subject:Job Cost Question <br />Responses in red. <br />Sharon <br /> <br />_____________________________________________ <br />From: SMITH Tammy D <br />Sent: Friday, May 29, 2009 10:35 AM <br />To: AMASHA Sharon R; PARAPPILLY Linu <br />Cc: PERKINS MaryBeth; WEIXELMAN Susan E <br />Subject: Job Cost Question <br /> <br /> <br />Hi Sharon and Linu; <br />PWA and Facilities have noticed that Fund 635 is paying expenses and Fund 631 is receiving the revenue on projects that <br />th <br />use PW employees on a FAC project. Debbie is out of the office at least until June 15 and we are trying to resolve this <br />issue. I have dissected pay period 8/03/2008 – 08//16/2008 for DV 9334 (Airport projects), and am hoping that what I <br />have learned applies to job costing as a whole. <br />DV 26 <br />Service ID 050698 <br />Work Type 1777 <br />Employee Home DeptID 9140 <br /> <br />The DSLT ACK Table for 26 050698 0000 1777 shows 635-2640 – This is where the payroll expenses are charged, correct? <br />- YES <br />The PSF Revenue ACK Table looks at the employee’s home department ID in this case 9140 generates revenue to 631- <br />9140, correct? <br />Yes, this is used in journal generate. This table contains a list of the PSF Revenue ACKs by home dept id. It is used to <br />assign the PSF Revenue ACK based on the employee’s home deptid when creating the job cost journals. (Regular and <br /> <br />adjustment journals). <br /> <br />This would explain why the expenses are in one fund and revenue in another fund. If this is correct for the airport <br />projects, than can I assume that the same is happening to PWE and POS employees coding time to FAC projects? YES <br />To correct this for future use PW and FAC have created work types that each department can use for the other <br />departments expenses which would charge the expense to the same fund that is receiving the revenue. Talk to me <br />about this – I am not understanding how you plan to implement this. <br /> <br />Thank you for looking into this and confirming if I am correct. <br />Tammy Smith <br />Financial Analyst <br />City of Eugene <br />Public Works Administration <br />Phone: 541 682-5834 <br />Fax: 541 682-6826 <br />E-mail: tammy.d.smith@ci.eugene.or.us <br /> <br />Public Works Administration - Finance is now located at 101 East Broadway 3rd Floor. <br /> <br /> <br />1 <br />