Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Calculations for WIP in NAV 2013R2

(0) ShareShare
ReportReport
Posted on by 5

When our WIP posts, it places a debit in the work in process account on the balance sheet and a credit in WIP-clearing on the P&L (income statement).  We do this because our jobs do not invoice until the job is completed, so WIP is used as a means to keep costs on the balance sheet until the job invoices so we're not seeing on the P&L the accumulated labor and materials for the jobs that are in process.  When the job invoices, it is closed and WIP is released to the P&L.  We also only calculate WIP once a month, at the end of the month, first booking the prior month's reversal, then booking the current month's WIP balances.

I have a job that opened in April 2020 and accumulated $35,000 in costs, but has not closed as of August 31st.  In April, May, June, and July WIP calculated as $35,000, posting each end of the month and reversing on the first of the next month.  Then in July an item adjustment was made to remove a $30,000 machine from the job, but it was done by going to the job ledger and entering a -1 for that item, with no cost associated. so now the item was gone, but the cost wasn't.   When WIP calculated at the end of July, it only calculated $5,000, which tells me WIP takes the quantity and multiplies it by the cost for that part in the system.  With that part gone from the job, I'd expect it to only calculate $5k in WIP.  And that's what it did in July.  But for some reason now in WIP is including that $30,000 part in the total again, even though it has not be re-added to the job.  So what I'm seeing is:

April: 35000

May: 35000

June 35000

July 5000

August 35000

Does anyone know why WIP is doing this?

  • Bodhi Profile Picture
    Bodhi 554 on at
    RE: Calculations for WIP in NAV 2013R2

    so we need a control to block deleting item if it has balance not 0 (30,000)?

    System doesn't have this control as default.

  • Suggested answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at
    RE: Calculations for WIP in NAV 2013R2

    Hello KWayne,

    Thank you for posting on the Forum. I'm not totally certain because the WIP and Recognition is based on multiple settings and records: the WIP Method, Job Task Lines and  Planning Lines, and Job Ledger Entries. You may want to check to make sure that any Planning line of Type Budget for the $30,000 of cost doesn't still exist if in fact that $30,000 is no longer part of the Job activities.  The review will depend upon the WIP Method.  The issue will most likely require deeper investigation of the data which really can't be managed through the Forum. I encourage you to contact Microsoft Support through a Support Ticket if you are a partner or contact your partner if you are a customer running NAV 2013 R2.  You may find some helpful documentation at the folllowing:

    https://docs.microsoft.com/en-us/dynamics-nav-app/projects-manage-projects

    Thank you.

    Best Regards,

    Tom

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans