Hello,

Please check the server requirements in the documentation.pdf and make sure your server meet them.

Please pay special attention to MySQL only_full_group_by mode, it should be disabled.

Lastly please check your server error logs and let me know the error details to that I can suggest solution.

Thank you

Hi,

1. Checked the server requirements in documentation and the server, and found there is nothing missing
2. sql mode is set to - NO_ENGINE_SUBSTITUTION alone, nothing else is found
3. checked server error log, no error found,

So please help us to solve this issue, as I cant find any solution. Even I changed the limit of 5 to 15 in model, to show 15 products while searching for products in the sales,transfer and quantity adjustment models.

I can’t understand why some products having issue other not. Please share the screenshots so that I can check myself clear.

Sale won’t search the 0 quantity products in the warehouse if you have not enabled overselling in system settings. However purchase should search all the standard products (services, combo and digital type products are not searchable in purchase).

Hi,

Adding screen shot of List product, Add sales and add quantity . In the list product I have marked (one of the product which is not listing) the product which is showing in product list but not showing in other pages. Please check.

The product quantity is not 0 and its a standard product.

Have you modified any other code except limit?

There is only products with that query and it should be added automatically. Please let me know the site link with owner account detail in private reply.

Thank you

thank you very much, its working now. Thank you!