Duplicate records in project accounting

(0) Share

Report

Posted on by Community Member

We are on GP2010 and have over 100 lines of duplicate timesheet data that was imported into GP and posted. These duplicated lines are identical - including the same document number. They were imported into the timesheet entry screen in project accounting and the batch was posted. The cost of the payroll has been added into the project expense totals. Does anyone know what tables are affected when timesheets are posted? Or have any ideas of how to fix this other than deleting the lines from SQL and changing totals were needed?

Thanks,
Marilyn

*This post is locked for comments

All responses (3)

Answers (1)

sandipdjadhav 18,267 on at

Like (1)

Report

RE: Duplicate records in project accounting

Great ! Thanks much for updates.
Community Member on at

Like (0)

Report

RE: Duplicate records in project accounting

Thanks for your help. I thought GP would not be happy that there were duplicate records and therefore would not let me do anything with them, but evidently PA is not as picky as some other GP modules :) All the duplicates have been adjusted out and all the data looks correct now.

Thanks,

Marilyn
Verified answer

sandipdjadhav 18,267 on at

Like (0)

Report

RE: Duplicate records in project accounting

Hello Marilyn,

Can you check Transactions-->Project Accounting--> PA Trx Adjustment --> Select Timesheets for Adjustment. You can reverse your original transaction.

Please verify it in TEST Company before going for production.

Let me know how it goes.

Thanks much
Sandip