In this Document

Applies to:

Symptoms

In the WIP Transactions Form, CSTFQWTX, some Jobs are showing Job Close Variance twice in different periods, which is doubling the values in GL accounting.


NAVIGATION PATH
-----------------------

1. Connect to Cost Management Responsibility.
2. Go to  Periodic Costing > View Transactions > WIP Transactions

Cause

When a Job is unclosed, the initial job close variance record is not deleted.  So, if a job is closed, unclosed, and reclosed in the same Accounting Period, the job close variance is updated to reflect the correct variance and only one accounting line is created.

However, if a job is closed, and unclosed, and then reclosed in a different Accounting Period, then another job close variance record is recorded even if no additional transactions were created against the job. This has always been the case.

Example:
The functionality is as follows:
If Job XXX is closed in the month of April 2011, it will create a job close variance record in April 2011.
If Job XXX is then unclosed in April 2011, the initial job variance record is not deleted from the wip transaction accounts table.
If Job XXX is then reclosed in April 2011, the job variance record will be updated to reflect the correct job close variance amount.
But if Job XXX is not reclosed until the next month, i.e., May 2011, then a new job close variance will be created in May, regardless if any transactions were created or not.

Therefore, two job close variance records will be shown for this job:
   -  The initial job close record in April which was not deleted when the job was unclosed.
   -  The job close record in May which was recorded when the job was reclosed in May 2011.

Solution

To keep two job close variances from being created for a job, ensure that the job is closed, unclosed and reclosed all in the same Accounting Period.