Smart-Acc e-Support

May run the script below to check on the stock whether is there any error of the Stock before or during migration.

Select Brand, 'Stock Brand not exist' as Note from AcStk where Brand not in(select Code from AcBrand)

group by Brand

Select Grp, 'Stock Group not exist' as Note from AcStk where Grp not in(select Code from AcGroup)

group by Grp

Select Category, 'Stock Category not exist' as Note from AcStk where Category not in(select Code from AcCat)

group by Category

Select Colour, 'Stock Colour not exist' as Note from AcStk where Colour not in(select Code from AcColour)

group by Colour

Select Sizes, 'Stock Sizes not exist' as Note from AcStk where Sizes not in(select Code from AcSize)

group by Sizes

Select UnitofMeasure, 'Stock UOM not exist' as Note from AcStk where UnitOfMeasure not in(select Code from AcUOM)

group by UnitofMeasure

Select UOM, 'Stock UOM not exist' as Note from AcStkUOM where UOM not in(select Code from AcUOM)

group by UOM

Select BaseUOM, 'Stock UOM not exist' as Note from AcStkUOM where BaseUOM not in(select Code from AcUOM)

group by BaseUOM