Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

GP 2016-R2 Project PTE

(0) ShareShare
ReportReport
Posted on by 10

Hi,
We have recently upgraded to MS GP 2016-R2 and are getting the attached error when we navigate to Project- PTE- Expenses.
In our organisation we extensively use Project expenses to claim / reimburse expenses. However no time sheets are being used in PTE.
Can anybody help what is this error about and how to resolve?


Best
Ahsan Khalil
​​​PTE_2D00_Timesheet-SQL-Error_2D00_GP-2016.jpg

Categories:
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP 2016-R2 Project PTE

    Try going to Transactions->Project->Time sheet Batches. Since you do not use time sheet entry there should be nothing there. If there are any batches delete them.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,004 User Group Leader on at
    RE: GP 2016-R2 Project PTE

    Try to run sql profiler, it seems to me that while filling list table getting some insertion issue in table as

    DBMS 2627 refers to a duplicate key error , so some value must be duplicating.

  • akhalil Profile Picture
    akhalil 10 on at
    RE: GP 2016-R2 Project PTE

    PFA the Screen shot as requested.

    pastedimage1571049694629v2.png

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP 2016-R2 Project PTE

    Please click the More Info button and send that screenshot. There will be a more informative message there.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans