When closing jobs it appears the system uses the Work Date instead of the WIP Posting date. Unfortunately, we closed a group of jobs with a date in the future month, thus creating and unearned revenue entry. Is there a process to reverse all WIP entries and basically start over?
Otherwise my only recourse appears to post a journal entry outside of the jobs module.
Hi Mark,
It's hard to say what may have happened here. Have you looked at the detail of the Job Ledger Entries, Job Task Lines, and Job Planning Lines? Are there any incorrectly posted entries in a future period past the date? What sales invoices and dates have been posted? Anything in the future period?
Jodi
Hi Jodi,
I tried that by reversing costs using the job journal that were posted via the purchase invoice in the period after the customer invoice was posted. It zeroed out the previous cost amounts, however when I attempted to close the job again in the month that I created the customer invoice the unearned revenue was posted again thus requiring me to run the calc WIP function again for the "last date" in the job journal so that it would complete the job and reverse the unearned revenue.
I thought that by reversing any costs in the period after the customer invoice posting date it would allow me to close the job in the period I created the customer invoice.
Hi Mark,
In the Job card, navigate to the Actions tab and click Post WIP to G/L... There is a Reversal option in this window so you could reverse out the WIP for the date in the future month. Then reopen the job, set the work date to the desired closed date and run WIP again.
Jodi Christiansen
PM, Microsoft
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156