When new PRODUCTS are imported, a record is created in the PRODUCTS table but not in PRODBALS.
So when a stock-take is created or some reports (Product Movement, Stock-take sheets, etc ) are run, they do not pick up the new products to include.
The PRODBALS records can be created by opening each record and saving it
do another import – PRODUCT LOCATION -and bring in two columns
product code and location
and that will create the PRODBALS .