Hi,
I would like to see a couple of new variables added to the product table (and stock reorder report). The first would be "supplier SKU" and the second would be "bin" (e.g. where the product is stored). The "bin" would also, obviously, be useful on the packing list.
I know that this is unlikely to ever, ever happen but I'll ask anyway. Is it possible to PLEASE separate out the SKU from the UID of the product? A database should never be keyed on a user modifiable field. Failing that, please add a separate SKU field and hide the current product ID completely. Then show the SKU on the packing list and invoices, etc.
If it's still not possible, could you build a method of changing the key everywhere rather than just effectively losing the child records?
Also, from the order processing view, if you "view" an order line, I would like to see the stock level of the product and be able to change it, if necessary.
I would like to see a couple of new variables added to the product table (and stock reorder report). The first would be "supplier SKU" and the second would be "bin" (e.g. where the product is stored). The "bin" would also, obviously, be useful on the packing list.
I know that this is unlikely to ever, ever happen but I'll ask anyway. Is it possible to PLEASE separate out the SKU from the UID of the product? A database should never be keyed on a user modifiable field. Failing that, please add a separate SKU field and hide the current product ID completely. Then show the SKU on the packing list and invoices, etc.
If it's still not possible, could you build a method of changing the key everywhere rather than just effectively losing the child records?
Also, from the order processing view, if you "view" an order line, I would like to see the stock level of the product and be able to change it, if necessary.
Comment