Viewing WIP Value Summaries
You can view and analyze the work in process values of a job or repetitive line by cost element, such as material, material overhead, resource, outside processing, and overhead. You can also drill down to detailed accounting transactions. Values are displayed in your organization's base currency.
To view WIP value information:
2. In the Find WIP Jobs and Schedules window, indicate whether to find a job or a repetitive item.
3. Enter search criteria.
If you are searching for jobs, you can enter search criteria for job, class, assembly, type, and status. This search does not use period range information.
If you are searching for repetitive item, you can enter search criteria for line, assembly, and class.
Job: Enter a specific job to search for.
Line: Enter a specific production line in which to query for repetitive schedules.
Assembly: Enter an assembly in which to query for jobs or repetitive schedules.
Class: Enter a WIP accounting class associated with the jobs or repetitive schedules to query.
Type: Enter a WIP job or schedule type.
4. Optionally, enter a period range for transactions, a posted variance range, a potential variance range, or a net activity range.
To use Reported Variances, Potential Variances, or Net Activity criteria, you must enter a period range. Reported variances are recorded variances from closed jobs or schedules. Potential variances are for jobs or schedules that are not closed or with open balances with unrecognized variances. The calculation is costs incurred minus costs relieved minus variance relieved. Depending on the timing of issue and completion transactions, this may not represent an accurate variance.
Net activity is the total of the WIP transactions for the selected period range.
If a To value is left blank, the selected records are greater than or equal to the From value. If a From value is blank, the selected records are less than or equal to the To value.
The period range information is only used for the variance and net activity criteria.
5. Choose the Find button to initiate the search, or the Clear button to clear all entries.
6. Use the WIP Jobs / Schedules window to review summary information for WIP jobs or schedules. When finished, do one of the following:
- Select a row and choose the Distributions button to open the WIP Transactions Distribution window.
- Select a row and choose the Value Summary button to open the WIP Value Summary window.
You must also enter a period range to enable the Distributions and Value Summary buttons. The quantity completed and scrapped calculations, and other data displayed in the WIP Value Summary window depend on a period range.
Note: Modify the period date range and choose the Summary button to refresh the results in the WIP Value Summary window.
Since the View WIP Value window calculates the quantity completed from the accounting transactions, and the accounting transactions may be unprocessed, you may see a different quantity in the View Discrete Jobs or View WIP Operations windows. These windows display summary quantity information that is available before the accounting occurs.
To review WIP value summary information:
The period date range defaults from values entered in the WIP Jobs/Schedules window.
The quantity of the assembly, quantity completed, and quantity scrapped during the period date range for this job or schedule is displayed.
2. Optionally, modify the period date range and choose the Refresh button to view WIP value results for a given period date range.
The WIP value results display cost information by cost element and valuation account for the job or repetitive schedule's accounting class.
The Summary alternative region displays the following information for the cost element of the job or repetitive schedule:
Costs Incurred: Costs associated with material issues/returns, resource, and overhead transactions of a job or repetitive schedule.
Costs Relieved: Standard costs relieved by cost element when assemblies from a job or repetitive schedule are completed or scrapped.
Variances Relieved: Variances relieved by cost element when a job or accounting period is closed, or when a repetitive schedule is cancelled.
Net Activity: Cost element net activity, the difference between the costs incurred and the costs and variances relieved.
3. Select the Level alternative region to view elemental cost information, incurred and relieved, for this and the previous level of the bill of material.
4. Choose the Distributions button to open the WIP Transactions Distributions window.
See Also
Using Query Find
Using Query Operators
Searching For Information
Performing Query-by-Example and Query Count