For these simple queries, there are no performance advantages using INNER JOIN in MySql. The WHERE clause is easier to read for not so experienced users.

/Joe

Can the first clause of the WHERE statements in the changed files be part of an INNER JOIN clause?

Affected files:
inventory/includes/inventory_db.inc
sales/includes/db/sales_order_db.inc

Tested for negative adjustment and transfers with the changed files and it works perfectly!

/Joe

Manoj

Joe

Hi, first thanks for this great piece of software!

I've observed that the reorder email is not being sent if there is a location transfer or negative inventory adjustment, and inventory level falls below reorder level. It's only triggered if a sales event reduces the inventory level at the particular location.

I've a certain use case where FrontAccounting is being only used for inventory management and almost all transactions will be location transfers or negative adjustments. Would be nice if Frontaccounting could check inventory levels for reorder notification after any kind of inventory transaction.