Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Using Planning Worksheet versus Req Worksheet error.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

When I attempt to use the Planning Worksheet I get the following error in NAV 2017.

The Req.Wkh.Template already exists.  Identification fields and values; Name='Planning'

Any help here?

*This post is locked for comments

  • Suggested answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at
    RE: Using Planning Worksheet versus Req Worksheet error.

    You’re looking in the right place. I thought it the field was set invisible by default, but it looks like it’s not part of the page.

    It’s pretty simple to add the field to the page from the NAV Development Environment > Object Designer > Page ID 293 Req. Worksheet Templates.

    The field “Type” is already part of the Table and just needs to be added to the page.

    Also, just looking at the screenshot, I can tell that things aren’t right.

    The Page ID field for the “PLANNING” row needs to be set to 99000852 (Planning Worksheet); the one for “FOR. LABOR” should be set to 99000886 (Subcontracting Worksheet). Only the “REQ” one should point to Page ID 291 (Req. Worksheet). You can correct these changes right from the page you’re on. Then, add the Type field as noted above and correct the Type for each record as well.

    Note: For the steps on adding the Type field to the page, you’ll need access to the NAV Development Environment, so please check with your NAV admin or partner for assistance if you are not authorized to access the development environment or change NAV objects. And be sure to export a backup of any object you plan to change.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Using Planning Worksheet versus Req Worksheet error.

    4150.Capture.JPG4760.Capture2.JPG

    Thank you so much for your quick reply.  I am not able to add the "Type" to this sheet.  Is this where it should be?

    Thank you

    Linda

  • Suggested answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at
    RE: Using Planning Worksheet versus Req Worksheet error.

    Hi Lshammer47,

    Please navigate to the page called "Req. Worksheet Templates", and make sure the column named "Type" is visible (if it isn't, right click the Column headers and add the field as a column; if using the Web Client of NAV, click the Designer icon to add the field).

    By default, you will likely see 3 rows here. Check what the Type associated with the row named "PLANNING". The Type should also be "Planning". If the Type shows a different value, someone may have accidentally changed it; click the field and you will be presented with a drop-down. Set it to "Planning", and try again.

    As an FYI, the other two rows you will generally see there are: "FOR. LABOR" and "REQ". Each of these rows will have a Type of the same name ("For. Labor" and "Req.", respectively).

    I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans