Inventory Control

[brieb]

Need the ability to tack how much inventory for certain products. Need to be able to add inventory into the system, and for sales orders to reserve and subtract from the system.

[matt@…]

Also, ... adding a default number of stock to keep on hand and link to a supplier would be handy. As in, I want 5 of a product in stock at any given time, and If I sell the 5, or this product is on a sales order, to automatically know and enter on a future / next purchase order from a supplier.

[NOIA]

Definately we need inventory management and stock control! That's the only key component missing to make this the BEST PHP BMS software EVER created! By the way, EXCELLENT program!! Keep it going!

[anonymous]

any update on this?

[vlad@…]

Any update?. Thanks for great software!.

[vlad@…]

I'm on my way to make some Inventory Control for phpbms 0.96, right now interface is ugly and seppareted from main UI, it does not have any AJAX or fancy stuff but serves it purpose.

Table:

CREATE TABLE mupi_pre.inventory (

id_inventory INT NOT NULL AUTO_INCREMENT PRIMARY KEY , id_product INT NOT NULL , id_by INT NOT NULL , amount DECIMAL( 10, 2 ) NOT NULL , date DATETIME NOT NULL ) ENGINE = MYISAM

I'll attach patches for anybody who wants a quick & dirty solution while phpbms 1.0 is not ready :)

[thijmen@…]

How its work? Replying to vlad@…:

I'm on my way to make some Inventory Control for phpbms 0.96, right now interface is ugly and seppareted from main UI, it does not have any AJAX or fancy stuff but serves it purpose. Table: CREATE TABLE mupi_pre.inventory ( id_inventory INT NOT NULL AUTO_INCREMENT PRIMARY KEY , id_product INT NOT NULL , id_by INT NOT NULL , amount DECIMAL( 10, 2 ) NOT NULL , date DATETIME NOT NULL ) ENGINE = MYISAM I'll attach patches for anybody who wants a quick & dirty solution while phpbms 1.0 is not ready :)

[thijmen@…]

Please, can you tell me how to make a inventory system in phpbms 0.96? Or, what is the status of phpbms 1.0?