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

I have the same question (0)
  • Suggested answer
    TWBlaisdell Profile Picture
    on at

    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

  • Bodhi Profile Picture
    558 on at

    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.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans