Are you sure you don't have different stock units (PCU), status (ITMSTA), or lot numbers (LOT) ?  These would result in split stock lines.

I agree with Allison: you must have a difference elsewhere. Stock records are merged automatically as long as the following fields have the same value:

• Product code
• Site
• Location
• Pack unit
• Unit Conversion
• Lot
• Sub-lot
• Status
• Quality control request
• Serial number
• Identifier 1 (palnum)
• Identifier 2 (ctrnum)

Thank you for your help!

Yeah, I  double checked everything  and the only difference is in the STOCOU, QTY, LASRCPDAT, CREDATE, UPDDAT, UPDUSR, CREUSR, CREDATTIM and UPDDATTIME.

Here is what I think had happened. I feel like some of these records had serial numbers on them. We only track those when the product leaves the building. So somehow they were on the stock record initially and then they were wiped (as we don't keep serial numbers in stock), leaving these separate stocou transactions. Though some parts that have it are not serialized, so I can't explain those.

I am just trying to figure out a safe way to combine them now.

Thank you for your help!

Yeah, I  double checked everything  and the only difference is in the STOCOU, QTY, LASRCPDAT, CREDATE, UPDDAT, UPDUSR, CREUSR, CREDATTIM and UPDDATTIME.

Here is what I think had happened. I feel like some of these records had serial numbers on them. We only track those when the product leaves the building. So somehow they were on the stock record initially and then they were wiped (as we don't keep serial numbers in stock), leaving these separate stocou transactions. Though some parts that have it are not serialized, so I can't explain those.

I am just trying to figure out a safe way to combine them now.

Have you tried running a stock resync ? 

Yeah, I tried to run FUNSTOR with everything checked but it doesn't seem to merge it.

Can you tell me how you wiped the SNs in stock? I see no standard way to do that and if this is not done properly you might have problem trying to resue the wiped SNs.