We have a situation where some of our larger jobs take multiple weeks to complete. During this time parts will be completed through the final operation and recorded in MES. When the final parts of the job have been completed the entire job is completed and then costed. Works well.
However, account runs the WIP capture at least monthly and it posts the labor transaction records by date and does not concern itself with whether the labor is for an inprocess or completed job. So we end up with the transactions for a job posted before the job is even completed.
This becomes a problem with there is an error in the transactions. This specific case is that the job was for 5 parts but six were completed in the final operation. I want to simply delete (or modify) the labor transaction through time/expense entry to indicate that only 5 were completed through the final operation but I cannot due to the fact that the transaction has been posted through WIP capture.
What do I do to reconcile this? I need to remove the sixth part from the final operation so that job doesn't report 6 as complete as it completely throws off the costing. The last cost is the value of the materials divided by quantity completed so we end up with dividing by 6 instead of 5. This undervalues the cost of the part.
Thoughts? Insights? Magic tricks?
Thanks,
Tom
However, account runs the WIP capture at least monthly and it posts the labor transaction records by date and does not concern itself with whether the labor is for an inprocess or completed job. So we end up with the transactions for a job posted before the job is even completed.
This becomes a problem with there is an error in the transactions. This specific case is that the job was for 5 parts but six were completed in the final operation. I want to simply delete (or modify) the labor transaction through time/expense entry to indicate that only 5 were completed through the final operation but I cannot due to the fact that the transaction has been posted through WIP capture.
What do I do to reconcile this? I need to remove the sixth part from the final operation so that job doesn't report 6 as complete as it completely throws off the costing. The last cost is the value of the materials divided by quantity completed so we end up with dividing by 6 instead of 5. This undervalues the cost of the part.
Thoughts? Insights? Magic tricks?
Thanks,
Tom