Does anyone know what table(s) are used when adding a sub-contract operation to a job? We have a PO created for the sub-contract operation that upon receiving the line attached to the operation gives a conversion not found message (trying to convert FT to EA) even if we delete that operation from the job and then re-add it with the same operation sequence ID. Originally we had material which we track in feet (FT) attached to that operation. The PO line is for the finished product with unit of measure of EA.
I looked in the various Job related tables, TranGLC, PartTran, etc. but could not find a related record.
We got around it by deleting and adding as a different sequence ID, but I’d still like to find and/or know where it is/was keeping ahold of that UOM conversion value.
Yes, I checked those as well. All the tables I checked showed the current data (including changing the material with UOM of FT to a different operation), which is why I’m stumped as to why it kept giving me the error message.
Can you provide some more detail? If the JobOper was FT and required it in FT and the PO was written as a Subcontract PO line tied to this seq purchase UOM of EA then the system would require a UOM conversion from EA to FT to process the part tran PUR-MTL transaction. If this UOM conversion did not exist or these two UOMs where in different classes like LENGTH and COUNT then you would have this issue. Secondly, is the part number in question a stock part. If so, then it may be ordered in EA and inventoried in EA, but used in FT on the job, and you would still need this conversion option in the UOM conversion setup. Does this help a little more? If you can provide further details we might be able to get you to the right answer or reason why.
The job is setup for a part with UOM of EA, with a sub-contract operation for outside services. We have material used to make the end product attached to the first operation which has a UOM of EA as it’s a 1-1 ratio. The material in question is a sample of our raw material used to make the child part, that has to be sent out to the lab for testing purposes, and is not the actual material/part used to make the parent part. This material has a UOM of FT. It is added as an additional material to the job so we can capture the cost and material usage, and is not used at all to make the end product. The second operation in the job is the sub-contract operation which the outside service tests the sample and then heat treats the parent part, which this operation has a UOM of EA. The sub-contract PO item is created for the parent, not the sample material. When I first looked originally, the sample material was added to the first operation. We tried changing the operation on the material, but that had no effect.
All parts on the job (both parent and child) are all stocked parts.
I’m sure that’s as clear as mud. We have this kind of job operation/material setup on many jobs, and for many years, and this is the first occurrence of the conversion message showing up.