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.

Have you tried running a stock resync ? 

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

maybe try doing a stock change on all those products. Like change the location to this 1 location and then change it back to the original location

Yeah, that definitely fixes the issue. I have a huge list of parts, so I was trying to avoid doing it one by one. Was hoping there was a mass update or if there was a SQL query I can run. Thank you!

Then I think the simpliest is to issue the stock (quite simple via import template SMO) and then re-creating the stock (import template SMR). With very small changes in the template, you can even use the same file in both import.

Of course, please validate the process in a test folder before using it in a Live environment.

You should be able to fix all the errors at once.

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.