web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

I have the same question (0)
  • voiciK Profile Picture
    voiciK 40 on at
    RE: WIP associated with Job Card

    Awesome. It works!

    Thank you

  • Bryan Tschosik Profile Picture
    Bryan Tschosik on at
    RE: WIP associated with Job Card

    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
    RE: WIP associated with Job Card

    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 :)

  • Suggested answer
    Bryan Tschosik Profile Picture
    Bryan Tschosik on at
    RE: WIP associated with Job Card

    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

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,669 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,668

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans