In this Document

Applies to:

Goal

How To Approach Issues Related To WIP Reports Not Tallying With GL And Issues Of Cost Relieved Not Matching Cost Incurred

Solution

A. Cost Relieved does not match the Cost Incurred:

Note:
1. For Average costing org, if the final completion flag is checked, then the cost relieved is based on the actual issues to the job.
2. For Average costing org, if the final completion flag is unchecked, then the cost relieved is based on the cost of the BOM/Routing for that Job.
3. For Standard Costing, the cost relieved is based on the frozen cost of the assembly.


Possible Causes:
1. Components are under issued or over issued.
2. Components/ Resources are transacted after assembly is completed (Only for Average Costing with final completion flag checked)
3. Component/Resource cost was changed but the cost was not rolled up (Only for standard costing).
4. Some transactions are not costed yet.


Basic Data to be provided:
1. What is the type of Costing?   (Provide output of cstcheck.sql - Note 246467.1 to get the costing type)
2. Is this specific to one job or is it occuring for all jobs?
3. Provide the output of the Job.sql (Note <378348.1>) and the output of the wipjob11i.sql (Note 316142.1) for one problematic job.    (With this we can check if the components/ resources are issued appropriately or not)
4. Please provide the output of below for that problematic assembly item in excel sheet with column headers included     (This will provide details of how the cost of assembly got changed and get the current cost - useful for average csoting):
a. select * from mtl_material_transactions where inventory_item_id = '&assembly_item_id’ and organization_id = '&org_id' order by last_update_date desc;
b. select * from cst_item_costs where inventory_item_id = '&assembly_item_id’ and organization_id = '&org_id';
5. Navigate to WIP Parameters form (Costing tab) and provide screenshot of that (Only for Average costing).     (This will provide the option based on which the cost should be relieved)
6. Upload the ‘WIP Value Report’ and ‘Discrete Job Value Report ‘ for that job.    (To check the quantity / value of all the transactions related to the job)

B. WIP value report ‘Cumulative to Date’ does not match GL account inquiry (YTD) / Trial Balance Report 

Note:
This comparison may valid only under ideal conditions
1. Where the WIP valuation/Variance accounts have not been impacted by any other transactions (Inventory/Receiving/AP)
2. No manual gl adjustments have been performed
3. All entries from Inventory/WIP have been transferred to GL and there are no entries pending in gl interface.
4. There should be no inventory transaction purge and wip purge


Possible Causes:
1. Net activity as well as variance both populated for some job due to data corruption.
2. Standard Cost Update was running simultaneously when the ‘Close Discrete Jobs’ was running.

Basic Data to be provided:
1. Provide the WIP Value report output for that problematic accounting period (PTD) and (CTD)     (This will give the Net Variance and the Net Activity for each job asn well as the sum of that for that period)
2. From which period onwards did you start finding the difference?
3. Account Analysis- Subledger Detail (180 Char) for the account with from period as the first period from which the instance started and Period To populated with Source as "Inventory'.    (This will give the account balance along with the journal details that affects the account balance)
4. Run the following report for the accounts that are used in wip valuation. Do not give any date range, as we want the data for entire date range.
a) Material Account Distribution Summary report
b) Wip Account distribution summary report

References