web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / WIP associated with Jo...
Small and medium business | Business Central, N...
Answered

WIP associated with Job Card

(0) ShareShare
ReportReport
Posted on by voiciK 40

Hi all, 

When I went to a Job Card and update the Job Task Number, I came across this error: 

"Validation Results: The Job Task cannot be modified because the job has associated job WIP entries. "

pastedimage1638250693919v2.png

We don't use any WIP method, and this error could be a mistake from early days using Business Central. 

When I scrolled down to the bottom of this Job Card, I can see in the WIP and Recognition section there is a Job WIP entry resulting in $34.36:

pastedimage1638250899920v3.png

Here is that entry:

pastedimage1638251052208v5.png

Do you have any ideas how to fix this? Otherwise I cannot change the Job Task Number at all (neither can I indent the lines).

Thank you

  • Suggested answer
    Bryan Tschosik Profile Picture
    Bryan Tschosik Microsoft Employee on at

    Hi VoiciK,

    Thank you for posting your question on Communities.  This is Bryan and I can help.

    Doesn't look like there is anything in the front end to delete/remove WIP Entries when calculated.  So we'll need to get fancy:)

    1. Go to Configuration Package and create a new one for Table 1004 - Job WIP Entries.
    2. Be sure to click the 'Delete Table Records before Processing' field (But for future reference, for whoever else reads this too, be VERY CAREFUL with this field.)
    3. Then Export to Excel
    4. Open the Excel spreadsheet.  You will see the job wip entries for this Job, as well as any other job for which WIP was calculated (and not posted to G/L).
    5. Be sure to Save this Excel file for safe keeping and then make a copy of it for your changes.

    6. Now, let's stop here and ask, do all your jobs not use Job WIP?
    7.  If some of your other jobs use WIP where you calc. WIP and Post WIP, then in your Excel for making changes, just remove the Job WIP Entries for this Job, but please first read the *exception* below.
    ....If none of your jobs are using WIP, then you can remove all the lines in this Excel File except for 1 line (*EXCEPTION*).
    *EXCEPTION* - The exception is that if we have the  'Delete Table Records before Processing' field marked from step 2, we cannot import an Excel file with 0 lines.  We need 1 line.

    8. If it is true that we can remove all the lines in this Excel for this table, again because you are not utilizing the WIP functionality, then you must keep at least 1 record in this Excel.  (if you have another JOB with WIP Entries and they are supposed to be there, then leave them there, that is ok, and you do not need to worry about the next step 9).
    9. The trick then is to change a key field to a a bogus/dummy value.  So in this case, you can give the Job. No. field something that does not exist.
    10. Save that file and then import it back in and Apply Package.

    11. Then check to confirm no WIP Entries exist and go ahead and renumber the task.

    Let me know if you have any questions.

    Regards,
    Bryan Tschosik

  • voiciK Profile Picture
    voiciK 40 on at

    Thanks Bryan!

    Before I go ahead and test this out, may I ask if I go to the sandbox and change the Configuration Package, it would not have any effect on the live environment? I just want to make sure that I try your method in the test environment first so I will not somehow crash the live system - Im pretty new to BC :)

  • Bryan Tschosik Profile Picture
    Bryan Tschosik Microsoft Employee on at

    Hi VoiciK,

    No problem, good to double check.

    The Sandbox will have no affect on the Production Database.   What you do in Sandbox will not affect Production.  

    Have a nice weekend :)

    Bryan

  • voiciK Profile Picture
    voiciK 40 on at

    Awesome. It works!

    Thank you

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 750 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 534 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 287 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans