Jeff,
I meant to reply to this earlier, but SO busy this time of year. I'm now typing as fast as I can and hopefully this makes sense.
I agree with @Susan Pawlowic! When a completion entry is done WIP is relieved for that work ticket. Depending on the settings in PM, if you do a partial completion, some of the WIP might stay with the work Ticket.
You are using the correct report and since you are on version 2023 I have found it to be reliable. (version 2021 and before were sketchy though).
When you run the WIP reconciliation report you have a "Reconcile To" field that you can enter. I'll call that the "cutoff date". The report will show costs that post to the work ticket on or before that date in the "Total WIP" Column. If you have completed work Tickets before that cutoff date those WIP amount show in the "Costs Recognized" column so you would subtract "Costs Recognized" from "Total WIP" to get to your reconciliation amount. The Future WIP column would show costs that were applied after the cutoff date, so that is more information that may not be necessary.
------------------------------
David Overholt
DWD Technology Group
------------------------------
Original Message:
Sent: 01-16-2025 09:48
From: Jeff Schwenk
Subject: Production Management Gurus
Agreed. But which report is used to reconcile (tie back) to the GL? As noted in first post, the report I used displayed total cost (after completion). Only after I closed the WT did the costs disappear.
------------------------------
Jeff Schwenk
Owner
Bottomline Software, Inc.
Waynesboro VA
(540) 221-4444
Improving bottom lines for over 25 years!
------------------------------
Original Message:
Sent: 01-16-2025 08:38
From: Susan Pawlowic
Subject: Production Management Gurus
My understanding is that WIP is relieved upon completion, and that closing only changes the WT status and prevents further transactions. The thought process is that if you're processing a completion, the raw materials have been consumed and the labor has been performed. If you're backflushing materials and/or labor and the work ticket has partial completions, these costs stay in WIP until "final completion", which is recognized by the quantity completed reaching the quantity planned.
------------------------------
Susan Pawlowic
Sage 100 Solutions Architect
RKL eSolutions, LLC
spawlowic@rklesolutions.com
(717) 735-9109 Ext. 4352