Inventory WIP Account Reconciliation - apply date 1 year in the future

We have a number of reconciliation transactions that are showing an apply date of 1 year in the future from the job completion date. We know why there is a Phantom Purge WIP to Variance occurring, but we do not understand why it’s 1 year in the future.

We created some labour transactions in the future on a different job so we ran this report to verify that our corrections were made.

Any assistance would be greatly appreciated.

I assume this report was run on unposted transactions. What’s happening is the posting is being simulated as if you were capturing COS/WIP up until 2027-07-31 because that’s the date you put in the parameters. If you ran it again and put 2027-06-30 all those MFG-VAR transactions would simulate that apply date.

If that’s posted transactions, then you need to look at the Capture COS/WIP screen and see what dates were used in the last run:

Thanks @Doug.C, I believe you’re correct. Also, yes, these are the unposted transactions. We might have hit the panic button a bit early.

We’ll run Capture in PILOT tomorrow to be sure.