When new PRODUCTS are imported, a record is created in the PRODUCTS table but not in PRODBALS.
So when a stocktake is created or some reports (Product Movement, Stocktake 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 .