FrontAccounting forum — Low inventory.

Re: Low inventory.

null@example.com (pdevulder) — Sat, 02 Jul 2011 15:42:54 +0000

SELECT 0_item_codes.stock_id, 0_item_codes.description, item_moves.sum_qty, 0_loc_stock.reorder_level
FROM 0_loc_stock
INNER
JOIN 0_item_codes ON 0_item_codes.stock_id = 0_loc_stock.stock_id
AND 0_item_codes.inactive =0
INNER
JOIN (

SELECT stock_id, SUM( qty ) AS sum_qty
FROM 0_stock_moves
WHERE loc_code = 'CC'
GROUP
BY stock_id
) AS item_moves ON item_moves.stock_id = 0_item_codes.stock_id
WHERE 0_loc_stock.loc_code = 'CC'
AND item_moves.sum_qty <= 0_loc_stock.reorder_level

Re: Low inventory.

null@example.com (joe) — Wed, 09 Dec 2009 16:45:28 +0000

Yes, there is a table, called X_loc_stock, where X stands for the table prefix.
This table will give you the re_order levels for a location and a stock id. You can do a join with the X_stock_master table to get the stock name as well.
Example
SELECT * FROM 0_loc_stock WHERE stock_id='XXXXXX'. If you only have one location, you don't need to select this.
And you can put a name from the stock master
SELECT 0_loc_stock.*, description FROM 0_loc_stock, 0_stock_master WHERE 0_stock_master.stock_id='XXXXXX' AND 0_loc_stock.stock_id=0_stock_master.stock_id.
And so on.

/Joe

Re: Low inventory.

null@example.com (ebayram) — Wed, 09 Dec 2009 15:15:34 +0000

is there any way to do that with sql command on the phpmyadmin ?

Re: Low inventory.

null@example.com (joe) — Wed, 09 Dec 2009 08:26:46 +0000

No, not really. There is an on screen report. But there are 2 other reports that give you a good view of your stock.
The Inventory Planning Report and Stock Check Sheet.

Also remember that you can setup so emails are going to the stock location if stock is below reorder level.
In config.php about line 104, change this value to 1:

$loc_notification = 0;

Put an email on the stock location in Items and Inventory, and the location gets an email if stock is below reorder level.

/Joe

Low inventory.

null@example.com (ebayram) — Wed, 09 Dec 2009 06:49:24 +0000

Is there any report to find which items status lower than reorder level.