Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Timesheet Approval PDK GP2013

(0) ShareShare
ReportReport
Posted on by 12

We have encountered an error that I have not seen before when we are trying to 'Approve' a timesheet, entered in BP and the approval is happening in PDK.

From the Timesheet Approval - using Administrator rights - we select the desired timesheet, change to APPROVE and click process.

An error is generated 

And when you click on OK the error goes away.

When I look at the PA00511 table I see data related to the Customer , Fiscal Year and Period ID along with a series of values - not posting the entire page -

When I do a quick query of the table, I find that there are 12 lines per customer, per fiscal year.  And when I read the error above, it is referencing Customer MCWCON001, fiscal year 2015, and Period ID 8

There is only one line that matches this in the table.

Of interest, after clicking ok, the error goes away and the Timesheet is then available in the Project >> Transactions >> Timesheet Entry (or inquiry) screen and is correct in all form.  We have printed an edit list of the timesheet and there are no errors reported by the system.

How to do I determine what the 'duplicate key' is?  How to I search the table and find errors.

Any suggestions?

*This post is locked for comments

  • Bill Campbell Profile Picture
    12 on at
    RE: Timesheet Approval PDK GP2013

    Andy, as soon as I can get this tested - if still an issue with the client, I will let you and post a reply at that time.

  • Suggested answer
    Andy Sather Profile Picture
    on at
    RE: Timesheet Approval PDK GP2013

    Typically this is an issue with your Periodics.  Here is a KB that should take care of the message:

    http://support.microsoft.com/en-us/kb/859302

  • Bill Campbell Profile Picture
    12 on at
    RE: Timesheet Approval PDK GP2013

    Someone has to have some idea of how to confront this issue?  Anyone got any suggested scripts or tools?

    Client can work through this issue, but I would like to resolve for them.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans