Combining Stock Records

Question

Looking at the Stock table, I see that I have a lot of cases where a product is listed multiple times with a different STOCOU number. Everything else is identical (except for the quantities). 
 For example: Product (ABC), STOCOU#, Bin Location and Qty. 
 ABC 3837838 W180 25 ABC 3815780 W180 5 ABC 3802076 W180 1 ABC 3835948 W180 1 ABC 3641630 W180 1 
 I checked STOALL to see if anything is allocated to these STOCOU numbers and none of the were in there. Is there a way to combine these 5 records into 1 record with QTY of 33? 
 
 Thank you for your help!

Julien Patureau · Answer

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)

Julien Patureau · Answer

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.

Sage X3

Combining Stock Records

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING