FrontAccounting forum — Reorder level email

Re: Reorder level email

null@example.com (joe) — Mon, 14 Apr 2014 07:39:27 +0000

@apmuthu

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

Re: Reorder level email

null@example.com (apmuthu) — Sun, 13 Apr 2014 14:19:33 +0000

Thanks Joe. Wiki-ed it.

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

Re: Reorder level email

null@example.com (manojmat) — Tue, 08 Apr 2014 08:10:33 +0000

Thanks a heap!

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

Re: Reorder level email

null@example.com (joe) — Tue, 08 Apr 2014 07:25:51 +0000

This has now been implemented. HG repository updated. Will also go to next minor release.

/Joe

Re: Reorder level email

null@example.com (manojmat) — Mon, 07 Apr 2014 14:23:20 +0000

Thanks very much Joe!

Manoj

Re: Reorder level email

null@example.com (joe) — Mon, 07 Apr 2014 13:58:14 +0000

Sounds reasonable. I will look into this.

Joe

Reorder level email

null@example.com (manojmat) — Mon, 07 Apr 2014 13:52:26 +0000

Version used: 2.3.20

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.