1 Topic by manojmat (edited by manojmat 04/07/2014 01:53:24 pm)

  • Registered: 04/07/2014
  • Posts: 3

Topic: Reorder level email

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.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Reorder level email

Sounds reasonable. I will look into this.

Joe

  • Registered: 04/07/2014
  • Posts: 3

Re: Reorder level email

Thanks very much Joe!

Manoj

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Reorder level email

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

/Joe

  • Registered: 04/07/2014
  • Posts: 3

Re: Reorder level email

Thanks a heap!

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

6 Reply by apmuthu (edited by apmuthu 04/13/2014 02:38:33 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Reorder level email

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

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Reorder level email

@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