Question about Inventory Control in AC7

[SteelArt]

Hi,

Just looking around AC7 as we are thinking of running it. Anyway am I correct in thinking that Inventory control is a dynamic number which is the result of starting stock in the products table minus the stock sold in the basket table ?

Reason I ask is that I expected a sales table or transaction table of some sort but there doesn't seem to be any. The Product as an InStock value and a LowStock Value, now the InStock value could be decreased and writtn back upon checkout but then you wouldn't get left with you starting stock, unless you added your purchases onto your current InStock Figure.

Anyway any help would be welcome as from what I can see AC7 doesn't really seem to do any stock control or inventory reports etc ??

[mazhar]

In-Stock value simply represents current number of items available for product. Low-stock is used for the sake of alert. For example if you want to be notified about the quantity of an item when its in-stock value reaches 5 items, in this case you can set low-stock value to 5. You can see low inventory report at Administration > Reports > Products > Low Inventory. So its like you will specify in-stock value for your product. Then upon each sale it will take away number of items sold from in-stock value. You can check ac_OrderItems table's Quantity field to see how many items of certain product were sold for related order. Also you can check Administration > Reports > Products > Sales by Product report that will show you number of items sold in certain time period.

[RKS_213]

Okay, I see the low inventory report. What about the master inventory report? I.e. it shows every product with the available stock. Right now the people I work with complain that they have to manually check every single product page to see the current stock levels for that product. I'm too new to AC to tell them the correct way to do it, but I'm certain there has to be a master inventory report that shows all products in a single view.

[compunerdy]

They can use "product batch edit" under manage.

[jmestep]

The Manage-->Low Inventory report might meet their needs. I don't know if it would include all products, though- I haven't looked at the source code to determine that.

[RKS_213]

Product batch edit works. Thanks. Selected fields in stock displays the current stock.